SQL Server can't start common faults

xiaoxiao2021-03-06  41

1. Do you modify the operating system password?

- Modify the operating system password, result in a solution that SQL cannot start:

Solution 1. My Computer - Control Panel - Management Tools - Services - Right-Type MSSQLServer - Property - Login - Login Identity - Select "Local System Account" Solution 2. My Computer - Control Panel - Manage Tools - Services - Right to MSSQLServer - Properties - Login - Login Identity - Select "This Account" - Password and Confirm Password Enter the Administrator password after you modified.

Differences: Select the first way, then modify the Administrator password, no need to adjust (but required to log in the operating system)

Select the second way, and then modify the Administrator password, but also repeat the above operation.

2, is there a computer name? If it is modified, put it in the SQL installation disc, perform the installer to fix (the repair process is automatically performed, the prompt operation will do, no data, it is also very fast)

转载请注明原文地址:https://www.9cbs.com/read-73700.html

New Post(0)