1
Vote

SQL Server Password Policy ERROR

description

I'm getting a Policy Target No targets found when evaluating against one sql 2005 instance. I can see in the logs where it logs in and out without issue but the report is saying no targets found. Any ideas? I'm uisng the policy, SQL Server Password Policy with Server Restriction: SQL Server Version 2005 or later version. It works on our other couple of 05 instances.

One other question. How do you get the policy to evaluate against the node hosting the CMS? I'm looking at running it manually and creating a job that enters the values into the database for this one sql instance as it does more than host the CMS.

Thanks guys! Boss is happy, I'm happy!

comments