Server| Error | resolution
When you install SQL Server2000, you use the default logon user as the account to start the SQL Server service (usually the administrator for the stand-alone computer that you are using), but I changed the username "failed to start service with logon failure" error The following methods I have tried.
1, change the user password back to the original, and then start the service
2, using the control Surface Service Manager, find the MSSQLServer service, change the startup account information, changed to change, and then start the service
3, is also the recommended method, create a new user, specifically to start the SQL Server service, the installation of SQL Server to use the user to start SQL Server, so you can avoid the frequent changes to the administrator password with the 1069 error. If you have installed SQL Server, you can also change the service account information for the MSSQLServer service under the control Surface Service Manager and replace it with a user dedicated to the SQL service.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
