Click here to Skip to main content
Search within:




Next

create database permission denied in database 'master'. an attempt to attach an auto-named database for file
Sign Up to vote bad
good
See more: IIS7SqlServerasp.net4
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
veenusehgal1K
Edited 20-Nov-12 17:20pm
v2
Add a Solution

Comments
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

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  
Posted 20-Nov-12 18:12pm
veenusehgal1K
Add a Solution

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Christian Graus 514
1 Ron Beyer 296
2 OriginalGriff 248
3 samadhan_kshirsagar 229
4 Tadit Dash 213
0 Sergey Alexandrovich Kryukov 7,007
1 Prasad_Kulkarni 3,815
2 OriginalGriff 3,557
3 _Amy 3,372
4 CPallini 2,975


Advertise | Privacy | Mobile
Web03 | 2.6.130617.1 | Last Updated 21 Nov 2012
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid