i have one IIS web server with public ip ,this web server can connect to my database.is there any way to connect SQL server management studio to the database using this IIS(or web service) over internet?
If the firewall on the Database server is open to connections on the internet and you are aware of the login credentials for that instance, you can use the IP address to connect the database instance over the internet.