SQL Server 2008 R2 Login Issue

Posted on 2011-10-18
Last Modified: 2012-05-12
Our server crashed yesterday and I had to take the .mdf file and put it on another server.

Now when I login I get the following error:

Server Name:
Error Number: 18456
Severity: 14
State: 1

Is there something I need to reset to be able to login to the database again?
Question by:ProdigyOne2k
    LVL 28

    Accepted Solution

    You'll have to look at the server logs and determine the actual error state to decode what it means:
    LVL 8

    Expert Comment

    your missing the log file
    LVL 8

    Expert Comment


    Author Comment

    Looked at my indicated I was not in "mixed authentication mode" - I WAS...but I had not restarted the server.  I right clicked and restarted the server...problem solved


    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now