SQL Server 2008 Error 233

Question

I'm creating new login in SQL Server 2008 with following sql script:

CREATE LOGIN [xyz] WITH PASSWORD='xyz',             DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english],              CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF 

It creates new login successfully. But when I try to login with it using SQL Server Management Studio it fails saying:

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)

What's wrong? How do I solve this issue?

Answer 1

Here is how I done it, maybe it works for you too.

1. login Microsoft SQL Server 2012 with windows authentication.

2. right-click onto the server name in Object Explorer and click Properties

3. In the new tab click Security

4. select SQL Server and Windows Authentication

5. Ok

6. Close the SQL server management studio.

7. start+run

8. write services.msc

9. search for SQL there and restart all services.

that works for me.

Answer 2

It's also possible that you're trying to use SQL Server Authentication without having enabled it. To fix this, right-click Properties on your server instance in SQL Server Management Studio, and update the security settings to include "SQL Server and Windows Authentication mode".