using a domain usr account which is in local admin group.
A local user account logged on and tried to launch query
analyzer and got access denied. How to fix this problem
so that the local users can have launch the sqlserver
software? Any help will be appreciated.you need to grant the user the login permission onto sql server and the
login needs to be mapped to a database user or granted permissions or added
to a database roles.
Check sql books online sp_grantlogin and sp_addlogin , sp_grantdbaccess
Regards,
Dandy Weyn
MCSE, MCSA, MCDBA, MCT
www.dandyman.net
"Wen Chang" <wchang@.siac.com> wrote in message
news:036001c3dde0$d0049580$a001280a@.phx.gbl...
quote:
> The sqlserver 2000 was installed on the box
> using a domain usr account which is in local admin group.
> A local user account logged on and tried to launch query
> analyzer and got access denied. How to fix this problem
> so that the local users can have launch the sqlserver
> software? Any help will be appreciated.
>
No comments:
Post a Comment