Bind Sql Server to Static IP address
-
Wednesday, February 27, 2013 2:32 PM
We using SQL Server 2008 in our Windows Server 2008, and have a static ip. We are able to connect to sql server from Management Studio in our network. But how do we connect to SQL Server when we are outside our network.
Plz Suggest.
- Moved by David DyeModerator Wednesday, February 27, 2013 3:29 PM More appropriate forum is databsae engine
- Changed Type David DyeModerator Wednesday, February 27, 2013 3:30 PM Post poses a question
All Replies
-
Wednesday, February 27, 2013 3:22 PM
supposing the server has adequate protection, you will need to find out the port that sql server is using. Then you will need to open that port in the firewall so that requests made from outside the network to that ip and port can be handled by sql server.
i.e if your ip address is 191.168.1.1 and sql server is using 1433, then you need to open that port in the firewall. once that is done, yuo should be able to put 191.168.1.1:1433 in SSMS
Hope this helps
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, March 07, 2013 9:23 AM
-
Wednesday, February 27, 2013 3:33 PMModerator
I moved this post to the database engine forum as this question should receive a better more directed response.
I am not certain if you are looking at connecting in an extranet or internet, but here are some links for internet connection considerations:
http://msdn.microsoft.com/en-us/library/ms175483(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/cc646023.aspx
http://msdn.microsoft.com/en-us/library/ms189067(v=sql.105).aspx
Hope this helps
David Dye My Blog
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, March 07, 2013 9:23 AM
.png)
