Reputation: 109
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
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