sa password rules
in [Programming SQL]
|
From: Igor Solodovnikov on 24 Jan 2006 10:27 SQL Server 2005 rejects empty or very short sa passwords. Where can i read formal definition of sa password rules. I writing setup application which will install SQL Server Express in command line unattended mode. So i need to check sa password for its stronginess prior to passing it to SQL Server's installer.
From: Immy on 24 Jan 2006 10:36 not sure where you can read up on it, but a good practice would be to use password that contains a mixture of the following... Numbers, Capitals Letters and Lower case Letters and a minimum of 8 characters. Not sure if SQL2005 actually now uses capitilzation, but previous versions haven't cared about capitilisation. Regards Immy "Igor Solodovnikov" <IgorSolodovnikov(a)discussions.microsoft.com> wrote in message news:op.s3v2j3u4n8ihmu(a)iw2k.helpmicro.local... > SQL Server 2005 rejects empty or very short sa passwords. Where can i read > formal definition of sa password rules. I writing setup application which > will install SQL Server Express in command line unattended mode. So i need > to check sa password for its stronginess prior to passing it to SQL > Server's installer.
From: Ryan on 24 Jan 2006 10:38 SQL Server Authentication passwords are now case sensitive. They follow the valid password rules set for your computer. -- HTH. Ryan "Immy" <therealasianbabe(a)hotmail.com> wrote in message news:%23k0KlvPIGHA.1836(a)TK2MSFTNGP11.phx.gbl... > not sure where you can read up on it, but a good practice would be to use > password that contains a mixture of the following... > Numbers, Capitals Letters and Lower case Letters and a minimum of 8 > characters. > > Not sure if SQL2005 actually now uses capitilzation, but previous versions > haven't cared about capitilisation. > > Regards > Immy > > "Igor Solodovnikov" <IgorSolodovnikov(a)discussions.microsoft.com> wrote in > message news:op.s3v2j3u4n8ihmu(a)iw2k.helpmicro.local... >> SQL Server 2005 rejects empty or very short sa passwords. Where can i >> read formal definition of sa password rules. I writing setup application >> which will install SQL Server Express in command line unattended mode. So >> i need to check sa password for its stronginess prior to passing it to >> SQL Server's installer. > >
From: Igor Solodovnikov on 24 Jan 2006 11:02 I know about a good practice. But when user enters a password my program need to check will SQL Server accept that symbol seqence or not. I need algorithm to implement such check? On Tue, 24 Jan 2006 17:36:05 +0200, Immy <therealasianbabe(a)hotmail.com> wrote: > not sure where you can read up on it, but a good practice would be to use > password that contains a mixture of the following... > Numbers, Capitals Letters and Lower case Letters and a minimum of 8 > characters. > > Not sure if SQL2005 actually now uses capitilzation, but previous > versions > haven't cared about capitilisation. > > Regards > Immy > > "Igor Solodovnikov" <IgorSolodovnikov(a)discussions.microsoft.com> wrote in > message news:op.s3v2j3u4n8ihmu(a)iw2k.helpmicro.local... >> SQL Server 2005 rejects empty or very short sa passwords. Where can i >> read >> formal definition of sa password rules. I writing setup application >> which >> will install SQL Server Express in command line unattended mode. So i >> need >> to check sa password for its stronginess prior to passing it to SQL >> Server's installer. > >
From: Ryan on 24 Jan 2006 11:06 How about encompassing the whole thing in a TRY.. CATCH Block... ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/248df62a-7334-4bca-8262-235a28f4b07f.htm You'll need to check the severity of the error returned when a password doesn't meet the rules as there are certain severity's that are unaffected by TRY..CATCH -- HTH. Ryan "Igor Solodovnikov" <IgorSolodovnikov(a)discussions.microsoft.com> wrote in message news:op.s3v35xrnn8ihmu(a)iw2k.helpmicro.local... >I know about a good practice. But when user enters a password my program >need to check will SQL Server accept that symbol seqence or not. I need >algorithm to implement such check? > > On Tue, 24 Jan 2006 17:36:05 +0200, Immy <therealasianbabe(a)hotmail.com> > wrote: > >> not sure where you can read up on it, but a good practice would be to use >> password that contains a mixture of the following... >> Numbers, Capitals Letters and Lower case Letters and a minimum of 8 >> characters. >> >> Not sure if SQL2005 actually now uses capitilzation, but previous >> versions >> haven't cared about capitilisation. >> >> Regards >> Immy >> >> "Igor Solodovnikov" <IgorSolodovnikov(a)discussions.microsoft.com> wrote in >> message news:op.s3v2j3u4n8ihmu(a)iw2k.helpmicro.local... >>> SQL Server 2005 rejects empty or very short sa passwords. Where can i >>> read >>> formal definition of sa password rules. I writing setup application >>> which >>> will install SQL Server Express in command line unattended mode. So i >>> need >>> to check sa password for its stronginess prior to passing it to SQL >>> Server's installer. >> >> >
|
Next
|
Last
Pages: 1 2 3 Prev: SQL 2005 Mirroring Databases Next: Unmanaged code from SQLServer 2005 CLR |