SQL干事器无法启动,未能建立与(LOCAL)的连接处理方法(国外英文资料).doc

SQL服务器无法启动,未能建立与(LOCAL)的连接解决方法(国外英文资料) Yesterday, just completed the database table, today boot, SQL server can not run, early morning also have to solve the problem. Error: failed to establish connection with (LOCAL). SQL may not exist or connection error. Go to the Internet for answers. One is that directly find the server can start in the service, I think this method is probably feasible, simple, but not too serious because of the investigation, did not find MSSQLSERVER (yes), only to find a SQLSERVERAGENT, when enabled, can not start, presumably, MSSQLSERVER did not start. It failed to establish a connection with (local) ? The reason is that SQL cannot log in for more than the following reasons: ? 1, you modified the windows administrator password and user name, but forget to modify the SQL, and naturally can not login, modify, synchronize! ? 2 accidentally deleted the administrators user (SQLs windows login account BUILTIN\Administrators and Administrator) Solve in the following ways: ? The installer you need to run SQL SERVER, in the installation options screen select advanced options, select registry reconstruction after the next step, next to the installation process, pay attention to in the choice of the authentication mode of the choice of mixed mode, the purpose is to make available SA account. After the completion of the reconstruction, use the query analyzer to log in using the SA account and execute the sp_grantloginbuiltin\administratorsin the query analyzer This will restore windows authentication. If you simply delete BUILTIN\Administrators, and administrator does not move, you can open it by query analyzer, With SA connect, then sp_grantloginbuiltin\administrators, can run, as long as I fix this step, there may be other issues, online fill, for everyone to see. Unable to connect to server. User login failed Terms of settlement: The reason for this error is that the SQL Server uses a Windows only authentication method, Therefore, the user cannot co