<div>
First is the IP Should be exposed to public access.<br />
<br />
Next, The user ID and password for the SQL Server Authentication should be created in the server.<br />
<br />
Thats It. You can now access your server using SSMS.
</div>


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.

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


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

<div>
<div class="content wysiwyg-content">
As part of their hosting package, Network Solutions gives me a SQL Server database. &nbsp;I can access that database using the SQL Server Management Studio, a public IP that Network Solutions provides, and a SQL login and PW. &nbsp;Can someone point me to instructions on how to set up my own SQL Server in a similar fashion? &nbsp;(I'm comfortable hopping onto my router and configuring port forwarding. &nbsp;I assume that's part of the process.) &nbsp;(I also recognize the security risks associated with the configuration.)
</div>
</div>


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.)

Configuring SQL Server Availability on Public IP

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Networking is the process of connecting computing devices, peripherals and terminals together through a system that uses wiring, cabling or radio waves that enable their users to communicate, share information and interact over distances. Often associated are issues regarding operating systems, hardware and equipment, cloud and virtual networking, protocols, architecture, storage and management.

Networking

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.