Post reply

Changing the password for the reporting service user at Database level.

  • September 29, 2017 at 8:56 am

    #339554

    Hi
    I have to update passwords on various sql instances.

    I notice on some servers there are reporting type users and databases.

    So for example on one sqlserver 2005 instance I see a user called reportuser and on the same server some reporting service databases.

    Can anyone tell me what is involved with changing this reportsuser ? Is it just a case of running the following and reporting services
    will run as normal thereafter?

    ALTER LOGIN reportuser WITH PASSWORD = '<enterStrongPasswordHere>';

    Thanks in Advance

  • September 29, 2017 at 9:04 am

    #1961678

    You'll probably want to run a trace or Extended Events session to see who or what is connecting as this user.  There may be several reports set up to use it, and if so you'll need to go into all those reports (or shared data sources if used) and change the password there.

    John

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

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