> Can someone help me or explain to me how to configure IIS so users to
> login to my website using standard Visual Studio 2008 Login / Login
> View Controls?
>
> Here is the scenerio:
>
> INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> weeks.)
>
> LOADED VISUAL STUDIO 2008 PROFESSIONAL.
>
> (MS SQL SERVER 2005 EXPRESS)
>
> INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
>
> WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
>
> CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> SELECTED (except Dynamic Content))
>
> CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
>
> I HAVE NO ISSUES LOGGING IN usinghttp://localhost
>
> I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> TO MY STATIC HOME IP ADDRESS.
>
> I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> in my browswer.
>
> BUT, I keep getting the error listed below when I attempt to login:
>
> Server Error in '/' Application.
> ---------------------------------------------------------------------------­-----
>
> User does not have permission to perform this action.
> 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: User does not
> have permission to perform this action.
>
> 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): User does not have permission to perform
> this action.]
>    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection) +4846887
>    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> (TdsParserStateObject stateObj) +194
>    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> SqlCommand cmdHandler, SqlDataReader dataStream,
> BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> stateObj) +2392
>    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> (Boolean enlistOK) +35
>    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> (ServerInfo serverInfo, String newPassword, Boolean
> ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> +144
>    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> (String host, String newPassword, Boolean redirectedUserInstance,
> SqlConnection owningObject, SqlConnectionString connectionOptions,
> Int64 timerStart) +342
>    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> (SqlConnection owningObject, SqlConnectionString connectionOptions,
> String newPassword, Boolean redirectedUserInstance) +221
>    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> (DbConnectionPoolIdentity identity, SqlConnectionString
> connectionOptions, Object providerInfo, String newPassword,
> SqlConnection owningObject, Boolean redirectedUserInstance) +189
>    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> (DbConnectionOptions options, Object poolGroupProviderInfo,
> DbConnectionPool pool, DbConnection owningConnection) +4861315
>    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> (DbConnection owningConnection, DbConnectionPool pool,
> DbConnectionOptions options) +31
>    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> owningObject) +433
>    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> (DbConnection owningObject) +66
>    System.Data.ProviderBase.DbConnectionPool.GetConnection
> (DbConnection owningObject) +499
>    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> (DbConnection owningConnection) +65
>    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> +117
>    System.Data.SqlClient.SqlConnection.Open() +122
>    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> Boolean revertImpersonate) +87
>    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> connectionString, Boolean revertImpersonation) +221
>    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> (String username, Boolean updateLastLoginActivityDate, Int32& status,
> String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> lastActivityDate) +815
>    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> username, String password, Boolean updateLastLoginActivityDate,
> Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
>    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> username, String password, Boolean updateLastLoginActivityDate,
> Boolean failIfNotApproved) +42
>    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> username, String password) +78
>    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> (AuthenticateEventArgs e) +60
>    System.Web.UI.WebControls.Login.OnAuthenticate
> (AuthenticateEventArgs e) +119
>    System.Web.UI.WebControls.Login.AttemptLogin() +115
>    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> EventArgs e) +101
>    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> args) +37
>    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
>    System.Web.UI.WebControls.Button.RaisePostBackEvent(String
> eventArgument) +166
>
> System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaiseP­ostBackEvent
> (String eventArgument) +10
>    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument) +13
>    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> +36
>    System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> +1565
>
> ---------------------------------------------------------------------------­-----
> Version Information: Microsoft .NET Framework Version:2.0.50727.3074;
> ASP.NET Version:2.0.50727.3074
>
> WHAT PERMISSIONS TO ACCESS WHAT FOLDER WHERE????  THE APP_DATA
> DIRECTORY?  THE C:\INETPUB FOLDER ?  WWROOT?
>
> IS THIS A PROBLEM WITH SQL SERVER 2005 EXPRESS ?  CAN I USE THIS FOR
> EDUCATIONAL PURPOSES TO DEVELOP WEB APPS THAT I MIGHT NEED FOR MY 6000
> PROJECT???
>
> IS THERE A STEP-BY-STEP CONFIGURATION GUIDE SOMEWHERE ON THE INTERNET?
>
> IF NECESSARY, I CAN RELOAD WINDOWS SERVER 2008 AGAIN, I CAN RELOAD
> VISUAL STUDIO 2008 AND I CAN LOAD SQL SERVER 2005 for DEVELOPMENT
> EDITION OF MS SQL SERVER 2008...
>
> SHOULD I SIMPLY QUIT TRYING TO CONFIGURE MICROSOFT PRODUCTS TO BE
> USABLE OUTSIDE OF A LOCAL AREA NET WORK?
>
> CAN SOMEONE CALL ME AND TALK ME THROUGH THIS??  IS IT REALLY THIS
> HARD??  DOES IT REALLY HAVE TO BE THIS HARD??
>
> SHOULD I TAKE A NAP AND TRY AGAIN??
>
> I USED SCOTT GUTHERIE'S ASP.NET CONFIGURATION GUIDE WHERE I THOUGHT IT
> MIGHT HELP.
>
> OH AND BY THE WAY, After the 3rd windows server 2008 reload, I decided
> to use mssql 2005 express rather than waiting again for ms sql server
> 2005 to load up.

