Post reply

Can not use Windows Authenticaion for SQL 2008

  • August 17, 2010 at 12:24 pm

    #222602

    Can not use Windows Authentication on SQL server 2008 Error message:

    Server Name: <server name>

    Error Number: 18456

    Severity: 14

    State: 1

    Line Number: 65536

    Have enabled Windows Authentication Mode in SQL configuration and enabled TCP/IP on the server, running server 2008 R2

    Tired manually setting SPN using setspn -A

    Trying to login as user that is member of Domain Admin which is a member of local Administrator

  • August 17, 2010 at 1:46 pm

    #1208113

    2008 does away with the built in local administrators group. Being a domain admin no longer gives you automatic access to SQl Server as in earlier versions.

    The probability of survival is inversely proportional to the angle of arrival.

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

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