Cannot able to create the user in SQL Server.

Posted by Amatya under Sql Server on 5/11/2017 | Points: 10 | Views : 311 | Status : [Member] | Replies : 1
Cannot able to create the user in SQL Server. "is not a valid login or you do not have permission
Below is my query
CREATE USER [amatya] FOR LOGIN [amatya] WITH DEFAULT_SCHEMA=[dbo]


Thanks in Advance.

Feel free to share informations 9731764134
mail Id ' adityagupta200@gmail.com
Thanks



Responses

Posted by: Jitendrasoft09 on: 5/13/2017 [Member] [MVP] Starter | Points: 25

Up
0
Down
Probably you have to add 'Administrator' permission in your current user instance in SQL Server, look steps in below link and try it.
http://www.aspdotnet-suresh.com/2015/01/windows-8-1-it-is-not-valid-login-or-you-do-not-have-permission-to-install-sql-seerver-2008-r2.html



Jitendra Kumar
If my post helps you, plz mark as an answer.

Amatya, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response