October 30, 2007 at 11:27 pm
Hi,
I am exploring into DBA side.
When I am trying to add user to the database, I am getting the following error message.
EXEC AMO_TIGER.dbo.sp_adduser 'SRETLD'
Server: Msg 15007, Level 16, State 1, Procedure sp_adduser, Line 15
The login 'SRETLD' does not exist.
I have tried creating login for the user by the following command and got the following error message.
EXEC AMO_TIGER.dbo.sp_addlogin 'SRETLD','xxxxx'
Server: Msg 15247, Level 16, State 1, Procedure sp_addlogin, Line 18
User does not have permission to perform this action.
Kindly advice, how can I proceed with this.
October 30, 2007 at 11:35 pm
For creating the login
Exec sp_addlogin 'SRETLD','password'
To add the user
EXEC sp_adduser 'SRETLD'
Note:--Only members of the sysadmin and securityadmin fixed server roles can execute sp_addlogin.
October 31, 2007 at 3:08 am
Thanks Maverick. Its working fine
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply