access denied for query analyzer  
Author Message
m4shafi





PostPosted: Sun Jan 18 12:54:20 CST 2004 Top

SQL Server >> access denied for query analyzer

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.

SQL Server147  
 
 
Dandy





PostPosted: Sun Jan 18 12:54:20 CST 2004 Top

SQL Server >> access denied for query analyzer 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


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