SQL Server 2012 migration and SA security access

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?
MikejettAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
" I have basically backup the old instance and restored it to the new server. " - hopefully ONLY user databases and not like master and msdb because if you did in my opinion is better to start from scratch and rebuild your SQL 2012 again.


"When I try and log on to the new server using sa account, I get the following error." - but you know the SA password from the new server right? So from where and how "... I try and log on to the new server using sa account..."?
MikejettAuthor Commented:
Yes, only user database was backed up and restored to new.

I changed the SA password on the new server from studio management by right clicking on on sa account-security-properties section.  

That may be the issue?  I was trying to guess what the password was and I thought I would need to have the same sa credentials from the old to be used on the new.

The new servers is not in production yet, just a test server.
lcohanDatabase AnalystCommented:
No matter how you changed it it must allow you to connect with SA SQL login but what user did you used to change it? You should be able to use the same user and change it again or to see if its not disabled.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

lcohanDatabase AnalystCommented:
And hopefully there's some other account (NT or SQL login does not matter) having sysadmin rights. You may want to look at this just to make sure if you disable SA you don't get completely locked out that SQL server as sysadmin: http://www.brentozar.com/archive/2011/08/dedicated-admin-connection-why-want-when-need-how-tell-whos-using/
MikejettAuthor Commented:
I can log in with studio manager with windows authentication as administrator which has sysadmin rights and I have full access to the database.  trying to login the database on the client side I get the following in the server events log:  

"An attempt to login using SQL authentication failed. Server is configured for Windows authentication only"

When I researched the error, I find articles stating to change the security authentication method on the server to mixed mode will correct, however there is no option there to change it.
Screenshot-2015-11-20-12.32.55.png
MikejettAuthor Commented:
Being new to this, I now understand that "mixed mode" means both windows authentication and SQL server mode.  it works now works when I select that mode.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MikejettAuthor Commented:
I found the solution
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.