Michael Maddison
michael at ddisolutions.com.au
Thu Oct 20 02:33:29 CDT 2011
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