KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm using using Windows Vista and I'm having trouble logging in with a newly created user. I open SQL Server Management Studio. I create a new Login by right-clicking on Security->Logins. Check: SQL Server Authentication Login name: tester Password: test Click OK I added this user to User Mapping to my database of choice. Click File -> Connect Object Explorer, select SQL Server Authentication and enter tester/test and click Connect. I get an error: Login failed for user 'tester'. (Microsoft SQL Server, Error: 18456" with Severity = 14 and State = 1. What causes this error and how do I login with my user?
Tags (comma-separated)
Save Edits
Cancel