sql server connect: SQL 2005 Connection Issue -- sql server connect

SQL 2005 Connection Issue

Rick
7/27/2007 11:42:01 AM

sql server connect:

I am having a problem connecting to my SQL 2005 named instance on a clustered
server in another domaim. If I am within the domain everything works fine. If
I am in a different domain, I cannot register it through SQL Management
Studio or create an ODBC connection. I can ping it and all of the cluster
nodes. When trying to connect I get the following errors:

SQL Management Studio:
"An error has occured while establishing a connection to the server. When
connecting to SAL 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)

ODBC:
SQL Server Error: 17
ODBC SQL Server Driver SQL Server does not exist or access denied

However, the server is set up for remote connections.

Any Suggestions?

Re: SQL 2005 Connection Issue

Andrew J. Kelly
7/27/2007 4:11:32 PM

I assume you are trying to connect with Windows authentication. If so it
sounds like the 2nd domain is not trusted by the first or that account is
not set up as a Login in SQL Server.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]