Problem with Connection Manager

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

Problem with Connection Manager

Author

Topic

cospow
Starting Member

3 Posts

Posted - 2009-10-11 : 07:07:48

Hi Everyone,

I am trying to add a ADO.NET connection manager for OLEDB -

.Net provider for OLEDB\OLEDB Provider for Microsoft directory
Services, for one of the data flow tasks to connect to Active
Directory. But in the connection manager dialogue, no matter what ever
the server name I give in Server or File name input text box, the
connection is succeeding.

Say for example, I give xyz or 123, which are not the names of server and test the connection, it is succeeding. Has anyone ever had this kind of situation? Please
advice.

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-10-15 : 06:26:47

This is the connection string to connect to Directory Services:


Provider=ADsDSOObject;Integrated Security=SSPI;

The server name is not required. It will succeed if you leave the server name blank on the GUI.
I'm guessing the server name is just on the GUI but ignored when creating the connection. Don't know how to verify this.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources