Solved

My issue is in regards with turning on Check Policy for SQL Server Logins when SQL Server 2005 is running on Windows 2003.  The Check Policy is ignored and simple passwords can be used.

Posted on 2009-05-14
2
269 Views
Last Modified: 2012-06-21
The issue is in regards with turning on Check Policy for SQL Server Logins when SQL Server 2005 is running on Windows 2003.  The Check Policy is ignored and simple passwords or even blank passwords are allowed.  Is this a Windows 2003 bug? What does it take to get it working?
0
Comment
Question by:RPIS
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 250 total points
ID: 24385592
Have a look at the link below to see if the Password Policy is enforced in the Local Security Policy / Group Security Policy on the server -

http://www.mssqltips.com/tip.asp?tip=1088
0
 

Author Comment

by:RPIS
ID: 24388404
As it turns out Group policies were not turned on at the Domain Controller, thus nothing was being passed down to the Server. So, The answer given would be correct at the Server level.  Thanks.
0

Featured Post

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now