i have installed SQL Server 2008 R2. I don't have experience as administrator only as user.
Administrator is set to "Current domain/user" with Windows authentication. I connect fine with this user to server.
Then i need to create a user. Without domain name. For example "User1" with SQL Server authentication. I set a password. Login is created.
But when i try to connect to server with SQL Server authentication and type Login and password i get error "Login failed for user "User1"" Error code 18456.
Maybe this problem is caused by i have sysadmin set to connect to server with Windows authentication?
View Complete Post