Post reply

SQL SERVER EXPRESS CONNECTION PROBLEM

  • May 29, 2008 at 5:06 am

    #191613

    Hi, i have just installed sql serve 2005 express edition but when i try to connect to database engine it gives me microsoft Server error 18456.

    Does anyone knows why please. thanks

  • May 29, 2008 at 5:23 am

    #821685

    18456 is Login Failed. It's usually due to incorrect username or bad password.

    Are you using windows authentication or sql authentication?

    If windows authentication, are you local admin on the machine ?

    Is the machine running Vista as an OS?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 29, 2008 at 10:59 am

    #821871

    This link is useful for diagnosing the specific cause of the error:

    http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

    "Got no time for the jibba jabba!"
    -B.A. Baracus

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

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