markwayne
asked on
Login Control Problem with VWD 2010 and SQL 2008
I have created a new web site with the new Visual Web Developer 2010 Express and SQL 2008 Express, the server is running IIS 6.0. When I try to login - I will get the following ...
***
Unable to open the physical file "E:\wwwroot\cssrarowing.ca \CSSRA_Reg istration\ App_Data\a spnetdb.md f". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\ CSSRA_Regi stration\A pp_Data\as pnetdb.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.SqlE xception: Unable to open the physical file "E:\wwwroot\cssrarowing.ca \CSSRA_Reg istration\ App_Data\a spnetdb.md f". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\ CSSRA_Regi stration\A pp_Data\as pnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Unable to open the physical file "E:\wwwroot\cssrarowing.ca \CSSRA_Reg istration\ App_Data\a spnetdb.md f". Operating system error 5: "5(Access is denied.)".
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\ CSSRA_Regi stration\A pp_Data\as pnetdb.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.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection) +5009598
System.Data.SqlClient.TdsP arser.Thro wException AndWarning () +234
System.Data.SqlClient.TdsP arser.Run( RunBehavio r runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlI nternalCon nectionTds .CompleteL ogin(Boole an enlistOK) +35
System.Data.SqlClient.SqlI nternalCon nectionTds .AttemptOn eLogin(Ser verInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
System.Data.SqlClient.SqlI nternalCon nectionTds .LoginNoFa ilover(Ser verInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
System.Data.SqlClient.SqlI nternalCon nectionTds .OpenLogin Enlist(Sql Connection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
System.Data.SqlClient.SqlI nternalCon nectionTds ..ctor(DbC onnectionP oolIdentit y identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
System.Data.SqlClient.SqlC onnectionF actory.Cre ateConnect ion(DbConn ectionOpti ons options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +185
System.Data.ProviderBase.D bConnectio nFactory.C reatePoole dConnectio n(DbConnec tion owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
System.Data.ProviderBase.D bConnectio nPool.Crea teObject(D bConnectio n owningObject) +524
System.Data.ProviderBase.D bConnectio nPool.User CreateRequ est(DbConn ection owningObject) +66
System.Data.ProviderBase.D bConnectio nPool.GetC onnection( DbConnecti on owningObject) +479
System.Data.ProviderBase.D bConnectio nFactory.G etConnecti on(DbConne ction owningConnection) +108
System.Data.ProviderBase.D bConnectio nClosed.Op enConnecti on(DbConne ction outerConnection, DbConnectionFactory connectionFactory) +126
System.Data.SqlClient.SqlC onnection. Open() +125
System.Web.DataAccess.SqlC onnectionH older.Open (HttpConte xt context, Boolean revertImpersonate) +95
System.Web.DataAccess.SqlC onnectionH elper.GetC onnection( String connectionString, Boolean revertImpersonation) +206
System.Web.Security.SqlMem bershipPro vider.GetP asswordWit hFormat(St ring username, Boolean updateLastLoginActivityDat e, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount , Int32& failedPasswordAnswerAttemp tCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +827
System.Web.Security.SqlMem bershipPro vider.Chec kPassword( String username, String password, Boolean updateLastLoginActivityDat e, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
System.Web.Security.SqlMem bershipPro vider.Vali dateUser(S tring username, String password) +106
System.Web.UI.WebControls. Login.Auth enticateUs ingMembers hipProvide r(Authenti cateEventA rgs e) +60
System.Web.UI.WebControls. Login.OnAu thenticate (Authentic ateEventAr gs e) +129
System.Web.UI.WebControls. Login.Atte mptLogin() +127
System.Web.UI.WebControls. Login.OnBu bbleEvent( Object source, EventArgs e) +101
System.Web.UI.Control.Rais eBubbleEve nt(Object source, EventArgs args) +37
System.Web.UI.WebControls. Button.OnC ommand(Com mandEventA rgs e) +125
System.Web.UI.WebControls. Button.Rai sePostBack Event(Stri ng eventArgument) +167
System.Web.UI.WebControls. Button.Sys tem.Web.UI .IPostBack EventHandl er.RaisePo stBackEven t(String eventArgument) +10
System.Web.UI.Page.RaisePo stBackEven t(IPostBac kEventHand ler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePo stBackEven t(NameValu eCollectio n postData) +36
System.Web.UI.Page.Process RequestMai n(Boolean includeStagesBeforeAsyncPo int, Boolean includeStagesAfterAsyncPoi nt) +5563
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
***
Unable to open the physical file "E:\wwwroot\cssrarowing.ca
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\
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.SqlE
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Unable to open the physical file "E:\wwwroot\cssrarowing.ca
An attempt to attach an auto-named database for file E:\wwwroot\cssrarowing.ca\
System.Data.SqlClient.SqlI
System.Data.SqlClient.TdsP
System.Data.SqlClient.TdsP
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlI
System.Data.SqlClient.SqlC
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.ProviderBase.D
System.Data.SqlClient.SqlC
System.Web.DataAccess.SqlC
System.Web.DataAccess.SqlC
System.Web.Security.SqlMem
System.Web.Security.SqlMem
System.Web.Security.SqlMem
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.Control.Rais
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.WebControls.
System.Web.UI.Page.RaisePo
System.Web.UI.Page.RaisePo
System.Web.UI.Page.Process
--------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.