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
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.

738 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