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
This occurs because the DotNetNuke website is having problems
communicating with its database. Reasons for this error may be one or
more of the following:
- The site has a buggy module that has consumed all of the site's available SQL connections.
- DotNetNuke inadvertently cached bad data and is not refreshing its cache.
- The SQL user account is either disabled or not configured correct.
- The database and site files are different versions.
To get more information on your
error, type this in the url bar and be sure to enter your real domain
and extension in place of yourdomain.com. http://yourdomain.com/install/install.aspx?mode=none
Resolution 1
First you should try recycling the application pool for the website.If recycling the application pool resolves the issue, then the problem was either the first or the second cause.
Resolution 2
Deleting and recreating an existing user can often fix this problem.
- Log into your Control Panel. Click on the System tab.
- In Plesk 9.x
- Click on Domains.
- Click on the domain that is giving you the error.
- In Plesk 11.x
- In the My Subscriptions section click on the domain that is giving you the error.
- Click on the Websites & Domains tab.
- Click on 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 a line that looks like the following
-
<
add
name
=
"SiteSqlServer"
connectionString
=
"Server=(local);Database=powerdnn;uid=powerdnn;pwd=powerdnn;"
providerName
=
"System.Data.SqlClient"
/>
Also find the line a few lines down that looks like this:
<
add
key
=
"SiteSqlServer"
value
=
"Server=(local);Database=powerdnn;uid=powerdnn;pwd=powerdnn;"
/>
- Change the values after Database=, uid=, and pwd= to equal the database name, username, and password you configured earlier.
- Recycle the Website's Application Pool.
Article ID: 206, Created: October 25, 2013 at 4:41 PM, Modified: October 25, 2013 at 4:41 PM