Post reply

Connectivity issue in SQL 2005

  • December 9, 2007 at 6:03 am

    #154007

    We installed SQL 2005 on the server with Windows Authentication. When trying to connect getting error as 'Login failed for user;Error 18456;state 11'.

    Description of error states 'Valid Login but server Acess failure'

    Can anyone suggest how to fix this issue?

    Thanks,

    AP

  • December 9, 2007 at 8:29 am

    #758375

    Check out this link...

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=631415&SiteID=1

    Gethyn Elliswww.gethynellis.com

  • December 9, 2007 at 12:38 pm

    #758398

    Very interesting link. Did it help? Are you XP -> XP?

    I haven't seen this error, but the guest user makes some sense.

  • December 10, 2007 at 4:14 am

    #758524

    I think that you should perhaps remember the rule Login to the Server and Access to Database objects. Just because you have been granted rights to Login to the SQL Server Instance does not mean that you have been granted privileges to any database objects..

    CodeMinkey

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

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