By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

MSDE 2000

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.com> 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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.