I am getting error message when trying to create a new database. I just recently installed sql server express and express mgmt studio. Everything loads up fine and I can enter the name of the database however once I click Ok, I get the error message:
Create failed for Database 'Student'. (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)
Any help is appreciated.
You are probably not a member of the db_creator role in SQL Server as creating a database require writing some entries in the system catalog (master database).
No comments:
Post a Comment