Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 18th, 2007, 11:15 PM
Registered User
 
Join Date: Oct 2007
Location: Hull, , United Kingdom.
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via MSN to damonuk
Default ISS Permission denied

Hi all, I have finally got the wroxunited working via cassini but once I load it via ISS I get an access denied error message.

I have used iis properties to locate which account is accessing my website (anonymous access), and I have also given read&execute, list folder contents, read and write for both aspnet and my anonymous user IUSR_WINXP

I am using Winxp pro, Visual Studio Pro, ASP Dev, Iss 5.1

The error:

CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:\Websites\WroxUnited\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:\Websites\WroxUnited\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

Line 112: Public Overridable Property Theme() As String
Line 113: Get
Line 114: Return CType(Me.GetPropertyValue("Theme"),String)
Line 115: End Get
Line 116: Set

Source File: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.2a9u0e mb.6.vb Line: 114

Stack Trace:

[SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file C:\Websites\WroxUnited\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.]
System.Data.SqlClient.SqlInternalConnection. OnError(SqlException exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExcepti onAndWarning(TdsParserStateObject stateObj) +188
System.Data.SqlClient.TdsParser.Run(RunBehav ior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956
System.Data.SqlClient.SqlInternalConnectionT ds.CompleteLogin(Boolean enlistOK) +33
System.Data.SqlClient.SqlInternalConnectionT ds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +170
System.Data.SqlClient.SqlInternalConnectionT ds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +349
System.Data.SqlClient.SqlInternalConnectionT ds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionT ds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.C reateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory .CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.Cr eateObject(DbConnection owningObject) +424
System.Data.ProviderBase.DbConnectionPool.Us erCreateRequest(DbConnection owningObject) +66
System.Data.ProviderBase.DbConnectionPool.Ge tConnection(DbConnection owningObject) +496
System.Data.ProviderBase.DbConnectionFactory .GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed. OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
System.Web.DataAccess.SqlConnectionHolder.Op en(HttpContext context, Boolean revertImpersonate) +84
System.Web.DataAccess.SqlConnectionHelper.Ge tConnection(String connectionString, Boolean revertImpersonation) +197
System.Web.Profile.SqlProfileProvider.GetPro pertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +766
System.Web.Profile.SqlProfileProvider.GetPro pertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428
System.Configuration.SettingsBase.GetPropert iesFromProvider(SettingsProvider provider) +410
System.Configuration.SettingsBase.GetPropert yValueByName(String propertyName) +117
System.Configuration.SettingsBase.get_Item(S tring propertyName) +89
System.Web.Profile.ProfileBase.GetInternal(S tring propertyName) +36
System.Web.Profile.ProfileBase.get_Item(Stri ng propertyName) +68
System.Web.Profile.ProfileBase.GetPropertyVa lue(String propertyName) +4
ProfileCommon.get_Theme() in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temp orary ASP.NET Files\wroxunited\4d46c25b\c57181c9\App_Code.2a9u0e mb.6.vb:114
Wrox.Web.GlobalEvents.ThemeModule.app_PreReq uestHandlerExecute(Object Sender, EventArgs E) in C:\Websites\WroxUnited\App_Code\ThemeModule.vb:30
System.Web.SyncEventExecutionStep.System.Web .HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExec utionStep step, Boolean& completedSynchronously) +64

Kind Regards

Damon Simpson (www.damonsimpson.co.uk)
Reply With Quote
  #2 (permalink)  
Old October 19th, 2007, 12:45 AM
Registered User
 
Join Date: Oct 2007
Location: Hull, , United Kingdom.
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via MSN to damonuk
Default

For anyone with the same problem, I have FINALLY got WroxUnited working on iss with winxp pro, vis pro and sql full :)

The problem I had is that I did not include the server roles: dbcreator and sysadmin within my (computerName)/ASPNET login.

A whole week to figure that out but ohh well, its working now.

Time to start reading the book now :)

Regards

Damon Simpson (www.damonsimpson.co.uk)

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
AccessException: [ISS.0084.9004] Access Denied hany ASP.NET 1.0 and 1.1 Professional 0 May 15th, 2007 04:34 AM
(0x800A0046) Permission denied,not IIS permission! David Hay Classic ASP Basics 3 April 30th, 2006 10:47 PM
Permission denied zah_amir Classic ASP Databases 1 January 24th, 2006 11:45 PM
Permission denied tksarun Classic ASP Components 0 March 11th, 2005 03:01 AM
Permission Denied einstein Linux 1 December 10th, 2003 09:49 AM



All times are GMT -4. The time now is 04:08 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.