By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,077 Members | 1,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,077 IT Pros & Developers. It's quick & easy.

SQL Server 2005 sysadmin, error 15151 problem

P: 1
Hi everyone,

I have just installed MS SQL Server 2005 Enterprise Edition to practice administrative features.

I have downloaded and installed the sample database called "AdventureWorks"
on the local server.
1) I have a Windows Group called "SQLManagers"
2) I created a Windows user called "SQLAdmin" in the "SQLManagers" group
3) I granted to "SQLManagers" the sysadmin role

4) I created another Windows user called "sqltest"

5) I logged on SSMS as "SQLAdmin"
6) I tried to execute this following TSQL

GRANT EXECUTE ON DATABASE::AdventureWorks TO sqltest

Msg 15151, Level 16, State 1, Line 1
Cannot find the user 'sqltest', because it does not exist or you do not have permission.

Anyone knows what the problem was?
Aug 11 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.