Click here to Skip to main content
11,576,977 members (49,755 online)
Rate this: bad
good
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 0:50am
Edited 20-Nov-12 17:20pm
v2
Comments
ryanb31 at 20-Nov-12 7:49am
   
Permission denied usually means what it says.
veenusethi at 20-Nov-12 23:20pm
   
I cant understand why this problem occur

1 solution

Rate this: bad
good
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.

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
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 251
1 DamithSL 155
2 Abhinav S 130
3 OriginalGriff 105
4 Afzaal Ahmad Zeeshan 85
0 OriginalGriff 715
1 Sergey Alexandrovich Kryukov 631
2 Abhinav S 528
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 365


Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 23 Jun 2015
Copyright © CodeProject, 1999-2015
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