Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

Alias
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?

share|improve this question
1  
Checked your firewalls for Ports?? Are you using standard ports (1433) or others? –  C. Marius - MVP Jun 18 '12 at 0:49
    
It was the firewall. If you answer the question, I'll mark your post as the answer. –  James Grizzle Jun 19 '12 at 15:52
    
Done, thank you too for getting back with the final resolution! –  C. Marius - MVP Jun 19 '12 at 18:40

1 Answer 1

up vote 1 down vote accepted

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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