> On Apr 14, 12:19 pm, karleldrid***@gmail.com wrote:
>
>
>
>
>
> > Can someone help me or explain to me how to configure IIS so users to
> > login to my website using standard Visual Studio 2008 Login / Login
> > View Controls?
>
> > Here is the scenerio:
>
> > INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> > weeks.)
>
> > LOADED VISUAL STUDIO 2008 PROFESSIONAL.
>
> > (MS SQL SERVER 2005 EXPRESS)
>
> > INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
>
> > WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
>
> > CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> > SELECTED (except Dynamic Content))
>
> > CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
>
> > I HAVE NO ISSUES LOGGING IN usinghttp://localhost
>
> > I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> > TO MY STATIC HOME IP ADDRESS.
>
> > I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> > in my browswer.
>
> > BUT, I keep getting the error listed below when I attempt to login:
>
> > Server Error in '/' Application.
> > ---------------------------------------------------------------------------­­-----
>
> > User does not have permission to perform this action.
> > 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: User does not
> > have permission to perform this action.
>
> > 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): User does not have permission to perform
> > this action.]
> >    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection) +4846887
> >    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> > (TdsParserStateObject stateObj) +194
> >    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > SqlCommand cmdHandler, SqlDataReader dataStream,
> > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> > stateObj) +2392
> >    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> > (Boolean enlistOK) +35
> >    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> > (ServerInfo serverInfo, String newPassword, Boolean
> > ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> > +144
> >    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> > (String host, String newPassword, Boolean redirectedUserInstance,
> > SqlConnection owningObject, SqlConnectionString connectionOptions,
> > Int64 timerStart) +342
> >    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> > (SqlConnection owningObject, SqlConnectionString connectionOptions,
> > String newPassword, Boolean redirectedUserInstance) +221
> >    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> > (DbConnectionPoolIdentity identity, SqlConnectionString
> > connectionOptions, Object providerInfo, String newPassword,
> > SqlConnection owningObject, Boolean redirectedUserInstance) +189
> >    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> > (DbConnectionOptions options, Object poolGroupProviderInfo,
> > DbConnectionPool pool, DbConnection owningConnection) +4861315
> >    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> > (DbConnection owningConnection, DbConnectionPool pool,
> > DbConnectionOptions options) +31
> >    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> > owningObject) +433
> >    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> > (DbConnection owningObject) +66
> >    System.Data.ProviderBase.DbConnectionPool.GetConnection
> > (DbConnection owningObject) +499
> >    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> > (DbConnection owningConnection) +65
> >    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> > (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> > +117
> >    System.Data.SqlClient.SqlConnection.Open() +122
> >    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> > Boolean revertImpersonate) +87
> >    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> > connectionString, Boolean revertImpersonation) +221
> >    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> > (String username, Boolean updateLastLoginActivityDate, Int32& status,
> > String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> > failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> > Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> > lastActivityDate) +815
> >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > username, String password, Boolean updateLastLoginActivityDate,
> > Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
> >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > username, String password, Boolean updateLastLoginActivityDate,
> > Boolean failIfNotApproved) +42
> >    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> > username, String password) +78
> >    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> > (AuthenticateEventArgs e) +60
> >    System.Web.UI.WebControls.Login.OnAuthenticate
> > (AuthenticateEventArgs e) +119
> >    System.Web.UI.WebControls.Login.AttemptLogin() +115
> >    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> > EventArgs e) +101
> >    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> > args) +37
> >    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
> >    System.Web.UI.WebControls.Button.RaisePostBackEvent(String
> > eventArgument) +166
>
> > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaiseP­­ostBackEvent
> > (String eventArgument) +10
> >    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument) +13
> >    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> > +36
> >    System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > +1565
>
> > ---------------------------------------------------------------------------­­-----
> > Version Information: Microsoft .NET Framework Version:2.0.50727.3074;
> > ASP.NET Version:2.0.50727.3074
>
> > WHAT PERMISSIONS TO ACCESS WHAT FOLDER WHERE????  THE APP_DATA
> > DIRECTORY?  THE C:\INETPUB FOLDER ?  WWROOT?
>
> > IS THIS A PROBLEM WITH SQL SERVER 2005 EXPRESS ?  CAN I USE THIS FOR
> > EDUCATIONAL PURPOSES TO DEVELOP WEB APPS THAT I MIGHT NEED FOR MY 6000
> > PROJECT???
>
> > IS THERE A STEP-BY-STEP CONFIGURATION GUIDE SOMEWHERE ON THE INTERNET?
>
> > IF NECESSARY, I CAN RELOAD WINDOWS SERVER 2008 AGAIN, I CAN RELOAD
> > VISUAL STUDIO 2008 AND I CAN LOAD SQL SERVER 2005 for DEVELOPMENT
> > EDITION OF MS SQL SERVER 2008...
>
> > SHOULD I SIMPLY QUIT TRYING TO CONFIGURE MICROSOFT PRODUCTS TO BE
> > USABLE OUTSIDE OF A LOCAL AREA NET WORK?
>
> > CAN SOMEONE CALL ME AND TALK ME THROUGH THIS??  IS IT REALLY THIS
> > HARD??  DOES IT REALLY HAVE TO BE THIS HARD??
>
> > SHOULD I TAKE A NAP AND TRY AGAIN??
>
> > I USED SCOTT GUTHERIE'S ASP.NET CONFIGURATION GUIDE WHERE I THOUGHT IT
> > MIGHT HELP.
>
> > OH AND BY THE WAY, After the 3rd windows server 2008 reload, I decided
> > to use mssql 2005 express rather than waiting again for ms sql server
> > 2005 to load up.
>
> COULD THIS HAVE SOMETHIS TO WITH REQUIRING A STORED PROCEDURE IN
> MSSQL??- Hide quoted text -
>
> - Show quoted text -

"David Wang" wrote:

