connecting sql with windows login with domain

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 23, 2003 at 9:37 pm

  #65084

  I know how to fire a script using osql command line utility, till date i used sql authentication for that. just wanna know is it possible to connect using domain/login and with password ( I does not mean windows authentication as my domain is different)

  If possible appriciate providing a sample command for that...

  Thanks in advance

  Cheers...Prakash

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 24, 2003 at 12:34 am

  #466707

  Come on guys no reply's?? just tell me if it's possible or not? a pointer would be great.....

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 24, 2003 at 3:44 am

  #466746

  Patience! lol

  Never tried. Think pass through will work if you have the same login/password, but typically you get a prompt, not sure there is a way to enter it ahead of time.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 24, 2003 at 5:57 am

  #466766

  here's some more details....

  I am having some 50+ customer boxes to connect and run one common script on them instead of going to one and one which is a time consuming affair and doing manually always give you a reason to mistake....

  Not a SQL security expert so here's all what I know..

  1. On all the SQL servers in users there is a group called BUILTIN\Administrator

  2. On all the server we have defined a user called "access_sql" is member of "administrators" group of that machine, having same password on all the machines.

  Here I don't know what is the connection between BUILTIN\Administrator user group in SQL server and windows group administrators?

  So if I am login to machine "Server1" with login as "access_sql" it can connect to the SQLServer of the same machine with windows authentication.....that's fine. From there only can I connect to other machines with windows authentication??

  Or is there is a way to use SQL login by providing windows login name and password to connect to that SQL server? I am able to logon to that server with this login as administrator.

  Will appreciate any help or pointers

  Cheers..Prakash

  Prakash

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA