Post reply

Severity: 14, State: 8 error.... Please Help..

  • January 9, 2007 at 1:25 am

    #174432

    Hello guys,

    Error: 18456, Severity: 14, State: 8.

    Login failed for user 'sa'. [CLIENT: <ip address>]

    With what Ive searched.. State: 8 is wrong password. What Ive

    encountered I believed is not State: 8 I guess... I have 2 pc..

    PCX and PCY.. PCY has SQL Server 2005 so does PCX.. when I run my application that stores data to PCY DB it prompts me an error just

    like the one above.. but what seems to be confusing me is both of them have the same DB password. Did I miss something... please help..

  • January 9, 2007 at 5:22 am

    #681988

    hi,

        i am not confirmed that this should work or not. u can try this!!

    first of all check ur network connections i.e whether u r able to ping ur PCY or not.

    if yes then check for sqlserver password, if that is also right then check for properties of ur sql server, click on security tab check for the authentication mode. it should be sqlserver & windows both.Also check in the same tab for startup service account, it should be system account.

    hope this will work.

  • January 9, 2007 at 10:51 pm

    #682296

    I am not getting it right... can you show me some screen shots (if any)...

  • January 9, 2007 at 10:57 pm

    #682297

    soRry,... I get it now... geez... but I havent seen Service account...

Viewing 4 posts - 1 through 3 (of 3 total)

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