> On Apr 14, 9:33 am, karleldrid***@gmail.com wrote:
> > On Apr 14, 12:19 pm, karleldrid***@gmail.com wrote:
> >
> >
> >
> >
> >
> > > Can someone help me or explain to me how to configure IIS so users to
> > > login to my website using standard Visual Studio 2008 Login / Login
> > > View Controls?
> >
> > > Here is the scenerio:
> >
> > > INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> > > weeks.)
> >
> > > LOADED VISUAL STUDIO 2008 PROFESSIONAL.
> >
> > > (MS SQL SERVER 2005 EXPRESS)
> >
> > > INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
> >
> > > WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
> >
> > > CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> > > SELECTED (except Dynamic Content))
> >
> > > CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
> >
> > > I HAVE NO ISSUES LOGGING IN usinghttp://localhost
> >
> > > I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> > > TO MY STATIC HOME IP ADDRESS.
> >
> > > I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> > > in my browswer.
> >
> > > BUT, I keep getting the error listed below when I attempt to login:
> >
> > > Server Error in '/' Application.
> > > ---------------------------------------------------------------------------­­-----
> >
> > > User does not have permission to perform this action.
> > > 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: User does not
> > > have permission to perform this action.
> >
> > > 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): User does not have permission to perform
> > > this action.]
> > >    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > exception, Boolean breakConnection) +4846887
> > >    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> > > (TdsParserStateObject stateObj) +194
> > >    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > > SqlCommand cmdHandler, SqlDataReader dataStream,
> > > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> > > stateObj) +2392
> > >    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> > > (Boolean enlistOK) +35
> > >    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> > > (ServerInfo serverInfo, String newPassword, Boolean
> > > ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> > > +144
> > >    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> > > (String host, String newPassword, Boolean redirectedUserInstance,
> > > SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > Int64 timerStart) +342
> > >    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> > > (SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > String newPassword, Boolean redirectedUserInstance) +221
> > >    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> > > (DbConnectionPoolIdentity identity, SqlConnectionString
> > > connectionOptions, Object providerInfo, String newPassword,
> > > SqlConnection owningObject, Boolean redirectedUserInstance) +189
> > >    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> > > (DbConnectionOptions options, Object poolGroupProviderInfo,
> > > DbConnectionPool pool, DbConnection owningConnection) +4861315
> > >    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> > > (DbConnection owningConnection, DbConnectionPool pool,
> > > DbConnectionOptions options) +31
> > >    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> > > owningObject) +433
> > >    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> > > (DbConnection owningObject) +66
> > >    System.Data.ProviderBase.DbConnectionPool.GetConnection
> > > (DbConnection owningObject) +499
> > >    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> > > (DbConnection owningConnection) +65
> > >    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> > > (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> > > +117
> > >    System.Data.SqlClient.SqlConnection.Open() +122
> > >    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> > > Boolean revertImpersonate) +87
> > >    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> > > connectionString, Boolean revertImpersonation) +221
> > >    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> > > (String username, Boolean updateLastLoginActivityDate, Int32& status,
> > > String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> > > failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> > > Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> > > lastActivityDate) +815
> > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > username, String password, Boolean updateLastLoginActivityDate,
> > > Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
> > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > username, String password, Boolean updateLastLoginActivityDate,
> > > Boolean failIfNotApproved) +42
> > >    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> > > username, String password) +78
> > >    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> > > (AuthenticateEventArgs e) +60
> > >    System.Web.UI.WebControls.Login.OnAuthenticate
> > > (AuthenticateEventArgs e) +119
> > >    System.Web.UI.WebControls.Login.AttemptLogin() +115
> > >    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> > > EventArgs e) +101
> > >    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> > > args) +37
> > >    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
> > >    System.Web.UI.WebControls.Button.RaisePostBackEvent(String
> > > eventArgument) +166
> >
> > > System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaiseP­­ostBackEvent
> > > (String eventArgument) +10
> > >    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument) +13
> > >    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> > > +36
> > >    System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > +1565
> >
> > > ---------------------------------------------------------------------------­­-----
> > > Version Information: Microsoft .NET Framework Version:2.0.50727.3074;
> > > ASP.NET Version:2.0.50727.3074
> >
> > > WHAT PERMISSIONS TO ACCESS WHAT FOLDER WHERE????  THE APP_DATA
> > > DIRECTORY?  THE C:\INETPUB FOLDER ?  WWROOT?
> >
> > > IS THIS A PROBLEM WITH SQL SERVER 2005 EXPRESS ?  CAN I USE THIS FOR
> > > EDUCATIONAL PURPOSES TO DEVELOP WEB APPS THAT I MIGHT NEED FOR MY 6000
> > > PROJECT???
> >
> > > IS THERE A STEP-BY-STEP CONFIGURATION GUIDE SOMEWHERE ON THE INTERNET?
> >
> > > IF NECESSARY, I CAN RELOAD WINDOWS SERVER 2008 AGAIN, I CAN RELOAD
> > > VISUAL STUDIO 2008 AND I CAN LOAD SQL SERVER 2005 for DEVELOPMENT
> > > EDITION OF MS SQL SERVER 2008...
> >
> > > SHOULD I SIMPLY QUIT TRYING TO CONFIGURE MICROSOFT PRODUCTS TO BE
> > > USABLE OUTSIDE OF A LOCAL AREA NET WORK?
> >
> > > CAN SOMEONE CALL ME AND TALK ME THROUGH THIS??  IS IT REALLY THIS
> > > HARD??  DOES IT REALLY HAVE TO BE THIS HARD??
> >
> > > SHOULD I TAKE A NAP AND TRY AGAIN??
> >
> > > I USED SCOTT GUTHERIE'S ASP.NET CONFIGURATION GUIDE WHERE I THOUGHT IT
> > > MIGHT HELP.
> >
> > > OH AND BY THE WAY, After the 3rd windows server 2008 reload, I decided
> > > to use mssql 2005 express rather than waiting again for ms sql server
> > > 2005 to load up.
> >
> > COULD THIS HAVE SOMETHIS TO WITH REQUIRING A STORED PROCEDURE IN
> > MSSQL??- Hide quoted text -
> >
> > - Show quoted text -
>
>
> The user account running your web app on the web server needs to have
> permissions to log in to the SQL database.
>
> The stack trace tells you this, and the corrective action should be
> clear. I recommend against reinstalling the OS, SQL Server, etc
> because as you have found out, it is needless self-inflicted pain.
>
> The behavior is different because when you debug in Visual Studio, it
> uses your user identity to run a debug webserver to host your
> application so everything looks like it works, but when you publish
> for real to a web server, the application has to use the web server's
> application pool identity. Usually, the default configuration already
> provides access to those identities, so you must be doing something
> non-default -- at which point you are completely responsible for
> knowing how things work because you are customizing.
>
> I think you need to learn more about how stuff actually works before
> assuming you are qualified to do what you want and complain that it is
> too hard. When you lack knowledge, even the simplest thing can seem
> difficult. Likewise, with knowledge, even the hardest thing looks
> trivial. At this point, Computers have not reach that stage of
> intelligence, so you will have to know excatly what you need to do and
> tell the computer to do it.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>

