KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I wasn't sure if this was a SO or SU question. I have freshly installed SQL Server 2012. I have created a database. I have a visual studio 2012 project, and I want to connect to the database using a connection string in my web config. Since I only have two accounts (sa and my windows account) I want to create a new user that will only have access to this one database. Google says, in SSMS, expand the database, right click Security and go to New User. However, when I do this and try to create a user, I choose SQL user with login, enter a username and login name, and get the error: 'news_login' is not a valid login or you do not have permission I've tried by logging into SSMS as 'sa', logging in as my windows account, and running SSMS with administrator permissions. I've tried a few different usernames, and to no avail. I notice there is no password box, so I fear I am doing it all wrong. Any suggestions?
Tags (comma-separated)
Save Edits
Cancel