Products

Solutions

Resources

Partners

Community

About

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 ...Stuck on DB connection. Stuck on DB connection.
Previous
 
Next
New Post
2/8/2008 1:28 PM
 

I'm trying to install the latest DDN onto our Windows 2003 server using a local SWL Server DB. I've read through the install PDF, which references that 3.x process for the package I'm using.

I set up the DB, the login, the user, then modified the web.config to match, then launched my site.

It then starts the wizard (which seems to repeat things I already did in web.config)

I get to the CONFIGURE DATABASE CONNECTOIN and I entered in the following:

Server: (local)

Database: DotNetNuke

User ID: DDNportal

Password: [the password]

Run ad dn Owner NOT checked.

Object qualifier: ddn_

I then run the TEST DATABASE CONNECTION and I get the green 'OK' text.

Then I hit next, and then get this connection error:

============

Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 16
Number: 2714
Message: There is already an object named 'DDNportaldnn_Version' in the database.

=============

Any ideas as to what is going on and what to change to fix?

 
New Post
2/8/2008 2:29 PM
 

You have already tried to install DNN into the specified database before with the same object qualifier.  Also, in most instances, you would want to run at DBO.


Will Strohl

Upendo Ventures Upendo Ventures
DNN experts since 2003
Official provider of the Hotcakes Commerce Cloud and SLA support
 
New Post
2/8/2008 2:52 PM
 

So...does 'testing' the connection 'install' the db, thereby causing the 'next' function to error out?

 

Is the fix to just blow out the DB and start fresh? (I'll give that a shot regardless)

 

With 4.x, is there any reason to do the manual config file changes, or is that what the wizard is for?

 

 
New Post
2/8/2008 3:50 PM
 

Testing the DB connection string does not install the database.  The next step in the wizard does. 

You are right.  You need to start with a fresh database.  If that is as far as you have gotten, that is all you have to do.  Otherwise, you may need to do the same with the files/directories.

There isn't a reason to do any manual config changes unless you want to modify the Install config to predefine some of the host settings.  If you do not know what I am talking about, you are probably not interested anyway.


Will Strohl

Upendo Ventures Upendo Ventures
DNN experts since 2003
Official provider of the Hotcakes Commerce Cloud and SLA support
 
New Post
2/11/2008 9:45 AM
 

Thanks, all.

Indeed, somehow, the DB got created, but the wizard never got beyond that screen, so any subsequent NEXT clicks would give me the error, as the DB was already there.

I went into SQL, delete the table that was created, went back to the site and then the wizard started over, this time fully installing the software.

Fairly painless in the end.

Again, thanks!

 

 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Stuck on DB connection. Stuck on DB connection.


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