Hi there - I'm in a real ****** and need help.
I noticed a series of attempts on the sa account in SQL Server 2000 so I decided to change the password to a long a complicated one to lower the risk of it breaking. I made a lengthy password in notepad, then copy/pasted it into SQL Server (this is all over a Remote Desktop Connection).
The next time I tried to log in it simply wouldn't let me - I kept the original password but it just won't accept it. I don't understand what could have gone wrong!
If anyone has any ideas, they are extremely welcome.