Thursday, March 8, 2012

connection failed... not associated with a trusted SQL Server connection

Using Query Analyser, I cannot log in using the SQL 'sa' user name and
password. I get an error saying "connection failed... not associated with a
trusted SQL Server connection" When and where can the 'sa' credential be
used without creating this error?
thanks,
Keith
Hi,
Change the authentication mode to Windows and SQL server and try connecting
using SA.
How to change:-
1. In Enterprise Manager -- Expand the Server
2. Right click on the server name and select propertirs
3. Choose the security Tab and select SQL Server and Windows
4. Click ok and restart the windows service.
Thanks
hari
SQL Server MVP
"keithb" <k31thb@.yahoo.com> wrote in message
news:utbk$LIuFHA.3740@.TK2MSFTNGP14.phx.gbl...
> Using Query Analyser, I cannot log in using the SQL 'sa' user name and
> password. I get an error saying "connection failed... not associated with
> a trusted SQL Server connection" When and where can the 'sa' credential be
> used without creating this error?
> thanks,
> Keith
>

No comments:

Post a Comment