Roman Rehak

SQL Server and things not related

<December 2008>
SuMoTuWeThFrSa
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910


Navigation

SQL Server Sites

Subscriptions

News

eXTReMe Tracker

Post Categories



Sunday, May 08, 2005 - Posts

Roman's Weekly SQL Server Tip - Using Windows Authentication across domains

If you try to connect to a SQL Server in another domain in the forest using Windows Authentication, you might end up getting this error:

  A Connection could not be established to YourServer.
  Reason: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection...

This is a common problem on some networks, basically TCP/IP is not passing windows credentials along and a trust relationship is not established across domains. This is a complex issue, you can get more details in this KB article.

But, you still might be able to connect with the Named Pipes protocol instead of TCP/IP, that usually does the trick for me. You can create an alias with SQL Server Client Network Utility and select Named Pipes as the protocol and then use the alias in your connection strings or when registering the server in Enterprise Manager. Another option for enforcing NP is to include “Network Library=dbnmpntw;“ in the connection string.

 

posted Sunday, May 08, 2005 8:29 PM by Roman with 769 Comments




Powered by Dot Net Junkies, by Telligent Systems