PDA

View Full Version : YAF Installation Integration


prsports
07-28-2011, 09:01 PM
Trying to install YAF so it will sync up with my current SQL membership.

On installation it asks if I want to setup a new database or use a current one.

I select current and then proceed to enter the database name, server name, my login.

I the following error:

[23:58:609]Opening SQL Connection with connection string 'data source=sql2k802.discountasp.net;initial catalog=SQL2008_627938_prsports;user id=SQL2008_627938_prsports_user;pooling=False'. The 'transacted' setting for this connection is 'False'.
[23:58:968]Executing lines 1 to 40 of the script:
EXCEPTION: Microsoft.Web.Deployment.DeploymentDetailedClientS erverException: An error occurred during execution of the database script. The error occurred between the following lines of the script: "1" and "40". The verbose log might have more information about the error. The command started with the following:
"/*************************************************"
The login already has an account under a different user name.
User or role 'SQL2008_627938_prsports_user' does not exist in this database.
-- Creating user
-- Adding user http://go.microsoft.com/fwlink/?LinkId=178587 ---> System.Data.SqlClient.SqlException: The login already has an account under a different user name.
User or role 'SQL2008_627938_prsports_user' does not exist in this database.
-- Creating user
-- Adding user
at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Web.Deployment.DBStatementInfo.Execute(D bConnection connection, DbTransaction transaction, DeploymentBaseContext baseContext, Int32 timeout)
--- End of inner exception stack trace ---
at Microsoft.Web.Deployment.DBStatementInfo.Execute(D bConnection connection, DbTransaction transaction, DeploymentBaseContext baseContext, Int32 timeout)
at Microsoft.Web.Deployment.DBConnectionWrapper.Execu teSql(DBStatementInfo sqlStatement, DeploymentBaseContext baseContext, Int32 timeout)
at Microsoft.Web.Deployment.SqlScriptToDBProvider.Add Helper(DeploymentObject source, Boolean whatIf)
at Microsoft.Web.Deployment.SqlScriptToDBProvider.Add (DeploymentObject source, Boolean whatIf)
at Microsoft.Web.Deployment.DeploymentObject.AddChild (DeploymentObject source, Int32 position, DeploymentSyncContext syncContext)
at Microsoft.Web.Deployment.DeploymentSyncContext.Han dleAddChild(DeploymentObject destParent, DeploymentObject sourceObject, Int32 position)
at Microsoft.Web.Deployment.DeploymentSyncContext.Syn cChildrenOrder(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.Syn cChildren(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.Syn cChildrenOrder(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.Syn cChildren(DeploymentObject dest, DeploymentObject source)
at Microsoft.Web.Deployment.DeploymentSyncContext.Pro cessSync(DeploymentObject destinationObject, DeploymentObject sourceObject)
at Microsoft.Web.Deployment.DeploymentObject.SyncToIn ternal(DeploymentObject destObject, DeploymentSyncOptions syncOptions, PayloadTable payloadTable, ContentRootTable contentRootTable)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(D eploymentProviderOptions providerOptions, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(S tring provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(D eploymentWellKnownProvider provider, String path, DeploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.Deployment.DeploymentObject.SyncTo(D eploymentBaseOptions baseOptions, DeploymentSyncOptions syncOptions)
at Microsoft.Web.PlatformInstaller.MSDeployProxy.Inst all(InstallerContext context, RemoteCredentials remoteCredentials)



Any help?