Reputation: 321
I'm trying to connect to a sql server and its not allowing me to. This just recently started happening from what I can tell nothing was changed. The TCP port (1433) is enabled and allowed access through the firewall, the Named Pipes is enabled. I can ping the IP address of the SQL Server I am trying to connect to. I am running out of ideas fast!
Here is the error:
Cannot connect to (MyServerName)
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)
The network path was not found
Upvotes: 2
Views: 26305
Reputation: 11
Map your shared folder on both Sql Servers [ primary and secondary Sql server ] and try again to configure file log shipping may this help because in my scenario is working for me
Upvotes: 0
Reputation: 321
This was resolved. The company that was hosting the SQL Server I was trying to reach had blocked our cloud server IP address. Thanks for your help everyone!
Upvotes: 4