Cannot Create or Attach DB in SQLSEXPRESS

[mishbaker]

Using the SQL XM to create a new database, I connect remotely to my server (Ok), then I try to create a new database. Nothing fancy just the default. It gives me the following error:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Create failed for Database 'RESETdb'.  (Microsoft.SqlServer.Express.Smo)
------------------------------
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)

------------------------------

I have a default installation except I enabled the Browser and TCP/IP so I could connect from a remote location without specifying a port. Also, there is no firewall that I am aware of. Oh, if the answer is something easy and obvious, yes, I am an SQL rookie.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.

 

[mishbaker]

Nevermind. I wasn't assigned as an administrator for the Server. Problem fixed.

All lessons learned from the School of Hard Knocks........at least tuition is cheap.