What to do with SQL Server not connected SQL SERVER2008R solution (1814\18456) that cannot be logged in _mssql2008

A computer in the morning, black screen run some code to repair the system .... SQL Server is not connected after entering the system

Body

reason:SQL Server's services are automatically shut down and startup failed

Windows log information: The log scan number (286:456:1) passed to the log scan operation in the database ' master ' is invalid. This error may indicate data corruption, or the log file (. ldf) does not match the data file (. mdf). If this error occurs during replication, recreate the publication. Otherwise, if the problem causes an error during startup, restore from backup.

It is obvious that the SQL Server system files out of the question, the first Baidu, the online version of the system will be compressed file, cancel the hook on it can be

But my this has not been ticked, I still try to put it on the hook first, see the effect, and then cancel, but ...

Since you're so heartless, I'll come up with the ultimate solution. File replacement, find a normal sqlserver08r system file, replace it

I was so resourceful, but not so good, it threw me a new error message

1814 remove additional files on the tempdb drive and restart SQL Server to free more disk space.

Not enough space? Completely fart, there are good dozens of g, online all kinds of Baidu, one can solve the problem is not

Like this answer, you might as well not answer, waste other people's time, not at all, reload the database, reload the system

I have to delete the tempdb file, is still reported this error, continue to Baidu

net start mssqlserver/f/m/t3608 This command can start the service directly, but fails when the agent is opened, and it returns an error that the dependent service is turned on and closed.

Continue to Baidu, I found that my configuration Manager is also the case, will it be because of this cause?

This Baidu has a normal answer

Unload this on it, and sure enough, but the problem is still unresolved.

See can't create, simply I have 4 system files are handcuffed come on, sure enough, another mistake

Unable to open file number 1 C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver1\mssql\data\model.mdf. Operating system error: 3 (the system cannot find the specified path.) )。

It is impossible, I obviously replaced 4 files, how can not find, copy the address, the original more than a 1

I copied the whole file, changed a name, ah ha, sure enough, two services know how to start the normal

Login Management Studio, enter account password ....

　

I can log in as admin windows.

18456 ruthless refusal, I go ...

Continue to Baidu, both logins do not go in, change account start service to try

The service is not open.

Also said that the use of a single example mode to change the password, if you can directly change the,,,,,

Of course I have tried, change to a single meeting there is another error, it will tell you already have an example in the visit (service is also counted as an example, the internet is said)

Use sa account to try also login failed, really see the ghost ....

Modify the status of the SA on the other computer (default is disabled) with the password, replace again, this if not again, can only reload ...

Sure enough, to go in and found that the administrator is on top of other computers, this is the reason I have been using Windows login failed, a new administrator, the original administrator to delete, finished.

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.