Hi everyone, thanks in advance for any suggestions.

I am having a hard time Attaching the DNN database file in SQL Express Management Studio. Whenever I try to attach, I get an error that the database is locked. Of course, I have been using Windows Authentication.

I have found some posts and blog entries like this one:
http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryId/1202/DNN-SQLExpress-SQL-Server-Management-Studio.aspx

Seems like I can use this to open up simultaneous access to the website & mgmt studio, but I don't know what the username/password for the SQL database is. I used the easy installation for DNN that already included the SQL database file. I have since changed my Host and Admin passwords and created users, but I am assuming that the SQL database username/password is completely different.

Could anyone point me in the right direction?

Thank you for the reply. Here's the connection string:

<add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

I assume the Integrated Security is being used instead of a SQL username/password?

Thanks!

Yes, thanks for the link. I will definitely give this a go.

The other question still surrounds the SQL username/password. I am obviously fairly ignorant about this, and I apologize, but should I be looking into creating a username/password in the SQL Management Studio or is there one already attached to it from the default installation of DNN?

Thanks again!