Login Failed in SQL Server 2012

Resolved SQL
CM
Community Member
July 06, 2015
3 replies
982 views
Reviewed by moderators

Please help! Not able to login after replaced master mdf/ldf file.

Reason: rnThe log scan number (213:18:1) passed to log scan in database 'master' is not valid. This error may indicate data corruption or that the log file (. ldf) does not match the data file (. mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. rnI searched solution for this strange problem and I found a blog post suggesting that I should replace master. mdf and masterlog. ldf files with the ones located in C:\Program Files\Microsoft SQL Server\MSSQL10_50. SQLEXPRESS\MSSQL\Template Data and so I did.

Now I can start the process but I can't log in with neither my 2 previous login accounts. I thought that after replacing master I would at least be able to login with my Windows account, but I can't.

These are the login failed event logs: rnLogin failed for user 'Ramakutty-PC\Ramakutty'.

Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. rnLogin failed for user 'Ramakutty'.

Reason: Could not find a login matching the name provided.

3 Answers
Accepted Answer
Verified by Edwin J. Hoffer, Expert · Reviewed July 2015

You will have to re-create your existing logins.

Login details are stored in the master, so it makes sense that they would be gone if you've replaced the master database files. nDo you have a copy of your old master. mdf and. ldf file, or did you overwrite them? If not, you will have to recreate all the logins

Thanks i have resolved this by recreation of all the existing logins