asked on

New SQL Server 2012, connection problems

I have just installed a new SQL Server 2012 server.

I am attempting to connect to the new SQL Server from the 2012 Management Console installed on my desktop and I am getting an error. See attached image.

Here are other things that might be helpful to solve the problem:
-I am able to connect to the 2005 SQL Server fine using the 2012 Management Console
-I am able to create a linked server on the 2012 SQL Server to the 2005 SQL Server, but I can't create a linked server on the 2005 Server to the 2012 SQL Server.
-Shared Memory, Named Pipes and TCP/IP are enabled on both servers
-Both servers have the checkmark to allow remote connections
SQLError.jpg

ravikantninave

Check this
http://support.microsoft.com/kb/2879704

PadawanDBA

With the above, I think we would first need to ask if you're trying to connection to a sql server AlwaysOn availability group listener... If you go into the SQL Server logs, do you see any entries for around the time you were attempting to connect?

yonbret

ASKER

I am not using High Availability. Just in case, I installed the patch in the KB article, but still doesn't work.

PadawanDBA

Any entries (especially failed login attempts) in the SQL error logs around the time you get the error when upon connection attempt? Also, are you able to connect when you are local to the SQL Server instance ?

yonbret

ASKER

I think the problem is security related, but I can't find any errors in logs related to SQL Server.

I think it might be timing out before it gets a connection, so it never attempts to log in.

ASKER CERTIFIED SOLUTION

yonbret

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

yonbret

ASKER

Worked with Microsoft to troubleshoot the issue.