Problem with a SQL Server Proxy account

• drnicolas

  SSC Veteran

  Points: 219

  More actions

  January 24, 2023 at 3:06 pm

  #4141291

  I am using an Application which  accesses certain registry hives.

  the application runs fine as long as I am logged in with a specific user (which was made especially for this purpose)

  Now the task is, to run this appliation unattended via sql server agent or from SSIS.

  To do this , I set up a Proxy account and the Package runs fine  started from SQL server agent as long as the specific user is logged in.

  But only then!  I can close the RDP-Session without logging of and it stll runs fine.

  But, say after a restart of the SQL-Server then it fails.

  I get a message from my application which says taht there is a configuration problem. And it seems that teh registry hive is empty (no error message about access violation).

  Is there something I have to take into account  while using the Proxy account?

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 25, 2023 at 3:10 pm

  #4141694

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• February 6, 2023 at 11:51 am

  This was removed by the editor as SPAM