Cannot generate SSPI context

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...
>

Cannot generate sspi context

I am using Win2k server(sp4) and Sql 2000(sp4). When register from
enterprise manager by using windows authentication , it was showing 'cannot
generate sspi context'.
When I use FQDN to register, it work fine
Regards,
George.Did you check the event logs on the box where you are trying
to register SQL Server? Look especially for DNS issues,
possibly windows time service issues.
Did you try connecting with named pipes - if that's enabled
on the server?
-Sue
On Thu, 24 May 2007 03:51:00 -0700, George
<George@.discussions.microsoft.com> wrote:

>I am using Win2k server(sp4) and Sql 2000(sp4). When register from
>enterprise manager by using windows authentication , it was showing 'cannot
>generate sspi context'.
>When I use FQDN to register, it work fine
>Regards,
>George.|||Looks like a service principal name (SPN) registration issue! Can you try
troubleshooting steps as in below article ?
http://support.microsoft.com/kb/811889 - How to troubleshoot the "Cannot
generate SSPI context" error message

> enterprise manager by using windows authentication , it was showing 'canno
t
> generate sspi context'.
> When I use FQDN to register, it work fine

Cannot generate sspi context

I am using Win2k server(sp4) and Sql 2000(sp4). When register from
enterprise manager by using windows authentication , it was showing 'cannot
generate sspi context'.
When I use FQDN to register, it work fine
Regards,
George.
Did you check the event logs on the box where you are trying
to register SQL Server? Look especially for DNS issues,
possibly windows time service issues.
Did you try connecting with named pipes - if that's enabled
on the server?
-Sue
On Thu, 24 May 2007 03:51:00 -0700, George
<George@.discussions.microsoft.com> wrote:

>I am using Win2k server(sp4) and Sql 2000(sp4). When register from
>enterprise manager by using windows authentication , it was showing 'cannot
>generate sspi context'.
>When I use FQDN to register, it work fine
>Regards,
>George.
|||Looks like a service principal name (SPN) registration issue! Can you try
troubleshooting steps as in below article ?
http://support.microsoft.com/kb/811889 - How to troubleshoot the "Cannot
generate SSPI context" error message

> enterprise manager by using windows authentication , it was showing 'cannot
> generate sspi context'.
> When I use FQDN to register, it work fine

Cannot generate SSPI context

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...
>