Anyone knows how to use aspnetdb? I just populate time tracker starter database, but some tables have the foreign key in the aspnetdb. How can i solve the problem?
1) in VWD create a new Web Site and point it directly to your IIS local web server call it TimeTracker e.g.
http://localhost/TimeTracker (since I have problem getting VWD web server to work using the Beta release) this step will create a web site on your local IIS, you can do this manually too.
2) Unzip the file downloaded into the C:\Inetpub\wwwroot\TimeTracker and overwrite any files there.
3) Launch the site in IE e.g.
http://localhost/TimeTracker/Default.aspx
Check in web.config for connectionString, configure it according to your server name, password etc.
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB.
If thsi helpful to you please mark it as answer, So it will help for other people
Server Error in '/wwwroot' Application. -------------------------------------------------------------------------------- Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.
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: Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.
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):
Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString
connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection
owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +494 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.SessionState.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo) +79 [HttpException (0x80004005): Unable to connect to SQL Server session database.] System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection
conn, Exception e) +227 System.Web.SessionState.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo) +349 System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling) +285 System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext
context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) +178 System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +476 System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs
eventArgs) +130 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 --------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
replay me immediate friend is urgent requirement...
Jessmmy
Member
341 Points
164 Posts
how to use aspnetdb
Jun 14, 2006 05:48 AM|LINK
Hi
Anyone knows how to use aspnetdb? I just populate time tracker starter database, but some tables have the foreign key in the aspnetdb. How can i solve the problem?
thx
Jessmmy
Member
341 Points
164 Posts
Re: how to use aspnetdb
Jul 03, 2006 04:29 AM|LINK
Does anyone help me out?
And where can I find the full steps to setup the time tracker starter kit?
thx
Tryst
Participant
915 Points
364 Posts
Re: how to use aspnetdb
Jul 12, 2006 01:24 PM|LINK
I fail to believe that there are no instructions what so-ever on how to properly set up the Time Tracker application.
Tryst
jeff@zina.co...
All-Star
87677 Points
11637 Posts
Moderator
Re: how to use aspnetdb
Jul 14, 2006 03:13 AM|LINK
Might start here:
http://forums.asp.net/thread/1128178.aspx
Jeff
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: how to use aspnetdb
Apr 28, 2007 04:24 AM|LINK
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
shijobaby@ya...
Member
14 Points
20 Posts
Re: how to use aspnetdb
Jul 20, 2009 02:08 PM|LINK
Hi If you are looking for the detailed explanation
for how to create asp.net membership provider database default name
is aspnetdb. Look at this articles
http://programming.top54u.com/post/How-to-Create-Aspnetdb.aspx
http://aspnetmembershipprovider.blogspot.com/2008/04/aspnetdbmdf.html
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: how to use aspnetdb
Jul 21, 2009 02:53 AM|LINK
Inofrmation about setting up TTS
1) in VWD create a new Web Site and point it directly to your IIS local web server call it TimeTracker e.g. http://localhost/TimeTracker (since I have problem getting VWD web server to work using the Beta release) this step will create a web site on your local IIS, you can do this manually too.
2) Unzip the file downloaded into the C:\Inetpub\wwwroot\TimeTracker and overwrite any files there.
3) Launch the site in IE e.g. http://localhost/TimeTracker/Default.aspx
Check in web.config for connectionString, configure it according to your server name, password etc.
In Time Tracking System, it uses inbuild Membership classes for user creation, updation etc..
You have to register your DB with ASP.NET Membership classes by executing the command line utility in VS prompt
aspnet_regsql, it will open one window, where you have to configure DB.
If thsi helpful to you please mark it as answer, So it will help for other people
Hope it will help you, let me know.
http://forums.asp.net/p/941943/1128558.aspx
http://forums.asp.net/t/1373129.aspx
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: how to use aspnetdb
Jul 24, 2009 03:07 AM|LINK
Update the thread status
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
chetan.sarod...
All-Star
65839 Points
11163 Posts
Re: how to use aspnetdb
Aug 19, 2009 03:00 AM|LINK
Are you able to use it now
Senior Software Engineer,
Approva Systems Pvt Ltd, Pune, India.
vijayasimman
Member
12 Points
10 Posts
Cannot open database "ASPState" requested by the login. The login failed. Login failed for user '...
Jan 07, 2010 10:10 AM|LINK
Server Error in '/wwwroot' Application. -------------------------------------------------------------------------------- Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.
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: Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.
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): Cannot open database "ASPState" requested by the login. The login failed. Login failed for user 'VISUALSTUDIO\Studio'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +172 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +381 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 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.SessionState.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo) +79 [HttpException (0x80004005): Unable to connect to SQL Server session database.] System.Web.SessionState.SqlSessionStateStore.ThrowSqlConnectionException(SqlConnection conn, Exception e) +227 System.Web.SessionState.SqlStateConnection..ctor(SqlPartitionInfo sqlPartitionInfo) +349 System.Web.SessionState.SqlSessionStateStore.GetConnection(String id, Boolean& usePooling) +285 System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) +178 System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +476 System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +130 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
replay me immediate friend is urgent requirement...