Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot generate SSPI context

Author  Topic 

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2011-08-02 : 17:46:23
Hi,

We are receiving the following error message when trying to connect from a SQL Server 2005 Management Studio to a SQL Server 2005 database on a different server on the same Domain.

"Cannot generate SSPI context - Login failed for user . The user is not associated with a trusted SQL".

So what is cauase of this message and how to solve it?

Thanks


tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-02 : 17:59:03
Google the error, it's widely asked about.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -