Sergey, Naomi,
It turns out (I think) that the failure to see the database in management studio is a result of the fact that it is a SQL Express database (not a full blown sql database) where the database is not setup as "an instance", but rather as an "attached mdf" and "user instance" is set to true - I think this is a special case for SQL Express? I can't say that I fully understand the following blog article,but, all I can say is that I started over and did the install as per the instructions in the blog, and then it worked, and I could see the database. The dnn install package comes with a database.mdf file. If you follow the default dnn installation wizard for sql express, then the database won't be visible. The instructions in the blog have you attach that database.mdf as a database, so it is visible before you start the dnn install wizard. I chose "DNN" as the database name, not "Database", but I have a feeling that if I chose "database", it would have been visible, but just would have been difficult to manage as per your comments.
http://www.dotnetnuke.com/Community/Blogs/tabid/825/EntryId/1202/DNN-SQLExpress-SQL-Server-Management-Studio.aspxThanks for your help!
>It's a bad idea to use reserved words as object names in SQL Server. You'll have to enclose them in delimiters [] every time you use them.
>
>>(Actually the version is server 2008 r2 express)
>>
>>I am working with Dotnetnuke (DNN) 505. On a brand new install my database file ended up being named database.mdf)
>>(by default I think?). I did the install on my local win 7 machine. I also installed sql management studio. (However the management studio won't start - but, I think, that is a separate issue).
>>
>>I got the install up and running and the DNN website going - but I never bothered to check out the details of the database because my management studio wasn't working. Then I used management studio on another machine to find the sql server database - but I couldn't find it. But I know that (well... pretty sure) that there is a database called database.mdf up and running on the machine.
>>Logged in as administrator on the account and as sa. If I try to do an "attach database of database.mdf" it says that it is in use by another process. My web.config file is pasted below.
>>
>>If I attempt the command "use database", I get "syntax error near the keyword database". Is it a problem that the database name is a keyword?
>>
