Sunday, September 16, 2007

SQL Express (Jolly Good Surprises)

If you are working with SQL Express 2005 and you encounter shit like this: "Could not attach file 'c:\blablabla\databasename.mdf' as database 'databasename'. CREATE DATABASE permission denied in database 'master'", you would be doing yourself a favour by installing Microsoft SQL Server Management Studio Express because granting permissions using queiries is just so passe.

Anyways, the solution to that problem was to add the ASPNET account, or the Network Service account to the master db in SQL Express.

Moving on now to another error message: "Failed to update database "databasename" because the database is read-only." Be sure to give full access to the ASPNET account or Network Service account for the APP_DATA folder, and you should be on your way.

Yeah... I'm working on something with SQL Express.