MSDE SA Password doesn't work
Posted on 2006-03-29
I've installed MSDE to a pc connected to a new Canon ImageRunner multi-function device. The manual has instructions on how to install MSDE so that you can create an address book which users can pull email addresses from when they use the machine to email.
When installing MSDE, I used the syntax:
After successful installation and rebooting, the MSDE icon appears in the system tray with a green arrow signifying that it is running correctly.
Then I went into the configuration program to create a new address book. When I click the create button, I am prompted for:
an SQL server, to which I chose "local"
a User ID, to which it defaulted to "SA"
a password, to which I entered the password I set during the install
a name for the address book I am creating, to which I entered "ShareScan"
But when I click OK, it says "Invalid Username or Password." I was 99.99% sure I knew what I set the SA password to during install, but to make sure, I uninstalled MSDE, then reinstalled it and took a screen shot of the command line with the SAPWD= switch for reference. Armed with a screen shot, I'm 100% sure what I set the SA password to! Yet, I STILL get the invalid username or password message when I try to create the address book.
What would I be doing wrong?