Saturday, February 11, 2012

Access Denied when connecting

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?
What type of authentication are you using Windows or SQL?
If you are using SQL login, you should be able to connect as long as you can
ping the server. Since your SQL server is on a different Domain, and you
want to use your Windows domain account, make sure that you have a trust
relationship between the 2 domains if you login to one domain and want to
access the other one.
Ayad Shammout
"Rick" <Rick@.discussions.microsoft.com> wrote in message
news:BAD23A07-CEB4-4A33-BC0C-2B5C61602812@.microsoft.com...
>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?

No comments:

Post a Comment