Click here to Skip to main content
13,406,816 members (50,887 online)
Rate this:
Please Sign up or sign in to vote.
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 1:50am
Updated 20-Nov-12 18:20pm
ryanb31 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

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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.

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180221.1 | Last Updated 23 Jun 2015
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100