Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Initial Setup - Connecting database : connection error # 87, class 20, no messageInitial Setup - Connecting database : connection error # 87, class 20, no message
Previous
 
Next
New Post
1/20/2012 11:03 AM
 

Hello all,

I am attempting to set up a local install of DotNetNuke. I am using 6.1.2 - New Install found here . I have set up a site via IIS that points to the root of the installation. When I navigate there with my browser I see the setup wizard. I get as far as the database connection screen when I run into an issue.

 I have SQL server express 2008 running and set up a empty database for DNN.

 In the server text box I put \SQLEXPRESS and I enter the database name, which is simply "dnn", into the database field. When I  hit next I get the following error:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 20
Number: 87
Message:

 I'm not sure what I am doing wrong. It should be noted that when I want to access my local database server using SQL Server Management Studio I have to specify (local)\SQLEXPRESS as the host. When I try to do this in the DotNetNuke setup I get two errors:

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 11
Number: 4060
Message: Invalid Database

Index #: 1
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed

I have "integrated security" checked as my SQL Server is set up with Windows integrated authentication.

 If anyone has an idea about what I am doing wrong or any suggestions for fixing it I would very much appreciate it. Thanks!

 
New Post
1/21/2012 7:45 AM
 
When specifiy the server, you can do (local)\SQLEXPRESS. You can also replace (local) with a dot (.\SQLEXPRESS).

It appears your error is related to the application pool account with correct permisison to your database. Review the wiki link below

http://www.dotnetnuke.com/Resources/Wiki/Page/Install_DotNetNuke.aspx
 
New Post
1/23/2012 7:37 AM
 

Thanks for the response.

Very strange, the application pool the site is running under should have permissions for that database. I ended up creating a sql user account and connecting to the database using SQL Server authentication.

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Initial Setup - Connecting database : connection error # 87, class 20, no messageInitial Setup - Connecting database : connection error # 87, class 20, no message


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out