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"laststubborn" <arafatsalih@.gmail.com> wrote in message
news:1104862206.970118.48710@.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|||yeah I have installed 2000 SP3a then should I install SQL2000 client
version to my workstation?|||"laststubborn" <arafatsalih@.gmail.com> wrote in message
news:1104873576.019320.324770@.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
No comments:
Post a Comment