External access to SQL Server

Hello,

I'm not sure whether this is right section to post this. It seems the most relevant one to me. (Please point me in the right direction if it is not).

I am a programmer/web developer for a medium sized organisation in the financial industry (in Australia). Obviously being in the finance industry, we have very strict guidelines and access when it comes to security. We are currently in the process of converting our website to use a SQL Server database (instead of MS Access which we have been using for years). In the past, we have accessed our web database via SFTP as it was only an Access file. Now that we are converting to SQL Server, we will still need access to our database (which is on a server hosted externally). It seems a bit silly (and even bizarre) to me to consider trying to access a SQL Server database via SFTP (as that, to me, defeats the purpose of some of its security features), but is it even possible?

My security guys here will only allow me to access the external server that hosts our website/database via SFTP (on a machine that is outside our network, so any files that I wish to update on our website I need to copy over via USB or whatever). If I am not able to get into the SQL Server administrator program to change our database via SFTP, is there someway that I can "drop" a changed copy of our database into a directory somewhere that SQL Server can "pick up"?

Am I making sense?

Many thanks,

Bronwyn

You could drop that, but you would anyway have to do some administrative stuff, like detaching the old database, are even just stopping the service. Perhaps it is better to install a web admin client for the SQL Server which is downloadable at Microsoft. It does not provide the whole functionality of the Managment Studio or Enterprise Manager, but this would be a proper way to execute your changing scripts to narrow the maintaince window.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||

host the client application inside your site

or design a webservice inside your site

and have the remote application

access Sql server through webservice

|||Thanks guys. That's helpful.sql