February 22, 2017 at 9:45 am
Im using Azure and have created a virtual machine with an instance of sql server 2012. The vm has a private IP address which ive used to RDP into the server to install sql enterprise manager. Ive then created a sql login with sysadmin privileges. On my local dev machine I try to connect to the VM instance of sql server using the private ip address and server name (as the server name) and my newly created login with sysadmin role. Allow remote connections is set to true and im using the correct port, but im getting this error
TITLE: Connect to Server
------------------------------
Cannot connect to server name here.
------------------------------
ADDITIONAL INFORMATION:
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. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
can anyone point me in the right direction ?
February 22, 2017 at 10:01 am
Did you add the firewall rule to allow your IP?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 22, 2017 at 10:58 am
Henrico Bekker - Wednesday, February 22, 2017 10:01 AMDid you add the firewall rule to allow your IP?
Yep, this sounds right.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2017 at 1:46 am
where do i add that ?
February 23, 2017 at 5:40 am
here you go: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-configure-firewall-settings
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply