locked
Merging databases in Classified Starter kit RRS feed

  • Question

  • User1221255619 posted

    Hi.

    I have the Classified Starter Kit running successfully on my PC.

    I have a hosting account with GoDaddy, and only one database available.

    The Classified Project uses two.

    I created scripts for each database and rran both scripts on my remote database. The result is one database containing all the tables.

    However, when I run the site remotely, I get an error, presumably because even though I know I merged the two databases, the project doesn't!

    The error error I get when I run the project is pasted below. I know this is something to do with how the project uses Membership. Is there a way to successfully allow the project to use just one database?

    All ideas, suggestions & pointers gratefully accepted.

    Thanks in advance.

    Garrett

     

    here's the error...

     

    Line 7:      {
    Line 8:         
    Line 9:          if (!Roles.RoleExists("Administrators")) Roles.CreateRole("Administrators");
    Line 10:         if (!Roles.RoleExists("Guests")) Roles.CreateRole("Guests");
    Line 11:

     

    [SqlException (0x80131904): Login failed for user 'xxxxxxxx'.]
       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.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84
       System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197
       System.Web.Security.SqlRoleProvider.RoleExists(String roleName) +482
       System.Web.Security.Roles.RoleExists(String roleName) +242
       ASP.global_asax.Application_Start(Object sender, EventArgs e) in d:\hosting\xxxxxx\yyyyyy\Global.asax:9

    Saturday, May 9, 2009 12:13 PM

All replies

  • User1221255619 posted

    Oops,

    silly mistake,

    my connection string was wrong.

    Everything works now.

    Garrett

    Saturday, May 9, 2009 3:07 PM