Moataz Amer
Moataz Amer

Reputation: 109

CREATE DATABASE permission denied in database 'master'

I receive this error when trying to login using ipadd/loginpage.aspx. This happens when I try to login on my Local Area Network using a different machine:

CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file E:\StoreDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Upvotes: 1

Views: 5774

Answers (1)

Harold Javier
Harold Javier

Reputation: 887

You cannot create a database nor attached a database because you have no privileged to do so. Here's my workaround:

First, run the SQL Server Management Studio as "administrator". Then, login to your account. Next, click the Security folder --> click Logins --> choose your account name --> check the properties and verify the status if you have permission to connect to database engine.

I hope it helps you.

Upvotes: 3

Related Questions