Post reply

Use the same execution account for SSAS and SQL DB 2012

  • August 15, 2014 at 1:18 pm

    #289164

    Hello,

    When I installed my SQL 2012 instance I was asked to choose a service account for SSAS, SSIS, DB, and SSRS, Is there a way to change the service accounts once SQL is installed?

    Thank you!

    SQL-TG

    The are no problems, only solutions. --John Lennon

  • August 19, 2014 at 9:47 am

    #1739278

    Ok, figured it out....

    You have to go to the data sources and reconfigure the security options. Inherit, Impersonate User, etc did not work, but when I typed in my full windows credentials it worked. I figure Impersonate Current User would be the same as actually typing in the same username and password but it is not. Weird.

    The are no problems, only solutions. --John Lennon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply