Share via

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,441 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.

    0 comments
  2. ZoeHui-MSFT 41,491 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.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.