Latish Sehgal's Blog

Vista + Sql Server 2005 Express = Not DB Admin (by Default)

I started working on Vista recently. It does not give you admin privileges by default (check out User Access Control for more details).

I was trying out some Web Parts sample code, and for quite some time, i wasn’t able to install NorthWind database into the Express DB; i kept on getting Insufficient Privileges errors. After lurking around on user forums, i finally found what i was looking for. I’ll just mention the simple steps to resolve this problem.

  1. Make sure you got the latest release. Check here.

  2. Open Sql Sevice 2005 Service Area Configuration tool. Click on the link Add New Administrator to open Sql Server 2005 User Provisioning Tool for Vista.

  1. Use the tool to give admin privileges to your user account.

That is all you need to do. You are now the administrator for your database.

Happy Programming!!