Re: domain accounts & SQL logons ...
From: Roby Van Hoye (no_at_spam.com)
Date: 01/31/05
- Next message: Roby Van Hoye: "Re: DTS opening error on server enterprise manager"
- Previous message: Osk: "Performance Reports"
- In reply to: E-Double: "domain accounts & SQL logons ..."
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 31 Jan 2005 15:43:49 +0100
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
"E-Double" <EDouble@discussions.microsoft.com> wrote in message
news:8E5D9C1F-D630-4202-98FA-AB614E4ECCDF@microsoft.com...
> 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 ...
- Next message: Roby Van Hoye: "Re: DTS opening error on server enterprise manager"
- Previous message: Osk: "Performance Reports"
- In reply to: E-Double: "domain accounts & SQL logons ..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
