MSDE 2000

[farqua]

I've finally got MSDE 2000 sp3a to install on my PC by turning on the
"Server" service. Duh!

Unfortunately, I can't get it to connect to the server when I try to
upsize a tables in an mdb database file. The SQL Server Manager icon is
running and I am able to start the SQL server. I get a dialog box message
about unknown procedure or something like that. I am running a stand alone
PC with a DSL connection. I am trying to run the server and client on the
same box, not in a networked environment and I am attempting to run it
with the "Trusted Connection" box checked. I've also tried to use the
account login (using "sysadmin" and my WinXP login account and various
passwords including the SA password.) I used "setup.exe SAPWD=XXXXXXX" to
install MSDE. I only have my local computer available in the server box,
it shows the hostname I've assigned to this PC. If I try to change the
hostname, I get a different error dialog box which indicates that that was
a bogus server name.

I am wondering what other are other services that need to be running to
get the client (MS Access) to connect to the MSDE server and how I can get
MSDE up and running.

[Joseph Li]

I have installed MSDE 2000 sp3 on a Standalone PC running Win 98. It worked
ok and I was able to upsize MDBs to ADPs. Of course on Win 98 I am not using
Trusted Connection.

What does the snapshot file say about the error message ?
Since you have set a password for sa you could try using sa instead of
Trusted Connection for the upsizing process.

rgds
Joseph Li
"farqua" <fa****@news.co m> wrote in message
news:pa******** *************** *****@news.com. ..

I've finally got MSDE 2000 sp3a to install on my PC by turning on the
"Server" service. Duh!

Unfortunately, I can't get it to connect to the server when I try to
upsize a tables in an mdb database file. The SQL Server Manager icon is
running and I am able to start the SQL server. I get a dialog box message
about unknown procedure or something like that. I am running a stand alone
PC with a DSL connection. I am trying to run the server and client on the
same box, not in a networked environment and I am attempting to run it
with the "Trusted Connection" box checked. I've also tried to use the
account login (using "sysadmin" and my WinXP login account and various
passwords including the SA password.) I used "setup.exe SAPWD=XXXXXXX" to
install MSDE. I only have my local computer available in the server box,
it shows the hostname I've assigned to this PC. If I try to change the
hostname, I get a different error dialog box which indicates that that was
a bogus server name.

I am wondering what other are other services that need to be running to
get the client (MS Access) to connect to the MSDE server and how I can get
MSDE up and running.