Home Forums SQL Server 2005 Administering Login failed for user - Microsoft SQL Server, Error: 4064 RE: Login failed for user - Microsoft SQL Server, Error: 4064

  • Cannot show requested dialog.

    Cannot open user default database. Login failed.

    Login failed for user 'PBTF\bob'. (Microsoft SQL Server, Error: 4064)

    I think the error is what is: cannot open your default database.

    Does the default database still exist?

    You can probably go in via sqlCmd and change your default database.

    sqlcmd -E -d master

    then issue your alter login statement.