Enforcing Password Policy with 2000 1

[JohnBates]

hi all,

We have Great Plains 9 running on SQL 2000 and Server 2003.

SQL 2000 logins (SQL Server logins) cannot be set to enforce a security/expiration policy as I understand it. I s that correct?

I cannot switch these users to their domain logins because GP requires that the user be a SQL Server user.

Thanks, John

 

[mrdenny]

That is correct, SQL 2000 does not support tying the SQL Accounts to the domain policy.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog