Error while connecting to SQL Server Instance on a Windows Azure Machine from local SQL Server Management Studio | SansSQL

Tuesday, October 14, 2014

Error while connecting to SQL Server Instance on a Windows Azure Machine from local SQL Server Management Studio

When you try to connect to an SQL Server Instance hosted on Windows Azure, it works perfectly fine from within the server or through Azure management portal.
However, when you try to connect to the same instance from an local SQL Server Management studio, you get the below error which says "The connection string is not valid. The parameter is incorrect"

This is because, the name of the server specified will be wrong. For connecting to the instance hosted on azure, the server name we specify is slightly different from what we specify regularly.

Make sure the connection details you specify is as below.

Server type:  Database Engine
Server name: tcp:<servername>.cloudapp.net,<DB Port Number> OR tcp:<servername>.database.windows.net
Authentication:  SQL Server Authentication
Login: SQL User Name
Password: Password

2 comments:

John Alert said...

I have read your blog its very attractive and impressive. I like it your blog.

.Net Training in Chennai | .Net Online Training

Dot Net Online Training | LINQ Online Training ASP.NET Online Training

vignesjoseph said...

Pleasant Information. We sharing this article content writing style is too good, this information very helpful for all us. As I want to read your blog article because they were going to more and more interesting to be a starting of lines to ending lines.SEO Training | SEO Training in Chennai | Best SEO Training Institute in Chennai

Post a Comment