Q
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.
I'm developing a database and want to use MSDE and the DB engine. 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 lastes 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.
think it may be an issue with usernames and passwords within MSDE.
I'm developing a database and want to use MSDE and the DB engine. 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 lastes 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.