How can access SQL Server by same windows user account from multiple Machine

• Thom A

  SSC Guru

  Points: 99130

  More actions

  July 15, 2019 at 1:31 pm

  #3663014

  Andrey wrote:

  I don't select, you don't select, but life is diverse and there are deviations. Let's see what the author will say.

  This is nothing to do with the diversity of lives, it's clear from the picture...

  

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• Andrey

  SSC Eights!

  Points: 840

  More actions

  July 15, 2019 at 1:37 pm

  #3663017

  Thom A wrote:

  Andrey wrote:

  I don't select, you don't select, but life is diverse and there are deviations. Let's see what the author will say.

  This is nothing to do with the diversity of lives, it's clear from the picture...

  Thanks, Tom, I got your point from the first reply.

  However all 4 red arrows look good.

• Prakash T

  SSC Enthusiast

  Points: 188

  More actions

  July 15, 2019 at 2:19 pm

  #3663047

  Thank you all for the reply. here is the solution,

  these are service accounts created using windows authentication and to test the user works fine or not u need to follow below steps,

  Connect via SSMS : right click the SSMS in the task bar then Ctrl + Shift + right click  on the SSMS icon then you can see RUN AS DIFFERENT USER -> click on that then share the Service account credentials then it will connect as windows authentication.

  Connect via Application using Connection String: set this parameter in the connection string then it will take service account credentials: Integrated Security = SSPI;

   

   

   

  • This reply was modified 5 years, 4 months ago by  Prakash T.