Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Configuring SQL Server Availability on Public IP

Posted on 2010-09-24
5
Medium Priority
?
365 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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 2000 total points
ID: 33756615
0
 

Author Closing Comment

by:jdana
ID: 33757509
Thanks again.
0

Featured Post

Simplify Your Workload with One Tool

How do you combat today’s intelligent hacker while managing multiple domains and platforms? By simplifying your workload with one tool. With Lunarpages hosting through Plesk Onyx, you can:

Automate SSL generation and installation with two clicks
Experience total server control

Question has a verified solution.

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

If you’re involved with your company’s wide area network (WAN), you’ve probably heard about SD-WANs. They’re the “boy wonder” of networking, ostensibly allowing companies to replace expensive MPLS lines with low-cost Internet access. But, are they …
During and after that shift to cloud, one area that still poses a struggle for many organizations is what to do with their department file shares.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

604 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