Authentication issues

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  August 21, 2009 at 3:05 am

  #93940

  Could not connect windows as well as sql authentication, I had done mistake one of the test server.

  Before sql server with login sa, after that i had changed authentication mode on windows only, before changing windows authentication already one windows domain user was deny condition. after that Could not connect windows as well as sql authentication,

  windows

  Error - Login failed for user 'domain user xxx'

  sql authentication,

  Error -

  Login failed for user Not associated with a trusted SQL Server connection..

  C:\Documents and Settings\anandanm>isql -Usa -Pxxxx -Q"select @@version"

  Msg 18456, Level 14, State 1:

  Login failed for user 'PDC_RPL2\anandanm'.

  DB-Library: Login incorrect.

  how to recover grant login domain user? even i am able to connect enterprise manager.

  Please suggestion me, how to correct this?

  thanks in advance

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  August 21, 2009 at 5:14 am

  #1042712

  I resolved the issues with help of below URL

  http://support.microsoft.com/kb/827422