Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem.
So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the server. Now its SQL Server 2005, and here's a problem:
The SQL users' password in SQL Server 2000 is case insensitive and there are many little submodules written maybe 10 years ago, where the connection string is hardcoded and compiled(missing source codes). So I'm not able to edit the connection string, and as the password was case insensitive the developers weren't used password in right case. The right case kept only in few modules.
So I want to find a way to change the password policy for SQL Server 2005, or create multipassword user (I don't think its possible), or maybe you can suggest me a different way to solve this.