YAFLogo

dprus
  • dprus
  • 57.2% (Neutral)
  • YAF Camper Topic Starter
2014-06-22T17:54:36Z
For the past few days I've been testing out YAF on a VM and it's been working well (I've hit a few minor issues here and there but we think it will work well in our environment nonetheless).

Today I started migrating the db to our internal cluster and redundant SQL server. Now I'm hitting a strange issue.

When I start the install process I click "Test Database Connection" and it's all green ("Connection Succeeded"). Then, on the "Initialize Database" page I click "Next" and I get an exception:

Quote:

Login failed for user 'S-1-9-3-667777270-1154951469-3199456156-3565352592.'.

A severe error occurred on the current command. The results, if any, should be discarded.

The username it's displaying is nothing like the actual username I specified in the db.config file.

Does anyone know what the issue is here?

Sponsor
dprus
  • dprus
  • 57.2% (Neutral)
  • YAF Camper Topic Starter
2014-06-22T20:46:38Z
Here's a relevant part of the exception stack:

Quote:

[SqlException (0x80131904): Login failed for user 'S-1-9-3-667777270-1154951469-3199456156-3565352592.'.

A severe error occurred on the current command. The results, if any, should be discarded.]

System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866

System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418

System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244

System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691

System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +69

System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest) +799

System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) +564

System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransaction(TransactionRequest transactionRequest, String name, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest) +137

System.Data.SqlClient.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) +254

System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) +147

System.Data.SqlClient.SqlConnection.BeginTransaction() +9

YAF.Classes.Data.LegacyDb.system_initialize_fixaccess(Boolean grant) +64

YAF.Core.Services.InstallUpgradeService.UpgradeDatabase(Boolean fullText, Boolean upgradeExtensions) +51

YAF.Install._default.Wizard_NextButtonClick(Object sender, WizardNavigationEventArgs e) +1307

dprus
  • dprus
  • 57.2% (Neutral)
  • YAF Camper Topic Starter
2014-06-22T20:59:17Z
OK, I managed to find a solution but I have no idea what the implications are or why I need to do this. If I add ";Pooling=false" to the end of the connection string everything works perfectly.