Solved

Configuring SQL Server Availability on Public IP

Posted on 2010-09-24
5
356 Views
Last Modified: 2012-05-10
As part of their hosting package, Network Solutions gives me a SQL Server database.  I can access that database using the SQL Server Management Studio, a public IP that Network Solutions provides, and a SQL login and PW.  Can someone point me to instructions on how to set up my own SQL Server in a similar fashion?  (I'm comfortable hopping onto my router and configuring port forwarding.  I assume that's part of the process.)  (I also recognize the security risks associated with the configuration.)
0
Comment
Question by:jdana
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:radcaesar
ID: 33755612
First is the IP Should be exposed to public access.

Next, The user ID and password for the SQL Server Authentication should be created in the server.

Thats It. You can now access your server using SSMS.
0
 
LVL 15

Accepted Solution

by:
AmmarR earned 500 total points
ID: 33755644
Dear jdana

all you need to do is install SQL server on your machine

by default sql server works on port 1433,

so if as you are familiar with port forwarding

just make a port forwarding entry into your router  to your machine on port 1433.
----------

but for security reasons if you want to use another port, do the same to the other port.

now to connect to it from outsite the network.

use SSMS and type ipaddress,port (notice the , between ip and port) and here the port will be different because you are mapping an external port to an external one

hope it helps

Regards
0
 

Author Comment

by:jdana
ID: 33755970
AmmarR,

Great advice!  I've configured RDP on my server to look for an off-port number (not 3389).  Can I do the same with SQL Server?  (In other words, configure it to listen to something other than 1433.)

J
0
 
LVL 15

Assisted Solution

by:AmmarR
AmmarR earned 500 total points
ID: 33756615
0
 

Author Closing Comment

by:jdana
ID: 33757509
Thanks again.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Even if you have implemented a Mobile Device Management solution company wide, it is a good idea to make sure you are taking into account all of the major risks to your electronic protected health information (ePHI).
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question