Login Failed

• sbalaven

  Ten Centuries

  Points: 1127

  More actions

  January 25, 2008 at 3:48 am

  #73963

  Hi,

  I created on windows users group and added two members on that group then mapped the group in SQL 2000 server and granted db access for that group and also specific rights for that group.

  When one of the member access this databases through query analyzer from his windows login, Server throws "Login failed for user domain\username".

  what could be the error.

  Regards,

  S.Balavenkatesh

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  January 28, 2008 at 11:18 pm

  #772726

  Hi,

  Please list the steps u performed in doing the same...

  have u assigned default database?

  Regards,

  Ahmad

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]