Hi, we recently installed Active Directory here and I can no longer connect to our SQL Server 2005 box. Active Directory was installed on a different server and my development machine was added to the Active Directory. The AD server was also made a domain controller and my development machine was also added to the domain. The SQL Server sits outside the domain, and is NOT included in AD. Now when I attempt to connect via SQL authentication in my c# code, I get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
If I attempt to connect to the SQL Server box using SQL authentication from SQL Server Management Studio, the connection attempt simply times out. However, if I change the protocol used to connect to Named Pipes, I am able to connect to the SQL box.
Can anyone tell me why I cannot connect to the SQL box using SQL authentication and TCP/IP anymore?
I apologize if this post is misplaced.
I'm moving your question to the database engine forum where I hope they can help...
Paul
|||What is your connection string? If it is "<machinename>\<instancename>", then you could try to change this to "<machinename>\<instancename,<portnumber>". Maybe this will help.
No comments:
Post a Comment