7 FATAL Unhandled AppDomain exception occurred: Login failed for user

We are having an issue with the OctopusDeploy service. It runs for about 3 seconds then stops. Here is the error message we are getting:

2018-06-19 10:57:45.9311 7 FATAL Unhandled AppDomain exception occurred: Login failed for user ‘Domainname\computername$’.
System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘domainname\computeraccount$’.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler,

I have verified that we are allowing Azure access outbound. Can someone please assist us with the issue?

Hi Josh,

Thanks for getting in touch! It looks like the account you are running the Octopus server service with is having trouble authenticating with the SQL server where the Octopus Database is.

System.Data.SqlClient.SqlException (0x80131904): Login failed for user ‘domainname\computeraccount$’.

We have a page in our documentation which covers the permissions required by the Octopus service account. Would you be able to confirm that your Domainname\computername$ account has the permissions/access outlined in the linked page?

By the looks of it, this error is most likely related to an issue with the db_owner permission.

Let me know if this helps. If this does not fix your problem, please attach a full server log for the Octopus server. This can be found under C:\Octopus\Logs in a default installation.

Looking forward to hearing from you. :slight_smile:

Best regards,
Daniel

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.