Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naturalkiller
Starting Member
1 Post |
 Posted - 2005-12-08 : 02:24:28
|
| Hi everyone,I have a problem with the security policy when I use SQL Server.If you are an administrator on domain Server, you can make a policy like that : When user log on MS.Windows, they have to change password at least 6 character, the password includes both numeric and character.So How can I use this policy on SQL Server?I don't want to use Domain authentication , I only want to use SQL Server authentication in mixed mode.Please give me a hand! Thank you very much. |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-12-08 : 02:57:04
|
| These policy are not available in SQL Server 2000 but those are in SQL Server 2005.Surendra |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-12-08 : 15:05:58
|
| You would have to enforce the password complexity with an application. The users shouldn't be logging in directly to the SQL Server anyway usually. Why don't you wnat to use domain authentication?MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
More Security than in SQL Server, How?