How can I administer SQL Database on remote Web Server

[Babu Thomas]

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

[Trevor Best]

Re: How can I administer SQL Database on remote Web Server

On 29 Jul 2003 01:10:50 -0700 in comp.databases. ms-sqlserver,
babu_nir@hotmai l.com (Babu Thomas) wrote:
[color=blue]
>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.[/color]

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)