"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:ertlFqOGFHA.936@TK2MSFTNGP12.phx.gbl...
> You have to also specify DistrutionNetwork, DistributorLogin,
> DistributorPassword and Distributor
>
> --
> Hilary Cotter
> 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
>
> "astro" <astro@bcmn.com> wrote in message
> news:updsbFFGFHA.2824@tk2msftngp13.phx.gbl...
> > I have setup a replication sandbox with the following:
> >
> > server: SQL-Server 2k
> >
> > workstation: MSDE 2000 (A)
> >
> > I have setup a replication database on my server and configured it for
> > anonymous pull subscriptions. I am running this inside my LAN.
> >
> > I run the following code in an Access 2000 module:
> >
> > With SQLMerge
> >
> > .Publisher = "SERVER"
> > .PublisherAddress = "SERVER"
> > .PublisherSecurityMode = DB_AUTHENTICATION
> > .PublisherLogin = "sa"
> > .PublisherPassword = "nnnn"
> > .PublisherDatabase = "mydb"
> > .Publication = "publ_mydb"
> > .PublisherNetwork = TCPIP_SOCKETS
> >
> > .Subscriber = "HOME\myapp"
> > .SubscriberSecurityMode = DB_AUTHENTICATION
> > .SubscriberLogin = "sa"
> > .SubscriberPassword = "nnnn"
> > .SubscriptionType = PULL
> > .SubscriptionType = ANONYMOUS
> >
> > .ExchangeType = BIDIRECTIONAL
> > .FileTransferType = FILETRANSFERUNC
> >
> > .AddSubscription CREATE_DATABASE, NONE
> >
> > .Initialize
> > .Run
> > .Terminate
> >
> > End With
> >
> >
> > The sub runs up to the ".run" command where the logon failure occurs.
> >
> > I have cut/pasted the login information into QueryAnalyser and am able
to
> > log into the local Server.
> >
> > I have noticed that the mdf & ldf files are transfered to the
workstation
> > and the database is visible after running this code (without system
tables
> > only).
> >
> > I have to manually remove the 'mydb' database from EM before trying
again.
> >
> > Is this a security issue? What steps can I take to troubleshoot this?
> >
> > Thanks very much.
> >
> >
>
>

"astro" <astro@bcmn.com> wrote in message
news:updsbFFGFHA.2824@tk2msftngp13.phx.gbl...
> I have setup a replication sandbox with the following:
>
> server: SQL-Server 2k
>
> workstation: MSDE 2000 (A)
>
> I have setup a replication database on my server and configured it for
> anonymous pull subscriptions. I am running this inside my LAN.
>
> I run the following code in an Access 2000 module:
>
> With SQLMerge
>
> .Publisher = "SERVER"
> .PublisherAddress = "SERVER"
> .PublisherSecurityMode = DB_AUTHENTICATION
> .PublisherLogin = "sa"
> .PublisherPassword = "nnnn"
> .PublisherDatabase = "mydb"
> .Publication = "publ_mydb"
> .PublisherNetwork = TCPIP_SOCKETS
>
> .Subscriber = "HOME\myapp"
> .SubscriberSecurityMode = DB_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "nnnn"
> .SubscriptionType = PULL
> .SubscriptionType = ANONYMOUS
>
> .ExchangeType = BIDIRECTIONAL
> .FileTransferType = FILETRANSFERUNC
>
> .AddSubscription CREATE_DATABASE, NONE
>
> .Initialize
> .Run
> .Terminate
>
> End With
>
>
> The sub runs up to the ".run" command where the logon failure occurs.
>
> I have cut/pasted the login information into QueryAnalyser and am able to
> log into the local Server.
>
> I have noticed that the mdf & ldf files are transfered to the workstation
> and the database is visible after running this code (without system tables
> only).
>
> I have to manually remove the 'mydb' database from EM before trying again.
>
> Is this a security issue? What steps can I take to troubleshoot this?
>
> Thanks very much.
>
>