Search code examples
sqlwindowswindows-server-2003

How to connect to SQL server through IP

I have a remote server that has win2003 installed

I can connect to the machine using remote desktop and am succesfully hosting a web app on the server

I need to connect to the SQL server on that machine using a sql compare tool that I have.

What are the steps that I need to take to be able to connect to the SQL server given that all I have is the IP address to the machine and admin login credentials

Solution

  • if you are trying to remotely connect to sql server using ssms or another client on a different machine, you need to do the following:

    • open up sqlservr on server firewall
    • open up sqlbrowsr on server firewall
    • be concerned about security - if you can rdp/connect to sql w/o vpn, then so can other people - so you better make sure you have hardened environment and very strong passwords.