Trying to attach a database
Last Post 10/29/2009 8:57 PM by Dariusz. 3 Replies.
Author Messages
dejavu
Nuke Newbie
Nuke Newbie
Posts:8


--
10/29/2009 12:05 PM  
My installation worked fine, then I wanted to attach the database to SQL Server so I followed this tutorial:
Introduction to SQL Queries with SQL Server Express, DotNetNuke and Vista
http://www.dnncreative.com/Tutorial...fault.aspx

When I'm trying to open my installation it goes to the Installation Wizard and gives me this error message:

The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database. You can continue to use either of the other two Wizard options and configure the Database settings at the appropriate Wizard step.

My connection string:



and



I double checked the password, user id, and catalog a lot of times.

I'm running:

DNN 05.01.04
Windows 7
Microsoft SQL Server 2005

Is this error because I'm not running the Express edition? What else could it possibly be?




dejavu
Nuke Newbie
Nuke Newbie
Posts:8


--
10/29/2009 12:08 PM  
<!--Session data-->Can't post the connection string, but I'm pretty sure it is correct, I just followed the instructions.

<!--Session data-->[script removed]
Joseph Craig
DNN MVP
Posts:11667


--
10/29/2009 5:57 PM  
You can use the installation wizard to help you connect to the database. Database configuration begins with the second step, just after the permissions check.

Joe Craig, Patapsco Research Group
Complete DNN Support
Dariusz
Nuke Newbie
Nuke Newbie
Posts:2


--
10/29/2009 8:57 PM  
I implemented functionality of attaching database to SQL Server directly from my program SQL Server Comparison Tool (SCT).  You can download it from

http://www.sql-server-tool.com/sql-...wnload.htm

Once you are connected to the server, please click menu item Tools -> Attach Database, specify database name and the location of files, and click button "Attach".  SCT should attach the database and display confirmation message.

HTH

Dariusz


---