I followed instructions from the Move All Databases (SharePoint Server 2010) article.

I have a SQL alias set up on the original database server and the new database server.  I can connect to the old server from the new server via SQL Server Management studio. The configuration in SQL Server Configuration Manager on both servers is as follows:

sqlAlias TCP/IP Oldserver

Client Protocols
TCP/IP Enabled

Named Pipes Enabled

SQL Server Services

Service  Running  Automatic  Log On As

SQL Server Browser  Yes Yes  DOMAIN\SQLservice

SQL Server  Yes Yes  DOMAIN\SQLservice

SQL Server Agent  Yes Yes  DOMAIN\SQLservice

When I change both servers configuration by changing the alias to the new server, I cannot connect to the new server from the old server.  All server security logins match in SQL Server Management Studio. I am able to ping the new server from the old server using both the IP and the SQL alias. What am I missing?

  • 1
    Checked your firewalls for Ports?? Are you using standard ports (1433) or others? Jun 18, 2012 at 0:49
  • It was the firewall. If you answer the question, I'll mark your post as the answer. Jun 19, 2012 at 15:52
  • Done, thank you too for getting back with the final resolution! Jun 19, 2012 at 18:40

1 Answer 1


Make sure you check your Firewall ports on the servers that require communications among them, or even better disable firewall while testing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.