Hello to all, thanks for any assistance...
This problem just started with in the last day. Accessing a SQL Server from
Enterprise Manager(EM) on my note book. However when I access via EM on the
local sql server, windows authentication works fine...
A connection could not be established to SERVERNAME
Reason: SQL Network Interfaces: The target principle name is incorrect
Cannot generate SSPI context
Also the following appears in the server log
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
From same EM, I can access using SA/password and connect fine.
The server is mixed mode. Thanks for any directions...
http://support.microsoft.com/kb/811889/en-us
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Covi" <Covi@.discussions.microsoft.com> wrote in message
news:0937E03C-38BB-438D-B000-7D802D7E6230@.microsoft.com...
> Hello to all, thanks for any assistance...
> This problem just started with in the last day. Accessing a SQL Server
> from
> Enterprise Manager(EM) on my note book. However when I access via EM on
> the
> local sql server, windows authentication works fine...
>
> A connection could not be established to SERVERNAME
> Reason: SQL Network Interfaces: The target principle name is incorrect
> Cannot generate SSPI context
> Also the following appears in the server log
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection.
> From same EM, I can access using SA/password and connect fine.
> The server is mixed mode. Thanks for any directions...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment