SQL logon service

[troyscott]

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.

[GarthMJ]

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?

[troyscott]

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

[GarthMJ]

_{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.

[spgsitsupport]

SQL run as domain user.

These are few helpful sites to achieve this:

https://msdn.microsoft.com/en-us/library/ms143504.aspx

https://technet.microsoft.com/en-us/library/Bb735885.aspx?f=255&MSPPError=-2147217396

http://www.zerohoursleep.com/2010/11/a-fatal-error-occurred-when-attempting-to-access-the-ssl-server-credential-private-key/
http://www.sqlservercentral.com/Forums/Topic1251605-1550-1.aspx
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ee918522-2190-4d5e-9e25-a8ae34ced025/sql-agent-wont-start-under-domain-account-which-is-not-in-local-administrators-group-sql-server?forum=sqlsecurity

Once you have filesystem/PKI/registry/database permissions & SPNs setup correctly, it will work again

 

Seb