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

Connection Problem with the Workstation

P: n/a
Hi all;

I am trying to replicate our database by using the merge replication.
From server side I tried to connect to the workstation. I have

installed MSDE to the client machine. I can see the machine name on the
SQL Server Group however I wasnt able to create the conncetion between
the machines. I have checked my network connection, there is no problem
I can see the machine and I can connect it through the network. I tried
to use Client Network Utility with Named Pipes and TCP/IP but not a
good news. I couldnt achieve to connect to the machine. So could
someone please help me out with this problem. I am really in trouble I
have to find out this end of this week.

Regards
As

Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"laststubborn" <ar*********@gmail.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
Hi all;

I am trying to replicate our database by using the merge replication.
From server side I tried to connect to the workstation. I have

installed MSDE to the client machine. I can see the machine name on the
SQL Server Group however I wasnt able to create the conncetion between
the machines. I have checked my network connection, there is no problem
I can see the machine and I can connect it through the network. I tried
to use Client Network Utility with Named Pipes and TCP/IP but not a
good news. I couldnt achieve to connect to the machine. So could
someone please help me out with this problem. I am really in trouble I
have to find out this end of this week.

Regards
As


You don't mention your version of MSDE, but network access is disabled in
MSDE 2000 SP3a:

http://support.microsoft.com/kb/814130

Simon
Jul 23 '05 #2

P: n/a
yeah I have installed 2000 SP3a then should I install SQL2000 client
version to my workstation?

Jul 23 '05 #3

P: n/a

"laststubborn" <ar*********@gmail.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
yeah I have installed 2000 SP3a then should I install SQL2000 client
version to my workstation?


If you have MSDE 2000 SP3a, then by default you cannot access it from the
network, so that is probably why you cannot connect to the MSDE installation
on your workstation from your server (if I understood your problem
correctly). As mentioned in the KB article, you can use the MSSQL network
utility to enable network support, and then you should be able to connect to
MSDE from other computers.

Simon
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.