SQL Server Performance Forum – Threads Archive
Sql Server 2k password
HI, We are trying to launch a job from the command line using DTS run, and it looks like we need to expose the password to do this. I do not want to expose the password, and am wondering if I can pull the hex value somehow.. I tried that, but it does not work when I use the DTS run utility from the command prompt, it is giving me a hex conversion error, when I grab the password from the syslogins table. In other words, does anyone know of a way to execute dTS packages using the command shell, and logging in as another user without exposing the password..? Any ideas anyone..?? -David RoeschSan Diego, Ca
I really don’t know if is possible.
Who else can view DTS if is not DBA?
I suggest to wait others post. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
Why not use trusted connection using DTSRUN utility?
Check this linkhttp://msdn.microsoft.com/library/en-us/dtssql/dts_pkgmng_sec_09dl.asp for security in DTS packages.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>