July 23, 2003 at 9:37 pm
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
July 24, 2003 at 12:34 am
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
July 24, 2003 at 3:44 am
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
July 24, 2003 at 5:57 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply