Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista:
CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\test.mdf' , SIZE = 5120KB , FILEGROWTH = 10%) LOG ON ( NAME = N'test_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\test_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
Msg 262, Level 14, State 1, Line 1 CREATE DATABASE permission denied in database 'master'.
The surface area tool I found references to for sql 2005 no longer exists and I can't figure out how to add local admins (of which I am one) to db admins for sql express.
As far as I'm aware this is a fairly standard install.
How do I create a new database?