Solved

Configuring SQL Server Availability on Public IP

Posted on 2010-09-24
5
357 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Help 27 57
Need help with a Stored Proc on Sql Server 2012 4 28
Need network only 1 user? 10 65
sql 2016 data tools breakdown.. 1 11
If your business is like most, chances are you still need to maintain a fax infrastructure for your staff. It’s hard to believe that a communication technology that was thriving in the mid-80s could still be an essential part of your team’s modern I…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
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…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

789 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