Learn More





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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Attaching to SQL Server Management StudioAttaching to SQL Server Management Studio
New Post
4/12/2013 1:33 PM

Hi Folks;

I successfully installed DNN 6.2.5 on Windows 7, SQL Server Express 2008, but am tearing my hair out trying to attach the database in App_Data to SQL Server Management Studio, so I can use the various management tools. I''ve read several blogs on the subject, and followed the instructions, but without success.  After I do the attach, I add several accounts as database owner: e.g. NETWORK SERVICE, the Windows administrator (login) account onto the attached database, and change the connection strings in web.config  from this

connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|atabase.mdf;Integrated Security=True;User Instance=True"

 to something like:

connectionString="Data Source=.\SQLExpress;Database=database;Integrated Security=True;User Instance=False" (in two places)

Then I restart the computer, and go to the URL  //localhost/dotnetnuke, but I still get a new Installation screen with  "cannot attach to any database" message. 

How do I figure out the connection strings to use?  The database is there, with all the DNN tables, but DNN cannot connect to it and just wants to reinstall.

Thanks for any help! 


New Post
4/12/2013 4:46 PM
I am having the EXACT same issue.
New Post
4/12/2013 7:35 PM

I got my DB to attach to SQL Express, read from SQL Express and run the site.

Prepare SQL Express per these directions:

Then change your connect string to this if you are suing SQL 2012.


Make sure to change the DATABASENAME-CREATED-EARLIER to the name of the DB as it was attached in SQL Express.

I am running IIS 8 and SQL EXPRESS 2012. Hopefully this guidance will work for you as well.

New Post
4/12/2013 8:06 PM
New Connect String should look like this:

Data Source=.\SQLExpress;Initial Catalog=DATABASENAME-CREATED-EARLIER;Integrated Security=True;
New Post
4/12/2013 10:33 PM

Just as an aside - you should avoid using a database file inside app_data in a production environment.  You can wind up with a variety of performance and permission issues depending on how your system is setup.  And if you are doing development work in visual studio you can also wind up with file lockouts and other oddness.

You are far better to create a database inside the sql server manager and let it handle permission and storage locations - and then connect to this database from dnn.


HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Attaching to SQL Server Management StudioAttaching to SQL Server Management Studio

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.
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?