Back

Can't create a DB through SSMS

Created 1 year ago
60 Views
0 Comments
ANUJeEKQAP
@ANUJeEKQAP
ANUJeEKQAP
@ANUJeEKQAPProfile is locked. Login

I'm following the SQL Server course. In order to implement the queries taught I tried to create DB through SSMS but I'm unable to do so. The error says:

TITLE: Microsoft SQL Server Management Studio

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

Create failed for Database 'test'. (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.200.48044.0&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.ConnectionInfo)

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

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-262-database-engine-error

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

BUTTONS:

OK

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



I think I don't have enough permission to create the DB. How can I resolve this issue.
Thank you in advance.


Comments
Please login to comment.