• MiguelSQL (3/11/2011)


    My windows ID is part of the Local Administrators Group

    When I start the server in single mode, and I try to log in, I get the error:

    Login Failed for user ". The user is not associated with a trusted SQL Server connection.

    That sounds like your account might be in a different domain and that the trust between the two domains isn't working 100%.

    I would try creating a local account on the server, add it to the local administrators group, then log on to the server using the local account and start SQL Server in single user mode. That way you take all the domain portions out of the picture. Once you have regained SA access you can just delete the local account.