SQL Server Connection String - Different Domain

Question

I have a SQL Server connection string in a config file:

<add name="DbMaster" connectionString="Data Source=ServerName\NamedInstance;Initial Catalog=SomeDb;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

This is fine if I am running from the domain where the SQL Server is located, but I receive the following error on a different domain:

System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

There is a trust between the domains.

I tried the following with no success:

<add name="DbMaster" connectionString="Data Source=ServerName.DOMAIN.COM\NamedInstance;Initial Catalog=SomeDb;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

I can ping ServerName.DOMAIN.COM.

I have tried connecting to the SQL Server on a different domain using SQL Server Management Studio but the same error as above is received.

Is there something obvious I am doing wrong?

Have you verified that SQL Server is configured to accept remote connections as the error message indicates? — Phil Hunt
– Phil Hunt, Commented Dec 1, 2010 at 15:46
Yes, the server has been configured to accept remote connections. — youwhut
– youwhut, Commented Dec 1, 2010 at 15:48

Justin Niessner · Accepted Answer · 2010-12-01 15:48:18Z

3

If Management Studio is giving you the same error, the problem isn't with your application. The problem is with your SQL Server configuration.

Either the Trust between the Domains isn't properly configured to enable Integrated Security across domains or the SQL Server isn't properly configured to allow remote connections (like the error message states).

Integrated Security across domains is usually much more hassle than it's worth. Using SQL Server Authentication will relieve most of your headaches.

answered Dec 1, 2010 at 15:48

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server Connection String - Different Domain

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related