Error "Site is currently unavailable" for Your DNN Website
Issue
When you attempt to access your site, you receive a "This site is currently unavailable" error, or a database error. Typing in the website address again may reveal additional information.
Cause
When this happens, it occurs because the DNN website is having problems communicating with its database. This may occur for one of a few reasons:
- The site has a buggy module that has consumed all of the site's available SQL connections.
- DNN inadvertently cached bad data and is not refreshing its cache.
- The SQL user account is either disabled or not configured correctly.
Resolution 1 - Recycle the Application Pool
Recycling the Application Pool for Websites Using Plesk 12x
- Log into your Control Panel.
- Choose the correct subscription from the drop down menu in the upper right.
- Click on Subscriptions Tab. Then select your domain.
- Under Websites & Domains expand Show More.
- Click on Dedicated IIS Application Pool for Your Websites.
- Click on the Recycle button.
Recycling the Application Pool for Websites Using Plesk 11x
- Log into your Control Panel.
- Choose the correct subscription from the drop down menu in the upper right.
- Click on Domains. Then select your domain.
- Under Websites & Domains expand Show Advanced Operations.
- Click on Dedicated IIS Application Pool for Your Websites.
- Click on the Recycle button.
Recycle the Application Pool for Websites Using Plesk 9x
- Log into your Control Panel.
- Click on Domains. Then select your domain. (If the correct domain isn't listed, choose the correct subscription from the drop down menu in the upper right.)
- Under Additional Tools select IIS Application Pool.
- Select the Recycle button to recycle the application pool.
Resolution 2 - Delete and Recreate the Existing Database User
- Log into your Control Panel.
- Navigate to your domain's settings (refer to above steps depending on your Plesk version).
- Select Databases.
- Click on the database for your DNN installation.
- Check and remove any existing users.
- Click on Add Database User and enter a username and password for your new database user.
- Open your web.config file and locate the connectionStrings section. Find 2 lines that look like the following:
-
<
add
name
=
SiteSqlServer
connectionString
=
Server
=(local);Database=<database_name>;uid=<
database_username
>;pwd=<
database_password
>; providerName=System.Data.SqlClient />
-
<
add
key
=
SiteSqlServer
value
=
Server
=(local);Database=<database_name>;uid=<
database_username
>;pwd=<
database_password
>; />
- Change the values after uid=, and pwd= to equal the database username, and password you configured earlier.
Note: Deleting and recreating an existing user can often fix this problem.
Article ID: 135, Created: April 6, 2012 at 8:37 AM, Modified: October 4, 2015 at 4:22 AM