Windows cannot start SQL Server (MSSQLSERVER) on a local computer. For more information, consult the system event log. If this is a non-Microsoft service, contact the service vendor and refer to the specific service error code 10048.
Operating environment: Windows xp + sql server 2008
Today, when I first came to the company, a colleague said that his data engine service could not start, so I went to the event viewer to check the system log (right-click on My Computer and select Manage), as follows:
Workaround:
Enter the configuration tool of SQL Server, disable the service of SQL Server (SQLEXPRESS) (in order to prevent it from starting again next time on the computer, set the startup mode to manual (right-click - it can be set in the attributes)), and then start SQL Server (MSSQLSERVER), which is successful, as shown in the figure below:
This is generally caused by the port number of Sql Server being occupied by other applications, you can use dos commands or network tools to view the current port usage, see which program occupies the default port 1433 of Sql Server, and restart the program after finishing it; If you find it troublesome to view, you can also directly change the default port of SQL Server and start the Sql Server service
This kind of problem is generally the default port of mssql is occupied, find the port occupied by the process, and then kill it.
If you find that the default port is not occupied, or some strange problems, please restart the computer to solve it!
|
Posted on 9/6/2016 10:37:29 AM
|
|
|
|
Landlord