I have configured Remote settings from TCP/IP with 1433 port and
Firewall is also disabled
I have checked settings over intenet and applied still not able to connect remotly
I am using windows server 2008 r2 and server has Private Ip
Can anybody tell me is there any other setting which i need to do?
== Edit ==
The error is:
"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."
Best Answer
The first thing you want to check is if Remote Connections are enabled on your SQL Server database. right click the server… Go to properties then Connections.
Under the hood of 'remote server connections' . It should be checked box tick of 'Allow remote connections to this server'
For further Ref Here