Help Center

Version 2.0

Related Articles

• What are the Database Publishing Service and Database Publishing Wizard?
• What server objects are supported on Windows shared hosting servers?
• Importing MS SQL 2005 Databases into MS SQL 2008 Databases
• What version of SQL Server is supported by the Database Publishing Service and Database...
• Hosting Account Support for DLLs (Dynamic Link Libraries)
• What should I be aware of when using the Database Publishing Service in the hosted environment?
• What does my Database Publishing Wizard error mean?

Publishing a Web Site Based on an ASP.NET Starter Kit

ASP.NET starter kits can be downloaded from the ASP.NET website.

The following instructions use the ASP Time Tracker starter kit as an example. However, you can use this upload procedure for any starter kit that uses a 2005 SQL database (running from a local MDF file or a standalone server). The directions assume the following:

• You have downloaded an ASP.NET starter kit and developed a web application locally.
• The database uses a local MDF file (starter kit default setting).
• The Database Publishing Wizard client is installed on your local machine.
• You have at least one Microsoft 2005 SQL Server database setup on your hosting account.
• Your database has remote access enabled. For more information, see Connecting Remotely to Shared Hosting Databases.

To Publish Your Database Web Application to the Hosting Server:

1. Create a Connection to your database from Visual Web Developer.
   1. In Visual Web Developer, open the Database Explorer tab.
   2. Open a connection to your local SQL Server.
      1. Right-click Data Connections and select add Connection.
      2. If the Change Data Source dialog comes up, choose Microsoft SQL Server. Leave the default setting for Data Provider.
      3. Press OK.
      4. On the Add Connection Dialog, enter your database's host name. For more information, see Viewing Your Database's Details.
      5. Select Attach a database file.
      6. Click Browse.
      7. On the file dialog, locate your MDF and press Open.
      8. Enter a logical file name. This should be easily associated with your project.
      9. Click OK.
2. Right-click the entry for your website Database. Select Publish to Provider. This will launch the Database Publishing Wizard.
3. Follow the instructions for Setting up a SQL Server Database on Your Hosting Account.
4. Modify the default connection strings section of your web.config file.
5. Add the following Time Tracker connection string entry below to your web.config file, making the same substitutions as in the previous step:
   
   <add name="aspnet_staterKits_TimeTracker" connectionString="
   Server=whsql-v04.prod.mesa1.secureserver.net;
   Database=DB_675;
   User ID=user_id;
   Password=password;
   Trusted_Connection=False" providerName="System.Data.SqlClient" />

   NOTE: The misspelling of "starter" in the value "aspnet_staterKits_TimeTracker"
   originates from the Time Tracker application itself.

6. If your existing website resides in your hosting account root directory, add the following line of code to the Time Tracker web.config file, between the <system.web> tags:
   
   <pages styleSheetTheme=""/>
7. Under the Tools section of the Hosting Control Panel, click the IIS Settings icon.
8. Click Create Directory. Enter the name of the directory in which your Time Tracker application will reside and, then select Anonymous Access and Set Application Root permissions.
9. Click Continue.
   
10. Upload the contents of your application to the directory you specified in step 8.
    

For additional information about the Database Publishing Service and the Database Publishing Wizard, see the following articles:

• What does my Database Publishing Wizard error mean?
• Publishing a Database Using the Database Publishing Wizard

• Not helpful
• Somewhat helpful
• Helpful
• Very Helpful
• Solved my problem