How to fix Error 262 in Microsoft SQL Server?

Şevval Çakır 0 Reputation points
2023-09-18T10:30:01.8733333+00:00

TITLE: Microsoft SQL Server Management Studio

Create failed for Database 'deneme'. (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

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

2 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Olaf Helper 47,621 Reputation points
    2023-09-18T12:02:11.58+00:00

    CREATE DATABASE permission denied in database 'master'.

    As the message says, you don't have the permission to create a new database. Ask your DBA to grant you permissions or to create the database for you.

    Was this answer helpful?

    0 comments
  2. ZoeHui-MSFT 41,551 Reputation points
    2023-09-19T01:48:52.1866667+00:00

    Hi @Şevval Çakır,

    CREATE DATABASE permission denied in database 'master'

    Seems like a permission issue, the user account you're using doesn't have the permission to create a new database.

    You may use the admin account to grant the permission to your account.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Was this answer helpful?

    0 comments