SQL authentication

(M RaoPulugujju) #1

SQL authentication change to AD service account

Data Source=LISTENER;Initial Catalog=OctopusDB;Integrated Security=False;User ID=sa;Password=xxxxxx

I would like to change the SQL authentication to Active Directory service account authentication.
I have update the above connection string with Integrated Security=True, but it giving errors.

please help me change the SQL connection string to AD authentication.

(Dalmiro Grañas) #3

Hi @mastanrao.pulugujju,

Thanks for reaching out! Could you show me where (in which config file) are you trying to make this change?

Instead of putting the User/Pass in raw text in a config file, I’d recommend you to set Integrated Security to True and then change the user that runs the Octopus Server Service to use this AD account. This should also work and your credentials wont be sitting in raw text on your server :slight_smile:

Let me know if that helps,
Dalmiro