> Hello David -
>
> Thank you for your response, I think.  
>
> Why the rude tone telling me the reams of exceptions that I received was
> clearly telling me that "The user account running your web app on the web
> server needs to have permissions to log in to the SQL database. The stack
> trace tells you this, and the corrective action should be clear." Where in
> the stack trace is this "CLEAR"?
>
> Why take a slippery slope approach telling me that I must have misconfigured
> something, yet you refer to my original post stating clearly that I reloaded
> my whole system (could it be that I already went down your 'clearly'
> thoughtful path and considered that I might have misconfigured something? and
> wanted to ensure a DEFAULT CONFIGURATION?) and why on the  first 3 attempts
> did the default configuration not work as you so brilliantly suggest that it
> should?
>
>  WANG WROTE: "Usually, the default configuration already provides access to
> those identities, so you must be doing something non-default -- at which
> point you are completely responsible forknowing how things work because you
> are customizing."
>
> Slippery slope = USUALLY + MUST BE DOING SOMETHING WRONG + CUSTOMIZING
>
> Usually??? Does this mean three out of four times a user reloads a sytem in
> a default configuration? Could you give me hint as to when a user might
> expect it not to be the usual case - does microsoft have some secret squirrel
> formula for calculating when a default configuration will load in a
> non-default manner...Customizing what??  I RELOADED MY SYSTEM THREE TIMES TO
> BASE LINE IT TO A DEFAULT CONFIGURATION ... AH YES, YOU CAN INTERPRET THE
> STACK TRACE, BUT YOU COULDN'T READ THAT I RELOADED (BASE-LINED TO A DEFAULT
> CONFIGURATION)?   WHY ASS_U - NOT ME? OOOPs... I mean, WHY ASSUME?
>
> Where did I say I was qualified, compentent or beyond learning or even able
> to keep up with the crazy, crazy service packs, updates, tweaks and changes
> that occur at Microsoft every few hours?  You know everything? AMAZING! I
> knew I was beaten by my lack of knowledge and that's why I asked the
> question...I had hoped someone might have actually answered the question
> rather than tell me I should become an expert before asking a
> question...think about it ... knowledgeable or not, I clearly stated in my
> rambling post that I had literally spent 3 days without sleep trying to get
> this problem resolved...oh!  you probably weren't able to decipher that in
> all the ramblings, much in the same way I was not able to decipher the
> rambling stack trace after 3 days without sleep!
>
> Truth be known, I am learning, in the midst of Master's Degree in
> Distributed Systems - oh yikes, all the knowledge beyond IIS and microsoft
> web servers.  
>
> Look pal, I am not sure this is a way to prove that you are some kind of
> brilliant computer scientist, but probably believing that everyone is
> incompetent and not knowledgeable because you have had some sort of success
> in your area of expertise, probably doesn't make you look so brilliant
> outside of your circle of friends ... especially when responding to posts in
> the manner below:
>
> WANG WROTE:  "I think you need to learn more about how stuff actually works
> before assuming you are qualified to do what you want "  
>
> What stuff might that be?  your interpretation that I absolutely could not
> have, on three successive attempts, somehow gotten a default configuration
> loaded ??  Again, where did I assume I was qualified, seems to me, I was
> begging for mercy and assistance...
>
> Your reply is contradictory and generally nothing more than gibberish, at
> least you replied, that's gotta be worth something to show yourself how great
> you are.
>
> Thanks,
>
> Karl
>
>
>
> "David Wang" wrote:
> > On Apr 14, 9:33 am, karleldrid***@gmail.com wrote:
> > > On Apr 14, 12:19 pm, karleldrid***@gmail.com wrote:
>
> > > > Can someone help me or explain to me how to configure IIS so users to
> > > > login to my website using standard Visual Studio 2008 Login / Login
> > > > View Controls?
>
> > > > Here is the scenerio:
>
> > > > INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> > > > weeks.)
>
> > > > LOADED VISUAL STUDIO 2008 PROFESSIONAL.
>
> > > > (MS SQL SERVER 2005 EXPRESS)
>
> > > > INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
>
> > > > WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
>
> > > > CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> > > > SELECTED (except Dynamic Content))
>
> > > > CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
>
> > > > I HAVE NO ISSUES LOGGING IN usinghttp://localhost
>
> > > > I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> > > > TO MY STATIC HOME IP ADDRESS.
>
> > > > I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> > > > in my browswer.
>
> > > > BUT, I keep getting the error listed below when I attempt to login:
>
> > > > Server Error in '/' Application.
> > > > ---------------------------------------------------------------------------­­­-----
>
> > > > User does not have permission to perform this action.
> > > > 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: User does not
> > > > have permission to perform this action.
>
> > > > 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): User does not have permission to perform
> > > > this action.]
> > > >    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > exception, Boolean breakConnection) +4846887
> > > >    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> > > > (TdsParserStateObject stateObj) +194
> > > >    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > > > SqlCommand cmdHandler, SqlDataReader dataStream,
> > > > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> > > > stateObj) +2392
> > > >    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> > > > (Boolean enlistOK) +35
> > > >    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> > > > (ServerInfo serverInfo, String newPassword, Boolean
> > > > ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> > > > +144
> > > >    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> > > > (String host, String newPassword, Boolean redirectedUserInstance,
> > > > SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > Int64 timerStart) +342
> > > >    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> > > > (SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > String newPassword, Boolean redirectedUserInstance) +221
> > > >    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> > > > (DbConnectionPoolIdentity identity, SqlConnectionString
> > > > connectionOptions, Object providerInfo, String newPassword,
> > > > SqlConnection owningObject, Boolean redirectedUserInstance) +189
> > > >    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> > > > (DbConnectionOptions options, Object poolGroupProviderInfo,
> > > > DbConnectionPool pool, DbConnection owningConnection) +4861315
> > > >    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> > > > (DbConnection owningConnection, DbConnectionPool pool,
> > > > DbConnectionOptions options) +31
> > > >    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> > > > owningObject) +433
> > > >    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> > > > (DbConnection owningObject) +66
> > > >    System.Data.ProviderBase.DbConnectionPool.GetConnection
> > > > (DbConnection owningObject) +499
> > > >    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> > > > (DbConnection owningConnection) +65
> > > >    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> > > > (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> > > > +117
> > > >    System.Data.SqlClient.SqlConnection.Open() +122
> > > >    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> > > > Boolean revertImpersonate) +87
> > > >    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> > > > connectionString, Boolean revertImpersonation) +221
> > > >    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> > > > (String username, Boolean updateLastLoginActivityDate, Int32& status,
> > > > String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> > > > failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> > > > Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> > > > lastActivityDate) +815
> > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
> > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > Boolean failIfNotApproved) +42
> > > >    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> > > > username, String password) +78
> > > >    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> > > > (AuthenticateEventArgs e) +60
> > > >    System.Web.UI.WebControls.Login.OnAuthenticate
> > > > (AuthenticateEventArgs e) +119
> > > >    System.Web.UI.WebControls.Login.AttemptLogin() +115
> > > >    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> > > > EventArgs e) +101
> > > >    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> > > > args) +37
> > > >    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -

"David Wang" wrote:

> The reason I said what I said is because you chose to write in ALL
> CAPS to imply frustration with the difficulty of configuring what you
> want.
>
> From my observations in general, that attitude results from either:
> 1. Begging for mercy or assistance, accepting that the difficult is a
> present lack of knowledge
> 2. Assuming one knows more than they do and blame difficulty on anyone/
> anything else
>
> I did not see signs of #1 in your original question. And your use of
> vulgarity and general slander basically confirms my original
> assessment and discredits yourself. I do not have anything to prove.
>
> My original statements completely apply --
> 1. If you look at the top of the stack, it says that the SQL Client
> lacks permission to perform the action.
> 2. Instead of guessing "lacking permissions to what folder?" and start
> reinstalling software, you should look further down to stack to see
> that the exception happened when the ASP.Net Login control was trying
> to check username/password and was trying to do a Connect to SQL,
> presumably to query if the username/password matches. This tells you
> that this is not a matter of missing permissions to folders because it
> is not even involved in the stack. The issue is that the user identity
> trying to open the connection to SQL does not have privileges to do
> so. And since the exception is a SQL Exception, you know the rejection
> is from the SQL side of things and not from .Net's Code Access
> Security refusing managed code to access to external resources like
> SQL.
> 3. Given everything that the stack says in #2, your issue boils down
> to WHAT user identity is executing the ASP.Net Login control, and WHAT
> permissions are in SQL for the users that can connect and query any of
> its tables.
>
> By default, ASP.Net code executes using the process identity, unless
> you have an <impersonation> attribute. Windows Server 2008 runs IIS7
> and the application should default to Network Service (but that is
> configurable). This should be enough information to clarify the first
> part of #3. Using SQL Server Management Studio, you should be able to
> check what user identities are allowed login rights.
>
> In this conversation, I do not believe I have made a logic error, nor
> have I lied/misled you, but sorry, I am not empathic enough to sugar
> coat my observations to help you handle reality. All of the
> information is in the stack trace.
>
> Have fun completing your Masters Degree - I am always supportive of
> furthering education. I would caution that there is a huge difference
> between knowing distributed systems and actual experience assembling/
> working with one. These "Microsoft complexities" exist in various
> forms in any system you may use, including ones you build yourself.
> All the knowledge about designing/building systems is useless if you
> cannot take an error/obstacle and overcome it, and unfortunately, I do
> not believe schools ever teach nor emphasize it.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>
>
>
> On Apr 20, 10:38 pm, keldridge <keldri***@discussions.microsoft.com>
> wrote:
> > Hello David -
> >
> > Thank you for your response, I think. 
> >
> > Why the rude tone telling me the reams of exceptions that I received was
> > clearly telling me that "The user account running your web app on the web
> > server needs to have permissions to log in to the SQL database. The stack
> > trace tells you this, and the corrective action should be clear." Where in
> > the stack trace is this "CLEAR"?
> >
> > Why take a slippery slope approach telling me that I must have misconfigured
> > something, yet you refer to my original post stating clearly that I reloaded
> > my whole system (could it be that I already went down your 'clearly'
> > thoughtful path and considered that I might have misconfigured something? and
> > wanted to ensure a DEFAULT CONFIGURATION?) and why on the  first 3 attempts
> > did the default configuration not work as you so brilliantly suggest that it
> > should?
> >
> >  WANG WROTE: "Usually, the default configuration already provides access to
> > those identities, so you must be doing something non-default -- at which
> > point you are completely responsible forknowing how things work because you
> > are customizing."
> >
> > Slippery slope = USUALLY + MUST BE DOING SOMETHING WRONG + CUSTOMIZING
> >
> > Usually??? Does this mean three out of four times a user reloads a sytem in
> > a default configuration? Could you give me hint as to when a user might
> > expect it not to be the usual case - does microsoft have some secret squirrel
> > formula for calculating when a default configuration will load in a
> > non-default manner...Customizing what??  I RELOADED MY SYSTEM THREE TIMES TO
> > BASE LINE IT TO A DEFAULT CONFIGURATION ... AH YES, YOU CAN INTERPRET THE
> > STACK TRACE, BUT YOU COULDN'T READ THAT I RELOADED (BASE-LINED TO A DEFAULT
> > CONFIGURATION)?   WHY ASS_U - NOT ME? OOOPs... I mean, WHY ASSUME?
> >
> > Where did I say I was qualified, compentent or beyond learning or even able
> > to keep up with the crazy, crazy service packs, updates, tweaks and changes
> > that occur at Microsoft every few hours?  You know everything? AMAZING! I
> > knew I was beaten by my lack of knowledge and that's why I asked the
> > question...I had hoped someone might have actually answered the question
> > rather than tell me I should become an expert before asking a
> > question...think about it ... knowledgeable or not, I clearly stated in my
> > rambling post that I had literally spent 3 days without sleep trying to get
> > this problem resolved...oh!  you probably weren't able to decipher that in
> > all the ramblings, much in the same way I was not able to decipher the
> > rambling stack trace after 3 days without sleep!
> >
> > Truth be known, I am learning, in the midst of Master's Degree in
> > Distributed Systems - oh yikes, all the knowledge beyond IIS and microsoft
> > web servers. 
> >
> > Look pal, I am not sure this is a way to prove that you are some kind of
> > brilliant computer scientist, but probably believing that everyone is
> > incompetent and not knowledgeable because you have had some sort of success
> > in your area of expertise, probably doesn't make you look so brilliant
> > outside of your circle of friends ... especially when responding to posts in
> > the manner below:
> >
> > WANG WROTE:  "I think you need to learn more about how stuff actually works
> > before assuming you are qualified to do what you want " 
> >
> > What stuff might that be?  your interpretation that I absolutely could not
> > have, on three successive attempts, somehow gotten a default configuration
> > loaded ??  Again, where did I assume I was qualified, seems to me, I was
> > begging for mercy and assistance...
> >
> > Your reply is contradictory and generally nothing more than gibberish, at
> > least you replied, that's gotta be worth something to show yourself how great
> > you are.
> >
> > Thanks,
> >
> > Karl
> >
> >
> >
> > "David Wang" wrote:
> > > On Apr 14, 9:33 am, karleldrid***@gmail.com wrote:
> > > > On Apr 14, 12:19 pm, karleldrid***@gmail.com wrote:
> >
> > > > > Can someone help me or explain to me how to configure IIS so users to
> > > > > login to my website using standard Visual Studio 2008 Login / Login
> > > > > View Controls?
> >
> > > > > Here is the scenerio:
> >
> > > > > INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> > > > > weeks.)
> >
> > > > > LOADED VISUAL STUDIO 2008 PROFESSIONAL.
> >
> > > > > (MS SQL SERVER 2005 EXPRESS)
> >
> > > > > INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
> >
> > > > > WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
> >
> > > > > CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> > > > > SELECTED (except Dynamic Content))
> >
> > > > > CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
> >
> > > > > I HAVE NO ISSUES LOGGING IN usinghttp://localhost
> >
> > > > > I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> > > > > TO MY STATIC HOME IP ADDRESS.
> >
> > > > > I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> > > > > in my browswer.
> >
> > > > > BUT, I keep getting the error listed below when I attempt to login:
> >
> > > > > Server Error in '/' Application.
> > > > > ---------------------------------------------------------------------------­­­-----
> >
> > > > > User does not have permission to perform this action.
> > > > > 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: User does not
> > > > > have permission to perform this action.
> >
> > > > > 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): User does not have permission to perform
> > > > > this action.]
> > > > >    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > > exception, Boolean breakConnection) +4846887
> > > > >    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> > > > > (TdsParserStateObject stateObj) +194
> > > > >    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > > > > SqlCommand cmdHandler, SqlDataReader dataStream,
> > > > > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> > > > > stateObj) +2392
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> > > > > (Boolean enlistOK) +35
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> > > > > (ServerInfo serverInfo, String newPassword, Boolean
> > > > > ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> > > > > +144
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> > > > > (String host, String newPassword, Boolean redirectedUserInstance,
> > > > > SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > > Int64 timerStart) +342
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> > > > > (SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > > String newPassword, Boolean redirectedUserInstance) +221
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> > > > > (DbConnectionPoolIdentity identity, SqlConnectionString
> > > > > connectionOptions, Object providerInfo, String newPassword,
> > > > > SqlConnection owningObject, Boolean redirectedUserInstance) +189
> > > > >    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> > > > > (DbConnectionOptions options, Object poolGroupProviderInfo,
> > > > > DbConnectionPool pool, DbConnection owningConnection) +4861315
> > > > >    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> > > > > (DbConnection owningConnection, DbConnectionPool pool,
> > > > > DbConnectionOptions options) +31
> > > > >    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> > > > > owningObject) +433
> > > > >    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> > > > > (DbConnection owningObject) +66
> > > > >    System.Data.ProviderBase.DbConnectionPool.GetConnection
> > > > > (DbConnection owningObject) +499
> > > > >    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> > > > > (DbConnection owningConnection) +65
> > > > >    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> > > > > (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> > > > > +117
> > > > >    System.Data.SqlClient.SqlConnection.Open() +122
> > > > >    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> > > > > Boolean revertImpersonate) +87
> > > > >    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> > > > > connectionString, Boolean revertImpersonation) +221
> > > > >    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> > > > > (String username, Boolean updateLastLoginActivityDate, Int32& status,
> > > > > String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> > > > > failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> > > > > Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> > > > > lastActivityDate) +815
> > > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > > Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
> > > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > > Boolean failIfNotApproved) +42
> > > > >    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> > > > > username, String password) +78
> > > > >    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> > > > > (AuthenticateEventArgs e) +60
> > > > >    System.Web.UI.WebControls.Login.OnAuthenticate
> > > > > (AuthenticateEventArgs e) +119
> > > > >    System.Web.UI.WebControls.Login.AttemptLogin() +115
> > > > >    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> > > > > EventArgs e) +101
> > > > >    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> > > > > args) +37
> > > > >    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
> >
> > ...
> >
> > read more »- Hide quoted text -
> >
> > - Show quoted text -
>
>

