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
272 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

680 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