Access Denied when connecting

Giganews Newsgroups
Subject: Access Denied when connecting
Posted by:  Rick (Ri…@discussions.microsoft.com)
Date: Fri, 27 Jul 2007

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?

Replies