I have a custom resource which runs a SQL script on SQL server. Script runs using machine account where I run DSC, I need to run this as a different account. I dont want to use sql authentication.
Below is set function of my resource code. Right now this script runs as domain\MAchineName$ I need to run it as different user e.g domain\dvapp
) $sql = [Io.File]::ReadAllText($SqlScriptPath) $SqlConnection = New-Object System.Data.SqlClient.SqlConnection $SqlConnection.ConnectionString = $ConnectionString $SqlConnection.Open() $Command = New-Object System.Data.SQLClient.SQLCommand # Set the SqlCommand's connection to the SqlConnection object above. $Command.Connection = $SqlConnection # Set the SqlCommand's command text to the query value passed in. $Command.CommandText = $sql # Execute the command against the database without returning results (NonQuery). $Command.ExecuteNonQuery()