How do I assign myself the sysadmin role in SQL Server Express? : Microsoft, SQL Server Express 2005, Installed on Vista Home Basic, User does not have permission to perform this action; Error 15247:

With Vista's User Account Control (UAC) turned on, you're really not an Administrator after all. If you turn off UAC (or launch the Studio with the 'Run As [Administrator]') everything will be back to the way you're used to it working.


Thank heavens. Was pulling hair over here.