Thursday, March 8, 2012

Can't replicate between two servers

Hello Guys
i have a big problem between my company's two branches
the problem in brief is
we have two sites in two cities
and of course two SQL servers in the two sites
so we have a dbase application but when we try to get the updated records
from one site to another we got this error messege
" SQL server is not exist or access denied "
but the replication application connected to both servers and we can ping
eachother
any help will be appreciated
thanks
P.S: please send a copy on my e-mail taha@.delta-group.org
Can you connect using Query Analyzer or Enterprise Manager? Ping only tells
you there's network connectivity. You need to ensure you have the
appropriate permissions to access SQL Server and of course, the ports must
be open since you're likely to have some kinda firewall/gateway in between.
joe.
"Eng. Taha Khamis A.Wahab" <taha@.delta-group.org> wrote in message
news:OrH25%23qFFHA.1260@.TK2MSFTNGP12.phx.gbl...
> Hello Guys
> i have a big problem between my company's two branches
> the problem in brief is
> we have two sites in two cities
> and of course two SQL servers in the two sites
> so we have a dbase application but when we try to get the updated records
> from one site to another we got this error messege
> " SQL server is not exist or access denied "
> but the replication application connected to both servers and we can ping
> eachother
> any help will be appreciated
> thanks
> P.S: please send a copy on my e-mail taha@.delta-group.org
>
|||yes i check to ports in the firewall and it's all opened
"Joe Yong" <jyongNOSPAM@.scalabilityexperts.com> wrote in message
news:eaqo0UwFFHA.2296@.TK2MSFTNGP15.phx.gbl...
> Can you connect using Query Analyzer or Enterprise Manager? Ping only
tells
> you there's network connectivity. You need to ensure you have the
> appropriate permissions to access SQL Server and of course, the ports must
> be open since you're likely to have some kinda firewall/gateway in
between.[vbcol=seagreen]
>
> joe.
>
> "Eng. Taha Khamis A.Wahab" <taha@.delta-group.org> wrote in message
> news:OrH25%23qFFHA.1260@.TK2MSFTNGP12.phx.gbl...
records[vbcol=seagreen]
ping
>

No comments:

Post a Comment