Post reply

Error when try to connect SQL Server

  • March 15, 2018 at 1:50 pm

    #344355

    Dear Members 

    im create local user and im give permissions to access sql server
    but im received this error

    What is the solution ?

    Thanks
    Almir

  • March 15, 2018 at 2:00 pm

    #1983470

    almirfiorio - Thursday, March 15, 2018 1:50 PM

    Dear Members 

    im create local user and im give permissions to access sql server
    but im received this error

    What is the solution ?

    Thanks
    Almir

    Look in the SQL Server error log, find the State associated with that error and that tells you the reason. There should be something like:
    Error: 18456, Severity: 14, State: <SomeNumber>
    I don't think 2008 states the reason in the log file after the error - maybe it does so check the next line as it might have the reason. Otherwise, this site has a good list of the state numbers and what they mean:
    Troubleshooting Error 18456

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply