Re: IIS Web Server 2008

On Apr 14, 12:19 pm, karleldrid...@xxxxxxxxx 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??
.