Unable to restore database in ssms

Question

Getting below error while i am trying to restore a database in SSMS.

TITLE: Microsoft SQL Server Management Studio

---

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

---

ADDITIONAL INFORMATION:

CREATE DATABASE permission denied in database 'master'.

RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 262)

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

---

BUTTONS:

OK

---

Answer 1

As the message says, you don't have permission. Why you expect to have permission, I don't know, because you did not tell us.

You will need to talk to your DBA or similar to get the permissions needed, or ask that person to restore the database for you.

By the way, SSMS is only a tool which you use to talk to SQL Server. The error message comes from SQL Server itself.

Answer 2

Hi @Ahuja, Muskan，

CREATE DATABASE permission denied in database 'master'.

The user must be a member of dbcreator server role for user to have enough permissions to create a database.

Server-level roles

Regards，

Zoe Hui

---

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