![]() ![]() Make sure Named pipes is enabled in SQL Server configuration manager as shown below.Go to status page in properties window of 'sa' user which you opened in step 2 above and ensure that 'sa' user is enabled as shown below:. ![]() You might have to uncheck "Enforce password policy" check box if you are using a weak password just for your development purposes. Go to SQL Server Instance -> Security -> Logins -> sa -> right click sa node and go to properties. This step requires SQL Server service restart if you are making any changes to accomplish this. Go to SQL Server instance properties and check below. Ensure mixed mode authentication is enabled.I did all this by first logging-in into SQL Server Management Studio (using windows authentication) through an administrator account on that machine which was already added into SQL Server. I had to take following steps in all to fix this issue. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider) (.Net SqlClient Data Provider)Ī connection was successfully established with the server, but then an error occurred during the login process. WhenI tried to enter the management studio by sa it gave this error I am trying to change the password of the sa account via SQL Server Management Studio, but it's not changing it, i tried all the techniques describe here
0 Comments
Leave a Reply. |