SQL Express Troubles

SQL Express Troubles

(env: .Net 2.0, SQL Server Express 2005)

I had a problem where I was asked to do some troubleshooting on someone else's code. I had almost successfully set the project up on my machine, but was getting DB permission problems. I could not use the default DB permissions and had to go into the master DB instance on my own machine to register the application user ID. Problem was that my SQL Express Manager was not recognizing the new DB for the app that I was debugging.

The above article contained the solution. Essentially, in order to enable SQL Express Manager to connect to an existing DB, use the following command, replacing the DB name and path with your own.

CREATE DATABASE ASPNetDb
ON (FILENAME = 'C:\Inetpub\wwwroot\ProAspNet20\App_Data\aspnetdb.mdf')
FOR ATTACH;