password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
Martin
Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:

> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>
|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:

> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
> and should be performed unless you have good knowledge of the SQL Server architecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>
|||Thank you so much!
Martin
"Tibor Karaszi" wrote:

> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
>