Post reply

Login Failures

  • March 7, 2016 at 10:53 am

    #308632

    Login failed for user domainaccount: [Client:<named pipe>]

    Error: 18456, severity: 14, State: 16. This login has sysadmin permissions.

    This is using builtin account (Network Service). This is 2005 SQL Server

  • March 7, 2016 at 11:07 am

    #1863523

    i think State 16 means the default database assigned to the login does not exist. it might have been dropped or renamed.

    change the default database of the login in question to master, and it should be all set.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 7, 2016 at 12:56 pm

    #1863543

    I see the default db is already Master.

    is this possible to have link with protocols?

  • March 8, 2016 at 3:57 am

    #1863636

    If your database is not in single user mode or Auto_close, Have you tried using TCP? Did you notice any handshake error ?

  • March 8, 2016 at 12:03 pm

    #1863786

    Does enabling the TCP\IP protocal requires restarting the sql server

  • March 8, 2016 at 8:05 pm

    #1863905

    Yes, it does required

  • March 8, 2016 at 11:37 pm

    #1863914

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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