Hi,
We changed the service account on Octopus and in the database to use a different username. I got the Database admins to replicate the previous permissions.
The connection string via the Octopus Server config looked like this beforehand
Integrated Security=False;UID=username1;PWD=RPoole
But now it’s exposing the actual password
Integrated Security=False;UID=username1;Password=P@ssw0rd1
When I switched it back to PWD=RPoole I get this error in the eventlogs
2022-08-19 14:33:36.1562 6568 16 FATAL Unhandled AppDomain exception occurred: SQL Error 18456 - Login failed for user ‘username1’.
Microsoft.Data.SqlClient.SqlException
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
Ideally we wouldn’t want the password exposed in the server config file. Is there something I’ve missed?
Thanks
Dan