Last Post 12 Apr 2002 12:19 AM by satya. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
satya
New Member
New Member

--
12 Apr 2002 12:19 AM
The turnaround is try deleting user account and then recreating it.

Do this with QA rather than via EM. The following sequence cured the problem on the server where it was observed (although it is not clear at which point the problem went away):
use MASTER
go

exec sp_revokedbaccess 'ACCOUNT'
exec sp_revokelogin 'DOMAIN\ACCOUNT'
go

use DATABASE
go

exec sp_revokedbaccess 'ACCOUNT'
exec sp_revokelogin 'DOMAIN\ACCOUNT'
exec sp_grant login 'DOMAIN\ACCOUNT'
exec sp_defaultdb 'DOMAIN\ACCOUNT','DATABASE'
exec sp_grantdbaccess 'DOMAIN\ACCOUNT', 'ACCOUNT'
go

where ‘ACCOUNT’ is the name of the user account, ‘DOMAIN’ is the name of the NT domain in which the account is defined and and ‘DATABASE’ is the name of the database that the user is to have access.

HTH


Acceptable Use Policy
---