All geek questions in one place

Unable to connect to SQL server - client problem

I could tell a millionth person about this, but other solutions did not help me. I have a Microsoft SQL Azure database. I am trying to connect to it using the Visual Studio 2010 Database Connection tool.

From my Windows 7 machine, I can connect to it very easily. But from my Windows Server 2008R2 machine, I get a classic error -

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)

All messages on the Internet seem to focus on server-side issues, no one cares if the client is rogue. :(

Thanks for answers.

0
source share
2 answers

I saw similar problems with VS2010 DB Tool and Windows Server, so I would not suggest trying SSMS 2008 R2 (should be R2) . As soon as you download SSMS 2008 R2 and configure yourself correctly to work in Windows Server, it will certainly work. In most cases, you really need to open SSMS settings to make it work on Windows Server.

Then a few points to check:

0
source

One problem is that you need to connect via tcp and not named pipes (for your error message).

Are both servers behind the same firewall (for example, the same external IP address)? Azure SQL Firewall must be configured to allow access from remote IP addresses.

0
source

Source: https://habr.com/ru/post/1415285/

More articles:


All Articles