As a developer I would like to be able to deploy to a database using integrated security.
We use a service account to deploy changes. I would like to be able to use integrated security of the tentacle service account.
Anonymous
shared this idea
Marking as completed since SQL Release already supports this. However if the original poster of this comment meant something other than what Peter has described then please do let us know.
-
Peter Gerrard
commented
SQL Release already supports the use of windows authentication for connecting to a database. To use windows authentication either:
1 - Pass in a connection string with 'Integrated Security=True' (eg "Integrated Security=true;Initial Catalog=Northwind;server=(local)")
or
2 - Pass in a database connection object created by New-DatabaseConnection without setting the username and password (eg New-DatabaseConnection -ServerInstance (server) -Database Northwind)If you mean a different type of authentication, please let us know.