Cannot login to SQL Server 2005 using SQL authentication mode (mixed mode).
Posted on 2008-11-17
I changed the Server authentication to SQL Server and Windows Authentication mode.
The MS help said I need to restart the service when changing the authentication mode, but when I look on the server under Adminstrative Tools, Services, I don't see any sql server services running.
After changing the authentication, I added a login (sqluser7) with SQL Server authentication and default database db7. Then I added a user to database db7 (sqluser7) with default schema dbo, owned schemas db_owner and Role Members db_owner.
When I get out of SQL Server Management Studio and try to login using SQL Server Authentication abd sqluser7 I get an error message:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)
If I try to do the login again, I get a different error:
Cannot connect to xxx.
Login failed for sqluser7. The user is not associated with a trust SQL Server connection. (Microsoft SQL Server, Error: 18452)
What step am I missing?