I am moving our SQL server 2008 database to a new server running SQL server 2012. I have basically backup the old instance and restored it to the new server. The old instance used the sa login account. I do not have the sa security account login from the old server available. When I try and log on to the new server using sa account, I get the following error.
Cannot connect to SERVER3.
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)
I have tried to change the password of the SA account through management studio logged in under windows authentication, but still no luck.
What can I do to can access with the SA account on the new server?