SQL 2005 Database backup.
Re-Invent hosting.
No Cpanel or other direct access.
Attempting to use the SQL "Database Publishing Wizard".
The story and the problems:
Database backup:
We are hosting with http://www.re-invent.com and have some problem with database backup.
We have no Cpanel or other form of access to the server, thus we are unable to follow Lee’s (DNNCreative) excellent tutorials.
When approaching Re-Invent they suggest we pay them US$ 15 per hosting each time we want a backup, or we use the below wizard.
The Data Publishing Wizard.
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title
=Database%20Publishing%20Wizard
Initial Information provided by Re-invent:
Domain Name: goldcoastwebwiz.com or www.goldcoastwebwiz.com
FTP Address/Host Name: Use your domain name goldcoastwebwiz.com
Note: With Microsoft Shared FTP Hosting you will see other customer directories (folders). You do not have access to these folders and they do not have access to your folder. Double click on your directory name to enter your root. Some FTP software allows you to enter the remote directory name to avoid the extra step of double clicking on it. Please refer to your FTP software documentation. You will not see this occurance with MS FrontPage.
User ID: user
Password: password
FTP Access Enabled: Yes
ASP.NET 2.0 Enabled: Yes
SQL 2005 Database Information:
SQL 2005 HostName: sql2005-4.reinventinc.com SQL Database Name: goldcoastwebwiz SQL Username: user
Password: password
You may use SQL Server Management Studio or similar compatible SQL 2005 Client tool for connecting to and managing your SQL 2005 Database.
And the current working Web Config file:
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|
Database.mdf;"
providerName="System.Data.SqlClient" /> -->
<!-- Connection String for SQL Server 2000/2005 -->
<add name="SiteSqlServer" connectionString="Server=sql2005-4.reinventinc.com;Database=goldcoastwebwiz;uid=user;
pwd=password;" providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|
Database.mdf;"/> -->
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=sql2005-4.reinventinc.com;Database=goldcoastwebwiz;uid=user;
pwd=password;" />
From the above we have made several attempts to do a connection string to be able to logon with the Wizard – but no success.
Re-Invent does not provide support for this wizard.
Re-Invent was recommended through the Dot Net Nuke site, (don’t know if it still are?) so there must be many users that attempted use of this server?
How did you solve backup problems?
Equally, SQL Publishing Wizards seems like a good tool, thus there must be many successful connections from a localhost PC to a remote server based database.
Please E-mail any help or ideas you can provide:
