locked
how to use aspnetdb RRS feed

  • Question

  • User-2087761027 posted

    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

     

    Wednesday, June 14, 2006 1:48 AM

All replies

  • User-2087761027 posted

    Does anyone help me out?

    And where can I find the full steps to setup the time tracker starter kit?

    thx

    Monday, July 3, 2006 12:29 AM
  • User726070706 posted
    I second this.

    I fail to believe that there are no instructions what so-ever on how to properly set up the Time Tracker application.

    Tryst
    Wednesday, July 12, 2006 9:24 AM
  • User-1853252149 posted

    Might start here:

    http://forums.asp.net/thread/1128178.aspx

    Jeff

    Thursday, July 13, 2006 11:13 PM
  • User555306248 posted
    Good link for starters...
    Saturday, April 28, 2007 12:24 AM
  • User-1670366941 posted

    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

    Monday, July 20, 2009 10:08 AM
  • User555306248 posted

    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

    Monday, July 20, 2009 10:53 PM
  • User555306248 posted

     Update the thread status

    Thursday, July 23, 2009 11:07 PM
  • User555306248 posted

     Are you able to use it now

    Tuesday, August 18, 2009 11:00 PM
  • User-1630252454 posted

    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

    Thursday, January 7, 2010 6:10 AM