2
Vote

The LDAP server is unavailable. (Microsoft.SqlServer.DTSPipelineWrap)

description

I am using sql2014 component on Visual Studio 2013 ( OS -> windows 7 64 bit )
When I try to add the LDAP source, I get following error.

The issues is resolved when I connected my computer to domain. Hope it helps someone.

TITLE: Microsoft Visual Studio

The component could not be added to the Data Flow task.

Could not initialize the component. There is a potential problem in the ProvideComponentProperties method.

ADDITIONAL INFORMATION:

Error at Data Flow Task [LDAP Source [1]]: System.DirectoryServices.Protocols.LdapException: The LDAP server is unavailable.
at System.DirectoryServices.Protocols.LdapConnection.Connect()
at System.DirectoryServices.Protocols.LdapConnection.SendRequestHelper(DirectoryRequest request, Int32& messageID)
at System.DirectoryServices.Protocols.LdapConnection.SendRequest(DirectoryRequest request, TimeSpan requestTimeout)
at System.DirectoryServices.Protocols.LdapConnection.SendRequest(DirectoryRequest request)
at SsisLdapSource.DirectoryServicesProtocolsExtensions.Schema.GetDefaultNamingContextDN(LdapConnection ldapConnection)
at SsisLdapSource.InstantiationTime.CustomPropertiesDefaultValueFactory.GetBaseDN()
at SsisLdapSource.InstantiationTime.CustomProperties..ctor()
at SsisLdapSource.InstantiationTime.CustomPropertiesInitializer..ctor(IDTSComponentMetaData100 componentMetaData)
at SsisLdapSource.SsisLdapSource.ProvideComponentProperties()

at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProvideComponentProperties(IDTSManagedComponentWrapper100 wrapper)

The LDAP server is unavailable. (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK

comments

rloone wrote May 25, 2016 at 2:12 AM

I also get this, but I am connected to a domain already. Any additional ideas?

wrote May 26, 2016 at 1:55 AM