SQL Server Error 223 When Connecting

Question

I recently changed SQL Server 2008 from Windows Authentication mode to be mixed. I created a new user "taraw" and set a password. I connect to localhost, which works fine when using Windows authentication, however, if I want to use SQL Server authentication with my user - taraw, I get the following error:

Shared memory provider, error: 0 - No process is on the other end of the pipe (Microsoft SQL Server, error 233) (Microsoft SQL Server, error 233)

I know that the password is correct, since I just created it, I also tried to create different users to whom I get the same result. Have I read somewhere that Namespipes can be disabled? But I did not know where and how to do it. (EDIT: I have since found this, and it's on)

If anyone has any advice this would be greatly appreciated.

thanks

Answer 1

Since then I have solved this problem. I previously restarted the server in SQL SERVER MANAGEMENT STUDIO, it was wrong.

I just restarted SQL Server in SQL Server Configuration Manager and it worked.