use master
go
grant CREATE ANY DATABASE to Jack;
go
Msg 15151, Level 16, State 1, Line 1 Cannot find the login 'Jack', because it does not exist or you do not have permission.
here jack is not in my database. My problem here is i want to give access to jack on my server so that he can copy a backup of his database into my server. He is an user of another database.
Answer by ThomasRushton ·
It seems to me as though you first need to grant "Jack" access to your server - CREATE LOGIN or sp_addlogin are your friends here.
Once he's a valid user on the server, then you can give him the permissions he needs...
http://technet.microsoft.com/en-us/library/ms189751.aspx for more information on "CREATE LOGIN" command.