Windows authentication not working

• Zeal-DBA

  SSCarpal Tunnel

  Points: 4332

  More actions

  June 17, 2014 at 9:52 am

  #308263

  hello experts,

  I have a clustered (VCS) environment, in which can login to SQL server using windows authentication on production server but when services failover to DR server i don't get login to SQL using windows authentication on DR server. please share your view points, what possible causes could be there.

  thanks in advance.

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  June 17, 2014 at 12:14 pm

  #1722440

  It almost has to be incorrect security on the instance. It might incorrect security on the server. But it has to be incorrect security.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning