Geek asks and answers

Failed to connect to SQL Azure remotely from SSMS 2012

I cannot connect to a remote instance of an Azure SQL database using SQL Management Studio 2012. A firewall exception exists for my local IP address. I can successfully connect and administer the database using the browser-based management link in my Azure account.

I just can't connect to the database via SSMS or anything else like VS2012.

Here is the format I have for my connection in SSMS:

Server Name:     myservername.database.windows.net
Authentication:  SQL Server Authentication
Login:           myusername@myservername
Password:        my-password
Connect to:      (i've tried) "master", mydatabasename, <default>
Encryption:      TRUE

Once again, I have a firewall rule for my local IP address on the server instance of my Azure account.

When I try to connect, I get this error:

The connection to the server was successfully established, but then an error occurred during the establishment of the connection before entering the system. (provider: SSL Supplier, error: 0 - timeout suspended.) (Microsoft SQL Server, error: 258)

When searching for this error 258, I do not get many results related to SQL Azure. I appreciate any help.

+5
source share
1 answer

Error 258 is created due to some configuration on your computer if a secure network can be established between two endpoints and if one computer initiates a secure channel. This problem can be very machine specific and not specific to SQL, why you did not find any resources in this regard.

SQLCMD, , , , SSMS : http://social.technet.microsoft.com/wiki/contents/articles/1719.windows-azure-sql-database-connectivity-troubleshooting-guide.aspx

, .

+3

More articles:


All Articles