Skip to content

SQL logon service

Featured Replies

I had to change the SQL logon service account from a domain admin to either a local or domain user, but after doing so the SMS_SRS_REPORTING_POINT is showing errors. The error is

 

The report server service is not running on Reporting Service Point server "serverName"; start the service to enable reporting.

 

The SQL Server Reporting Services (MSSQLSERVER) is running so I don't understand how I'm getting this error. I even tried another domain admin account. Please advise.

How exactly did you change the server account name? did you use the Service applet or the SQL Setup applet?

 

Have you tried to report the RP and re-add it?

  • Author

No, I just changed the logon account on the SQL service in services.

No, I just changed the logon account on the SQL service in services.

 

It not supported/recommend to change the logon from the services applet. You need to change it from the SQL tool only. This will ensure that the right permission are setup in the DB and on the DB files themselves.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.