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

4 comments:

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

Prwatech said...

Excellent blog!!! I got to know more useful information by reading your blog. Thanks for posting this blog.

Data Science Training In Bangalore
Data Science Training Institute in Bangalore

Ziya said...
This comment has been removed by the author.
Ziya said...

This is a wonderful, helpful article.On the whole, I am happy with your excellent work.Really useful information was provided by you. Don't stop. Just keep writing. I'm interested in reading your next post. custom erp software development

Post a Comment

Ads