- Use SA and password for SA can be changed with Enterprise Manager
- Use table "JobHistorySummary"
For ePO database (SQL 2000) - McAfee ProtectionPilot use "AVIView_LeafNode" view, but again I was not sucsessful with Windows Integrated Authentication, so used SA
Connection to Access databases is still not clear for me, despite the article with the connection description, I tried with Office Designer 2007:
For this demo I download a sample Access database from Office Online
and placed it in a directory on my WSS server. The MDB can't be on a network share.Enable the Data Retrieval Services from the WSS Central Adminstration.
run the following stsadm command to check the OLEDB providers that are enabled
stsadm -o getproperty -propertyname data-retrieval-services-oledb-providers
If you don't see Microsoft.Jet.OLEDB.4.0 in the list, append it to the existing list of providers and set the new list of providers similar to this:
stsadm -o setproperty -propertyname data-retrieval-services-oledb-providers -propertyvalue DB2OLEDB;IBMDADB2;MSDAORA;OraOLEDB.Oracle;SQLOLEDB;Microsoft.Jet.OLEDB.4.0
In FrontPage, add a Data Source under Database Connection. You will have to select a Custom Connection string which should look like this