domain accounts & SQL logons ...  
Author Message
Romeroromrbbaolcom





PostPosted: Mon Jan 31 08:43:49 CST 2005 Top

SQL Server >> domain accounts & SQL logons ...

we added a user's PC to the local domain which also has SQL Server 2K sp3
running on it. prior to adding the user's PC to the domain the user would
logon to his local machine which had the same username & password combo for
the domain. his sqlserver account name was domainname/username which worked
okay. now that his PC has been added to the domain, however, he can access
all resources on the domain except for the SQL server to which he is an
admin. he receives the "Cannot generate SSPI context" error message. as
soon as his PC is removed from the domain he can connect fine. tia for any
help on this one ...

SQL Server32  
 
 
Roby





PostPosted: Mon Jan 31 08:43:49 CST 2005 Top

SQL Server >> domain accounts & SQL logons ... Had a similar issue once, I think I managed to "fix" it by going into the
client network utilty and forcing the protocol being used to TCP/IP for that
server, or was it to Named Pipes ? Can't rememer, but worth a try =)

Good luck,
Roby





> we added a user's PC to the local domain which also has SQL Server 2K sp3
> running on it. prior to adding the user's PC to the domain the user would
> logon to his local machine which had the same username & password combo
> for
> the domain. his sqlserver account name was domainname/username which
> worked
> okay. now that his PC has been added to the domain, however, he can
> access
> all resources on the domain except for the SQL server to which he is an
> admin. he receives the "Cannot generate SSPI context" error message. as
> soon as his PC is removed from the domain he can connect fine. tia for
> any
> help on this one ...