How exactly do I correct this problem on Vista?
TITLE: Microsoft SQL Server Management Studio Express
Create failed for Database 'kkl'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
I have ensured that I am logged into the system as Admin but cannot find where on the Server, I assign my login to the dbcreator group.
I have gone into Security >> Server Roles >> dbcreator. of which I am not a member. On a different system, where all works, however, I am not a member of this group either.
Any suggestions on how to kill this one?
Thanks in Advance.
Klaus
and this fixed my problem:
http://msdn2.microsoft.com/en-us/library/bb326612.aspx
