Quercus

I'm having trouble getting Access 2000 to connect to my MSDE server - I think it may be an issue with usernames and passwords within MSDE. Its a bit off topic but I hope someone here can help me.

I'm developing a database that will eventually be used within a C# application later on. I've installed MSDE 2000 SP3a from Microsoft with the SAPWD=mypassword switch which should have set the sa password. The installation seemed to finish successfully.

I have also updated my Office Professional to the latest SP's.

However, when within Access I try to create a new Access Project (New Database), i.e. create a new MSDE database and connect it to my Access project, it asks me for the server ("ComputerName"), username with CREATEDATABASE privileges ("sa"), the password ("mypassword") and database name ("NewDataSQL"). The new project comes up, but I cannot add tables etc.

As an experiment, I deliberatly entered a false password, and the database creation process continued just as above. In otherwords, it did not give me an error because my password was incorrect.

I try to reconnect it to the database by changing the connection from the File menu. This process is almost identical to the connection properties from the Visual Studio suite. I give the server name ("ComputerName"), the username and password as above, and then when I click on a drop down list to choose a database, I get the error: "Login failed for user 'sa.' Reason: Not associated with a trusted SQL server connection"

Does anyone have any thoughts?
- What is wrong?
- How can I verify a username and password for MSDE?
- Can I add other users for MSDE?

Thanks for the help.

Quercus

Found the problem, but thanks anyway.

The Authentication mode was set to Windows Authentication. I changed it to Mixed Mode and everything worked just fine.