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!