Re: Merge Replication using ip address to distributor/publisher

Please note the users have the MSDE installed on their pc, therefore thier
is no enterprize manager or client network utility. Can they do a command
from OSQL to create an alias, but even if they can, i dont think all users
are smart enough to do this even if instructed.
I also read that alias to ip address can be programmed in subscriber
replication coding.

This was in one of the http sites posted in replies to this thread, but it
does have code examples.
"Use ActiveX Controls to pull your subscription. ActiveX Controls have
programmatic methods which allow you to create an Alias without having to
register the Publisher in Client Network Utility."

Does anyone know do to go about coding the alias piece.

thank
Sushil

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%23iUTwOMBHHA.1780@xxxxxxxxxxxxxxxxxxxxxxx
Either use client network utility to build an alias on each subscriber or
use the control properties publishernetwork and tcpip_sockets and then for
publisheraddress enter the ip address, do the same for distributornetwork
and distributoraddress

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"sushil prasad" <sushil@xxxxxxxxxx> wrote in message
news:12l881tjo7i12fa@xxxxxxxxxxxxxxxxxxxxx
I have developed a windows vb.net application which reside on users laptop
and uses data from local msde database. From time to time the users can
connect to a main sql server via VPN and do a merge replication with
subscribtion invoked from their windows application. Problem is that the
main server can only be connected using an ip address. Can ip address be
used in windows
vb.net program as PublisherServer instance instead of the servername.






.

Relevant Pages

  • Re: DTS and the Internet
    ... New SQL Server Registration. ... >> You can use an alias created through the client network utility if you ... >> Then just use the alias name instead of the IP in your connection. ...
    (microsoft.public.sqlserver.dts)
  • RE: Publishing SQL Server
    ... Have you changed the Default Network Library to TCP/IP in the SQL Server ... Client Network Utility? ... Please follow these steps to change the Default Network Library to TCP/IP ... If you need to configure an alias, ...
    (microsoft.public.windows.server.sbs)
  • Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility
    ... I wasn't aware that .NET would even look at the client network utility. ... SQL Server / client network utility is not always going to be installed ... > I am in Administrators and hence was able to add the ALias. ...
    (microsoft.public.sqlserver.server)
  • Re: .NET Data Adapter not taking Alias added in ClientNetwork Utility
    ... It was .NET SQL Data adapter for SQL Server. ... I gave "MyDatabase" for datasource in connection string and it was working. ... > I wasn't aware that .NET would even look at the client network utility. ... >> I am in Administrators and hence was able to add the ALias. ...
    (microsoft.public.sqlserver.server)
  • Re: Connections through a server alias, IP address (...) are not supported
    ... Use client network utility on SQL 2000 or SQL Server Configuration Manager ... on SQL 2005 on the subscriber to create an alias to the publisher. ...
    (microsoft.public.sqlserver.replication)