Administer SQL Server via Internet? 2

[lennyh]

Can SQL Server be administered over the internet?

I'd like to develop a db locally w/ MSDE (and an Access project), ftp the db to SQL Server, and then
attach it (and do anything else required to enable the db at the remote Server). Can the attach (or
detach) be done via the internet? If so, do I need a local copy of Enterprise Manager to do this?
I'd prefer an approach that does not require a local copy of SQL Server client tools.

TIA for any advice/pointers/etc.

 

[Kubilus1]

I'm not exactly a SQL expert, but if you used a utility such as PCanywhere or GotoMyPC you could log in to a computer on your network via internet and use EM remotely without having to install any sql client tools at home. This is the method we use to do remote administering.

You could try VNC which is a freeware version of PCanywhere. Link:

http://download.cnet.com/downloads/0-10101-100-2466323.html?tag=st.dl.10001-103-1.lst-7-3.2466323

 

[lennyh]

Thanks for your helpful response. I hadn't thought of that approach. I'll have to check to see if the admin will allow one of the remote admin progs to be installed. (BTW, I have played some with RAdmin [

http://www.famatech.com/

] -- another PCanywhere type prog which seemed quite good. Used to be free, but think they are now charging for it.)

I'm currently thinking that perhaps if the only requirement I have is for sp_attach/sp_detach that I can issue them via a php-enabled web page. Not nearly as full-featured as your suggested approach, but maybe sufficient.

Lenny Harris

 

[FilthPig]

I would tend to recommend pcAnywhere, especially coming over the internet, as a security issue. pcAnywhere offers encryption, as well as several other security options.

Marc Creviere