Troubleshooting: Restore Error - Please change your Log On Account as Local System account for SQL Server at Windows Services: Difference between revisions
Troubleshooting: Restore Error - Please change your Log On Account as Local System account for SQL Server at Windows Services (view source)
Revision as of 03:52, 30 March 2020
, 4 years agono edit summary
(Created page with "'''Question :''' When I restore account book, error prompted: Please change your Log On Account as Local System account for SQL Server at Windows Services…. What should I do...") |
No edit summary |
||
Line 14:
<u><b>Solution :</b></u>
Go to <span style='color:red'>SQL Configuration Manager > SQL Server Services</span>, <span style='color:red'>right click</span> SQL Server (Instance Name) and select <span style='color:red'>Properties</span>, in the <span style='color:red'>Log On tab</span>, change the Log On as to <span style='color:red'>Built-in account: Local System</span> and click on <span style='color:red'>Apply</span> and <span style='color:red'>OK</span>.<br/>
Then <span style='color:red'>right click</span> SQL Server (Instance Name) and select for <span style='color:red'>restart</span> the services.
[[File:Restore sql logon2.png]]
[[File:Restore sql logon6.png]]
Line 27 ⟶ 32:
<span style='color:red'>Right click</span> on SQL Server (Instance Name) and select <span style='color:red'>Properties</span>, in the <span style='color:red'>Log On tab</span>, change the Log On as to <span style='color:red'>Local System account</span> and click on <span style='color:red'>Apply</span> and <span style='color:red'>OK</span>.<br/>
Then <span style='color:red'>right click</span> SQL Server (Instance Name) and select for <span style='color:red'>restart</span> the services
[[File:Restore sql logon4.png|850px]]
[[File:Restore sql logon5.png]]
| |||