Click here to Skip to main content
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 1:50am
Edited 20-Nov-12 18: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
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  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

<pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="c#"><pre lang="Delphi"><pre lang="Delphi"><pre lang="Delphi"><pre lang="HTML"><pre lang="HTML"><pre lang="HTML"><pre lang="HTML"><pre lang="HTML">
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 7,130
1 DamithSL 5,089
2 Maciej Los 4,866
3 Sergey Alexandrovich Kryukov 4,647
4 Kornfeld Eliyahu Peter 4,409


Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 6 Aug 2014
Copyright © CodeProject, 1999-2014
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