trusted SQL Server connection..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 04 Jul 2005 03:00 GMT

I am trying to connect to different machine (SQL SERVER that is
172.131.31.211) but giving me the following error.
---------------------------
SQL Server Enterprise Manager
---------------------------
A connection could not be established to 172.131.31.211.

Reason: Login failed for user 'sa'. Reason: Not associated with a trusted
SQL Server connection..

Please verify SQL Server is running and check your SQL Server registration
properties (by right-clicking on the 172.131.31.240 node) and try again.
---------------------------
OK
---------------------------

Any idea what I have to do ?

Thanks

Reply to this Message

Mike Epprecht \(SQL MVP\) - 04 Jul 2005 05:11 GMT

The SQL Server is setup to only accept NT Integrated trusted connections and
you are trying to connect with SQL Server Authentication user account sa)

In Enterprise Manager, under Properties, you can set what SQL Server allows.

Book Online has good information on this.
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

>I am trying to connect to different machine (SQL SERVER that is
> 172.131.31.211) but giving me the following error.
[quoted text clipped - 15 lines]
>
> Thanks

Reply to this Message

Roy - 06 Jul 2005 04:17 GMT

Thanks

> The SQL Server is setup to only accept NT Integrated trusted connections and
> you are trying to connect with SQL Server Authentication user account sa)
[quoted text clipped - 31 lines]
> >
> > Thanks

Reply to this Message