create database permission denied in database 'master'. an attempt to attach an auto-named database for file

Question

3.00/5 (1 vote)

See more:

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

i don't what is this problem ?
i googled so much but no solution.
i got this error when i installed web setup in another pc which is created by me in vs2010, and sqlserver 2008 r2.

please help me

Posted 20-Nov-12 0:50am

veenusethi

Updated 20-Nov-12 17:20pm

v2

Add a Solution

Comments

ZurdoDev 20-Nov-12 7:49am

Permission denied usually means what it says.

veenusethi 20-Nov-12 23:20pm

I cant understand why this problem occur

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

veenusethi · Answer 1 · 2012-11-20T18:12:00

I got the solution

I solved myself

this is a permission problem in sql server studio management
step1)Go to sql server management studio and expand security

Step2)Right Click on Login and choose New Login

Step3)Now write in Login name textbox NT AUTHORITY\IUSR

Step4)In left hand of window click on Server roles and now select public

and sysadmin now click on Ok.

Done
if you have already NT AUTHORITY\IUSR user then just check server roles here sysadmin is select or not

Happy Programming

Please Vote if it solved your problem