服务器突然MSSQL的服务丢了,用下面这个方法,不用重装MSSQLserver了
sc create MSSQLSERVER binpath= "\"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe\" -sMSSQLSERVER" displayname= "SQL Server (MSSQLSERVER)" depend= Tcpip start= auto
sc create SQLSERVERAGENT binpath= "\"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLAGENT90.EXE\" -i MSSQLSERVER" displayname= "SQL Server Agent (MSSQLSERVER)" depend= Tcpip start= auto
转载,出处:http://www.heyihu.com/it/3406.html
标签:mssql,服务,MSSQLSERVER,Server,binpath,SQL,MSSQL From: https://www.cnblogs.com/zhihua09/p/16624420.html