SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Cannot connect to remote DB server from Upgraded SQL Server 2012


Cannot connect to remote DB server from Upgraded SQL Server 2012

Author
Message
TraderJoe
TraderJoe
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 11
Due to ERP upgrade we're upgrading our SQL Server from 2005 to 2012. Our current DB servers (Access thru Microsoft VM) are as follow:

Production environment: Windows 2003 Server 32-bits, SQL Server 2005 - let call it ‘DBSrvProd’
Test environment: Windows 2003 Server 32-bits, SQL Server 2005 – ‘DBSrvTest’
Upgrade Test environment: Windows 2008 Server R2 64-bits, SQL Server 2012 – ‘DBSrvUpg’

In the Upgrade environemnt’s SSMS we created DB Engine ‘DBSrvUpg’ and we try to connect to our old SQL Server 2005 DB Engine (DBSrvProd and DBSrvTest) so that we can migrate DB to DBSrvUpg, we are able to connect DBSrvTest with no issue at all, however we are not able to connect to 'DBSrvProd'. We are getting the following error:

-----------------------------------------------------------------------
Cannot connect to DBSrvProd.

ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
-----------------------------------------------------------------------------

We have compared all configurations between the Prod and Test environment and it appears to be identical, thus we're puzzle why we can connect to one but not the other. We have checked the following between the two servers:

1. SQL Server Configuration Manager's TCP/IP all appears to be enabled and set to default port: 1433
2. SSMS instance for DBSrvProd and DBSrvTest 'Allow Remote Connections' checked
3. The Firewall Windows service (ipc) are both disabled, when I enabled it and check the properties they both have similar setup

All of the three servers are login with SQL Authencation as 'sa', which belongs to sysadmin server role. Please Help!
Gianluca Sartori
Gianluca Sartori
SSCrazy Eights
SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)SSCrazy Eights (9.9K reputation)

Group: General Forum Members
Points: 9862 Visits: 13350
Troubleshoot the obvious first: use portqry to test if the server is reachable from the remote machine. If not, something (firewall) is filtering the traffic.

--Gianluca Sartori

How to post T-SQL questions
spaghettidba.com
@spaghettidba
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search