[dba-SQLServer] Using SQL Server through my web site

John, I just got this link from ZDNet - it might interest you:

http://whitepapers.zdnet.com/abstract.aspx?docid=3422473&promo=550&trial=25439928&tag=nl.e550

Doug

On Thu, Oct 20, 2011 at 12:33 AM, Michael Maddison <
michael at ddisolutions.com.au> wrote:

> Hi JC,
>
> I've done it but I don't do it often.
> IIRC Our host requires us to upload a backup of the db.
> We let them know via email the db is ready, including user details and
> they have it set up in no time. YMMV.
> You should be able to get the IP via your Plesk (or similar) terminal
> and create a connection from Enterprise manager or use the built in
> tools (Plesk).
> Your host login should have admin privs over your database only.
> Name the db well as it will be sitting with many others.
> Never really got the backup tools to work with my Host so I email them
> to drop a backup into a folder I created and I ftp it back here.
> Got a feeling there will be issues with the user account, you may need
> to drop and recreate the login.
> Oh yeah, probably doesn't need to be said but I don't think you can use
> Windows Authentication.
>
> Good luck
>
> Michael M
>
>
> -----Original Message-----
> From: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Wednesday, 19 October 2011 11:02 PM
> To: Sqlserver-Dba
> Subject: [dba-SQLServer] Using SQL Server through my web site
>
> I buy a web hosting plan where I have the ability to build sql server
> databases though my web account.  I have never used this but I need to
> do so now.  I haven't a clue how to get started.  I have written an
> email to the hosting company (PowerDNN) asking them for documentation on
> "how to"
> but I am wondering if any of you guys do this?
>
> I have built a bunch of SQL Server back end databases for Access FEs.
> this is all working well but the databases are running on a VM on my
> server at my home office which has obvious limitations.  I am hoping
> that I can push these databases out to my web host and reconnect the FEs
> to those databases out on the web.  That would make scaling issues go
> away.
>
> Is anyone doing this?  Any tricks / tips / cautions etc?
>
> --
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1411 / Virus Database: 1522/3962 - Release Date: 10/19/11
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>