Can' t create a new user on SQL server

[tatochka]

Here is the problem I am having. We have a SQL database on the server. Through VB app I connect to the server (OLE DB) and can create new users for the server (and users database) by running sp_addlogin. It all happens programaticaly in VB.

Now we copied the data to another server. Create a new user login with all the same permissions as on the first server. However now when I connect with this login I can't create any new users. I compared everything on the old server and new server and didn't find anything different. What should I look at? Any ideas? Appriciate any help.

 

[BogdanMBM]

You must have sa (administrator) rights to create users. So your login should be something like sa or dbowner, accessadmin. What error the server rises exactly? Can you post it here?

 

[BogdanMBM]

Me again!

From books online:

"Permissions
Only members of the sysadmin and securityadmin fixed server roles can execute sp_addlogin."

 

[tatochka]

Yes, the user is a member of sysadmin and securityadmin roles. I don't get an error message from the server when it is running (supposly) sp_addlogin. It just doesn't create a new user. When I try to login with the new user name I get a message, because user was not created under SQL security .