0

I am trying to connect to my Sql server 2012 which is setup on Azure VM. I am trying to connect it from my local Sql server 2012. I have tried all these steps

http://azure.microsoft.com/en-us/documentation/articles/virtual-machines-provision-sql-server/

But still not able to connect. I getting this error

enter image description here

Can Some please help me to solve this problem?

Improve this question

2 Answers 2

Reset to default
1

Since you're connecting to cloudnet.app domain address I assume you don't use VPN. This means: - SQL Server authentication should be set to mixed mode - SQL login should be created or enabled - In case enabling SA login make sure you set the password

For connectivity part I agree with Jason's suggestions, but I would not disable firewall, since with endpoints facing public internet it is your last line of defense on the VM. Just make sure you have allow rule for the SQL Server port (most likely 1433).

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Confirm the following:

  • You have configured the cloud service port 57500 (from the screenshot) to forward to the port that SQL is configured on, typically 1433.
  • Turn off the firewall within the VM. Once you get a working connection, I would reconfigure the firewall to only open the port(s) you need for security. The instructions you provided show how to open a specific port, but you should first disable the firewall to rule out a misconfiguration there.
  • Remote into the VM and ensure that you're able to use the management tools on that machine to make a local connection. This will help rule firewalls and the load balancer for the cloud service.
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.