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.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved