You can use certificates with MMPC. Checkout the latest version of the MOM
2005 Security Guide for the details.
As for the DTS task, you cannot use certificates for the DTS Task Account;
however, you could use a certificate in conjunction with SQL Server (via
OLEDB Encryption) to encrypt the connection between the MOM Database and the
MOM Data Warehouse. See 316898, How To Enable SSL Encryption for SQL
Server 2000 with Microsoft Management Console for more info. Note: using
OLEDB Encryption has SQL Server-wide effects.
--
Christopher Coy
You may log a bug or Feature Request directly to the MOM Product Team by
going to http://www.microsoft.com/mom/feedback. This posting is provided "AS
IS" with no warranties, and confers no rights. Use of any included script
samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Post by Bill Hodghead [MSFT]As far as I know the DTS package requires a trusted domain as the account
needs access and permissions on both servers
--
Bill Hodghead
Tester, MOM Product Team
You may log a bug or Feature Request directly to the MOM Product Team by
going to http://www.microsoft.com/mom/feedback. This posting is provided
"AS IS" with no warranties, and confers no rights. Use of any included
script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Post by Chris CalvinIs anyone aware of existing documentation regarding the use of certificates
in lieu of accounts for non-trusting domains? Specifically for the MMPC and
with the SC DTS package task.
Also, can I use external certificates if I do not have corporate PKI?
Many thanks in advance!