Alex Rivera | Logout

SQL Server 2008 can't login with newly created user

Asked 2009-11-12T01:56:34.137
216

I'm using using Windows Vista and I'm having trouble logging in with a newly created user.

  1. I open SQL Server Management Studio.
  2. I create a new Login by right-clicking on Security->Logins.
    Check: SQL Server Authentication
    Login name: tester
    Password: test
    Click OK
  3. I added this user to User Mapping to my database of choice.
  4. 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?

sql-server authentication ssms
Edit
Report

1 Answer

15

If you haven't restarted your SQL database Server after you make login changes, then make sure you do that. Start->Programs->Microsoft SQL Server -> Configuration tools -> SQL Server configuration manager -> Restart Server.

It looks like you only added the user to the server. You need to add them to the database too. Either open the database/Security/User/Add New User or open the server/Security/Logins/Properties/User Mapping.

answered 2009-11-12T02:06:31.183

Your Answer