Developers using Vista have some minor adjustments to make with the new security model in Microsoft's latest operating system. One of the first annoyances you might notice after installing SQL 2005 (I'm running Developer Edition), is that you will get permission errors when trying to create a new database. Luckily, there is an easy way around this using one of the new management features in SQL 2005: the Surface Area Configuration Tool. Simply launch this from All Programs > Microsoft SQL Server 2005 > Configuration Tools > Surface Area Configuration.
You will get the screen below; what we want to do is click on the "Add New Administrator" button.
Our next screen recognizes that we are on a Vista machine. In my case, I have two instances of SQL 2005 Developer edition on my laptop. Select one of both and move it across to your privileges to be granted. Click OK. You are now configured and will be able to create databases on your selected SQL instances.
My laptop, by default, came with SQL Express installed. I had worked on a few items before I noticed the need for Developer edition to test some extended functionality in SQL. After uninstalling SQL Express and installing Developer edition, I went to reattach my databases and got the following error:
This did not make a lot of sense – the SQL service is running under Local System, which has full permissions to the Data folder where all the database files are stored. What appears to have happened is that Vista reset the permissions on the existing files (i.e., my old databases) during the install, and these files did not inherit the permissions from the Data folder after Developer was done installing. Don't be tempted to tell all files to inherit permissions from the Data folder, as it is marked as read only and this would cause you other problems – apply the appropriate permissions to the database files and then you will be able to reattach without issue. It's a strange quirk of Vista, one that XP does not have, but still workable.
Be the first to rate this post
- Currently 0/5 Stars.
- 1
- 2
- 3
- 4
- 5