471,897 Members | 2,240 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

How can I administer SQL Database on remote Web Server

Hello Everybody

Please tell me which is the best method to adminster SQL Server
database in remote web server.

Eg. I am storing all the information of SQL database in my work place
and after that have to upload the modified table to remote web server.
Please tell me what is the easiest way or how I can achieve this
without purchasing third party applications.

With regards
Babu Thomas
Jul 20 '05 #1
1 2309
On 29 Jul 2003 01:10:50 -0700 in comp.databases.ms-sqlserver,
ba******@hotmail.com (Babu Thomas) wrote:
Hello Everybody

Please tell me which is the best method to adminster SQL Server
database in remote web server.

Eg. I am storing all the information of SQL database in my work place
and after that have to upload the modified table to remote web server.
Please tell me what is the easiest way or how I can achieve this
without purchasing third party applications.


The easiest way would be to have port 1433 open on the web server and
use EM to manage it. If your web server is VPN enabled use that
otherwise if firewalled you may be able to opne up that port to allow
only your IP address in.

Note, it's not such a good idea to leave this port open to the rest of
the world, it *will* get hacked I promise you, there's no maybes on
this one, it *will* get hacked.
--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Tor Inge Rislaa | last post: by
5 posts views Thread by ilanwajsman | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.