Login Failure with Error: 18456, Severity 14, State 8 RRS feed

  • Question

  • Hi
    I know there are lot of posts about this error but I still did not find the correct solution for my issue.
    Here is my problem.

    I have two databases on my SQL Server namely Database01 and Database02. I seldom detach nor attach a database but we do it occassionally for backup purposes. I don't know why we're told to but we all are newbie on SQL and we don't have much to ask to except here. So to continue..

    After detaching and attaching the database02 all my database users have login failure, with the above error log. I have remapped the logins to database02 users but no luck. I have re-created users and even new login and mapped it to a new database user with still no luck. My Database01 is not affected at all. I don't know what else to do. Please hlp.

    I have SQL Server 9.0.4035 in Windows 2003 SP2 (3GHz 12GB RAM)
    Saturday, February 14, 2009 11:35 AM