I'm using Microsoft SQL Server Management Studio 2012 and I have a database and have recently created a system admin account to log on using SQL authentication. When I restart the program after making the account, I open it to log on and it says :
Title: Connect to Server
Cannot connect to .\SQLEXPRESS.
Additional Information :
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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476
No process is on the other end of the pipe
I have searched online for solutions and I have enabled TCP/IP, Name Pipes, and Shared Memory, yet no successful solution. Can anyone help and tell me how to solve this problem and actually successfully log on to my system admin account?