How to tackle with SQL server 2008 Error 233 ?

Question

I created a 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

New login is created successfully. But the moment I try to login with it using SQL Server Management Studio, it displays the following error:

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 is the way to deal with this issue?

Answer 1

Try  this solution because it worked for me very well.

1. You need to login Microsoft SQL Server 2012 with Windows authentication.

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

3. Go to new tab click Security

4. select SQL Server and Windows Authentication

5. Click Ok

6. Close the SQL server management studio.

7. start+run

8. write services.msc

9. Then finally search for SQL there and restart all services.

If you want to get more insights into SQL, checkout this SQL Course from Intellipaat.