Azure connection - SQL Server 2005

Asked

Viewed 29 times

-1

I’ve been trying to connect on the Microsoft Azure database server to an application encoded in . Net Framework that is running on a windows server 2003.

The problem is that only this server is returned failed, the following:

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. (Ovider: TCP Provider, error: 0 - A Connection Attempt failed because the Connected party Did not properly Respond after a period of time, or established Connection failed because Connected host has failed to Respond.)

I have seen:

  • Data from connection string

    • format: connectionString="Password=********; Encrypt=True; TrustServerCertificate=False; User ID=Name_Login; Initial Catalog=Name_Data_Base; Data Source=tcp:***********.database.windows.net,1433"/>

  • Possible Firewall Blocks

Have you ever had a similar mistake? If yes how you were treated?

sql database sql-server sql-server-2005 azure-sql

1 answer

0

Good afternoon! Chará!

I recently faced a problem very similar to yours.

And after a lot of headaches to find the solution, I identified that on my server, the Firewall was still blocking the Exit IP and making it impossible to connect to the database server in Azure.

After configuring and releasing Ips properly in Firewall, I successfully achieved communication between my server and the Azure database server

Browser other questions tagged sql database sql-server sql-server-2005 azure-sql

You are not signed in. Login or sign up in order to post.