locked
Cannot login to SQL databases RRS feed

  • Question

  • Hi all!

    Right after our net admin disabled an account which we used to install SQL Server Ent 2008 R2, we can't login to our SQL Servers using Windows Authentication. I also tried using the "sa" account we created but we still can't login. 

    I checked the SQL Error Log and this error message was displayed:
    2012-01-25 16:50:51.04 Logon       Login failed for user 'domain\new_user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <whatever_machine>]

    What worries me is that we have 40+ SSRS reports in that server and ever since that certain user account was disabled, we can't even locate the .rdl files. My colleagues wasn't able to backup the .rdl files. When I checked the User Profile folder for that disabled user, nothing's found. The User Profile Folder is empty.

    Is it possible that since the account we used to install the instance was disabled, this error happened? I tried disabling UAC as I read in some thread but this error still emerge.

    Anyone had other ideas on how to solve this?


    Join me at myLot and earn money by creating and responding to discussions
    http://www.mylot.com/?ref=keihimekawa
    Thursday, January 26, 2012 1:18 AM

Answers

  • Hi,

    Try re-starting the instance in Single user mode so that you can get back in and then you can try to fix the security and reports. Once the instance is in single user mode any user with local admin rights should be able to logon to SQL with sysadmin rights.

    http://msdn.microsoft.com/en-us/library/ms188236.aspx


    Sean Massey | Consultant, iUNITE

    Feel free to contact me through My Blog, Twitter or Hire Me.
    Please click the Mark as Answer button if a post solves your problem!

    • Marked as answer by kei.himekawa Monday, January 30, 2012 11:20 AM
    Friday, January 27, 2012 2:30 AM

All replies