"David Wang" wrote:

> The reason I said what I said is because you chose to write in ALL
> CAPS to imply frustration with the difficulty of configuring what you
> want.
>
> From my observations in general, that attitude results from either:
> 1. Begging for mercy or assistance, accepting that the difficult is a
> present lack of knowledge
> 2. Assuming one knows more than they do and blame difficulty on anyone/
> anything else
>
> I did not see signs of #1 in your original question. And your use of
> vulgarity and general slander basically confirms my original
> assessment and discredits yourself. I do not have anything to prove.
>
> My original statements completely apply --
> 1. If you look at the top of the stack, it says that the SQL Client
> lacks permission to perform the action.
> 2. Instead of guessing "lacking permissions to what folder?" and start
> reinstalling software, you should look further down to stack to see
> that the exception happened when the ASP.Net Login control was trying
> to check username/password and was trying to do a Connect to SQL,
> presumably to query if the username/password matches. This tells you
> that this is not a matter of missing permissions to folders because it
> is not even involved in the stack. The issue is that the user identity
> trying to open the connection to SQL does not have privileges to do
> so. And since the exception is a SQL Exception, you know the rejection
> is from the SQL side of things and not from .Net's Code Access
> Security refusing managed code to access to external resources like
> SQL.
> 3. Given everything that the stack says in #2, your issue boils down
> to WHAT user identity is executing the ASP.Net Login control, and WHAT
> permissions are in SQL for the users that can connect and query any of
> its tables.
>
> By default, ASP.Net code executes using the process identity, unless
> you have an <impersonation> attribute. Windows Server 2008 runs IIS7
> and the application should default to Network Service (but that is
> configurable). This should be enough information to clarify the first
> part of #3. Using SQL Server Management Studio, you should be able to
> check what user identities are allowed login rights.
>
> In this conversation, I do not believe I have made a logic error, nor
> have I lied/misled you, but sorry, I am not empathic enough to sugar
> coat my observations to help you handle reality. All of the
> information is in the stack trace.
>
> Have fun completing your Masters Degree - I am always supportive of
> furthering education. I would caution that there is a huge difference
> between knowing distributed systems and actual experience assembling/
> working with one. These "Microsoft complexities" exist in various
> forms in any system you may use, including ones you build yourself.
> All the knowledge about designing/building systems is useless if you
> cannot take an error/obstacle and overcome it, and unfortunately, I do
> not believe schools ever teach nor emphasize it.
>
>
> //David
> http://w3-4u.blogspot.com
> http://blogs.msdn.com/David.Wang
> //
>
>
>
>
> On Apr 20, 10:38 pm, keldridge <keldri***@discussions.microsoft.com>
> wrote:
> > Hello David -
> >
> > Thank you for your response, I think. 
> >
> > Why the rude tone telling me the reams of exceptions that I received was
> > clearly telling me that "The user account running your web app on the web
> > server needs to have permissions to log in to the SQL database. The stack
> > trace tells you this, and the corrective action should be clear." Where in
> > the stack trace is this "CLEAR"?
> >
> > Why take a slippery slope approach telling me that I must have misconfigured
> > something, yet you refer to my original post stating clearly that I reloaded
> > my whole system (could it be that I already went down your 'clearly'
> > thoughtful path and considered that I might have misconfigured something? and
> > wanted to ensure a DEFAULT CONFIGURATION?) and why on the  first 3 attempts
> > did the default configuration not work as you so brilliantly suggest that it
> > should?
> >
> >  WANG WROTE: "Usually, the default configuration already provides access to
> > those identities, so you must be doing something non-default -- at which
> > point you are completely responsible forknowing how things work because you
> > are customizing."
> >
> > Slippery slope = USUALLY + MUST BE DOING SOMETHING WRONG + CUSTOMIZING
> >
> > Usually??? Does this mean three out of four times a user reloads a sytem in
> > a default configuration? Could you give me hint as to when a user might
> > expect it not to be the usual case - does microsoft have some secret squirrel
> > formula for calculating when a default configuration will load in a
> > non-default manner...Customizing what??  I RELOADED MY SYSTEM THREE TIMES TO
> > BASE LINE IT TO A DEFAULT CONFIGURATION ... AH YES, YOU CAN INTERPRET THE
> > STACK TRACE, BUT YOU COULDN'T READ THAT I RELOADED (BASE-LINED TO A DEFAULT
> > CONFIGURATION)?   WHY ASS_U - NOT ME? OOOPs... I mean, WHY ASSUME?
> >
> > Where did I say I was qualified, compentent or beyond learning or even able
> > to keep up with the crazy, crazy service packs, updates, tweaks and changes
> > that occur at Microsoft every few hours?  You know everything? AMAZING! I
> > knew I was beaten by my lack of knowledge and that's why I asked the
> > question...I had hoped someone might have actually answered the question
> > rather than tell me I should become an expert before asking a
> > question...think about it ... knowledgeable or not, I clearly stated in my
> > rambling post that I had literally spent 3 days without sleep trying to get
> > this problem resolved...oh!  you probably weren't able to decipher that in
> > all the ramblings, much in the same way I was not able to decipher the
> > rambling stack trace after 3 days without sleep!
> >
> > Truth be known, I am learning, in the midst of Master's Degree in
> > Distributed Systems - oh yikes, all the knowledge beyond IIS and microsoft
> > web servers. 
> >
> > Look pal, I am not sure this is a way to prove that you are some kind of
> > brilliant computer scientist, but probably believing that everyone is
> > incompetent and not knowledgeable because you have had some sort of success
> > in your area of expertise, probably doesn't make you look so brilliant
> > outside of your circle of friends ... especially when responding to posts in
> > the manner below:
> >
> > WANG WROTE:  "I think you need to learn more about how stuff actually works
> > before assuming you are qualified to do what you want " 
> >
> > What stuff might that be?  your interpretation that I absolutely could not
> > have, on three successive attempts, somehow gotten a default configuration
> > loaded ??  Again, where did I assume I was qualified, seems to me, I was
> > begging for mercy and assistance...
> >
> > Your reply is contradictory and generally nothing more than gibberish, at
> > least you replied, that's gotta be worth something to show yourself how great
> > you are.
> >
> > Thanks,
> >
> > Karl
> >
> >
> >
> > "David Wang" wrote:
> > > On Apr 14, 9:33 am, karleldrid***@gmail.com wrote:
> > > > On Apr 14, 12:19 pm, karleldrid***@gmail.com wrote:
> >
> > > > > Can someone help me or explain to me how to configure IIS so users to
> > > > > login to my website using standard Visual Studio 2008 Login / Login
> > > > > View Controls?
> >
> > > > > Here is the scenerio:
> >
> > > > > INSTALLED WINDOWS SERVER STANDARD 2008 (about 3 times in the last two
> > > > > weeks.)
> >
> > > > > LOADED VISUAL STUDIO 2008 PROFESSIONAL.
> >
> > > > > (MS SQL SERVER 2005 EXPRESS)
> >
> > > > > INSTALLED ALL SERVICE PACKS (.NET 3.5 Framework)
> >
> > > > > WROTE A SIMPLE LITTLE WEB APP TO LOGIN.
> >
> > > > > CONFIGURED THE IIS 7 FEATURES AND WEBSERVER ROLL (WITH ALL FEATURES
> > > > > SELECTED (except Dynamic Content))
> >
> > > > > CONFIGURED THE ASPNETDB.MDF FROM the ASP.NET CONFIGURATION TAB
> >
> > > > > I HAVE NO ISSUES LOGGING IN usinghttp://localhost
> >
> > > > > I PUBLISH TO MY WEB SERVER (C:\INETPUB\WWWROOT\)  <-- THE DNS POINTS
> > > > > TO MY STATIC HOME IP ADDRESS.
> >
> > > > > I CAN EVEN SEE MY WEB APPLICATION BY TYPINGhttp://boebot.karleldridge.com
> > > > > in my browswer.
> >
> > > > > BUT, I keep getting the error listed below when I attempt to login:
> >
> > > > > Server Error in '/' Application.
> > > > > ---------------------------------------------------------------------------­­­-----
> >
> > > > > User does not have permission to perform this action.
> > > > > 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: User does not
> > > > > have permission to perform this action.
> >
> > > > > 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): User does not have permission to perform
> > > > > this action.]
> > > > >    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > > > > exception, Boolean breakConnection) +4846887
> > > > >    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning
> > > > > (TdsParserStateObject stateObj) +194
> > > > >    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
> > > > > SqlCommand cmdHandler, SqlDataReader dataStream,
> > > > > BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
> > > > > stateObj) +2392
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin
> > > > > (Boolean enlistOK) +35
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin
> > > > > (ServerInfo serverInfo, String newPassword, Boolean
> > > > > ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
> > > > > +144
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover
> > > > > (String host, String newPassword, Boolean redirectedUserInstance,
> > > > > SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > > Int64 timerStart) +342
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist
> > > > > (SqlConnection owningObject, SqlConnectionString connectionOptions,
> > > > > String newPassword, Boolean redirectedUserInstance) +221
> > > > >    System.Data.SqlClient.SqlInternalConnectionTds..ctor
> > > > > (DbConnectionPoolIdentity identity, SqlConnectionString
> > > > > connectionOptions, Object providerInfo, String newPassword,
> > > > > SqlConnection owningObject, Boolean redirectedUserInstance) +189
> > > > >    System.Data.SqlClient.SqlConnectionFactory.CreateConnection
> > > > > (DbConnectionOptions options, Object poolGroupProviderInfo,
> > > > > DbConnectionPool pool, DbConnection owningConnection) +4861315
> > > > >    System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection
> > > > > (DbConnection owningConnection, DbConnectionPool pool,
> > > > > DbConnectionOptions options) +31
> > > > >    System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> > > > > owningObject) +433
> > > > >    System.Data.ProviderBase.DbConnectionPool.UserCreateRequest
> > > > > (DbConnection owningObject) +66
> > > > >    System.Data.ProviderBase.DbConnectionPool.GetConnection
> > > > > (DbConnection owningObject) +499
> > > > >    System.Data.ProviderBase.DbConnectionFactory.GetConnection
> > > > > (DbConnection owningConnection) +65
> > > > >    System.Data.ProviderBase.DbConnectionClosed.OpenConnection
> > > > > (DbConnection outerConnection, DbConnectionFactory connectionFactory)
> > > > > +117
> > > > >    System.Data.SqlClient.SqlConnection.Open() +122
> > > > >    System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context,
> > > > > Boolean revertImpersonate) +87
> > > > >    System.Web.DataAccess.SqlConnectionHelper.GetConnection(String
> > > > > connectionString, Boolean revertImpersonation) +221
> > > > >    System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat
> > > > > (String username, Boolean updateLastLoginActivityDate, Int32& status,
> > > > > String& password, Int32& passwordFormat, String& passwordSalt, Int32&
> > > > > failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount,
> > > > > Boolean& isApproved, DateTime& lastLoginDate, DateTime&
> > > > > lastActivityDate) +815
> > > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > > Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
> > > > >    System.Web.Security.SqlMembershipProvider.CheckPassword(String
> > > > > username, String password, Boolean updateLastLoginActivityDate,
> > > > > Boolean failIfNotApproved) +42
> > > > >    System.Web.Security.SqlMembershipProvider.ValidateUser(String
> > > > > username, String password) +78
> > > > >    System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider
> > > > > (AuthenticateEventArgs e) +60
> > > > >    System.Web.UI.WebControls.Login.OnAuthenticate
> > > > > (AuthenticateEventArgs e) +119
> > > > >    System.Web.UI.WebControls.Login.AttemptLogin() +115
> > > > >    System.Web.UI.WebControls.Login.OnBubbleEvent(Object source,
> > > > > EventArgs e) +101
> > > > >    System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs
> > > > > args) +37
> > > > >    System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +118
> >
> > ...
> >
> > read more »- Hide quoted text -
> >
> > - Show quoted text -
>
>