We are setting up a test laptop to use with Merge replication to a SQL 2K
server that serves as both Publisher and Distributor. I was hoping to
create a push subscription but that needs a register server setup that does
not work. When I go to register the server (MSDE on laptop) from the
Publisher, it shows the laptop computer name in the "Select a SQL Server"
dialog box. But when I select it and choose to connect using either windows
authentication OR SQL server login I get the message "SQL Server does not
exist or access denied". When I setup the laptop with MSDE, I set the
authentication to be "Mixed" and entered a strong sa password. Can someone
tell me why this is happening?
p.s. I can setup the laptop as a subscriber using anonymous settings using
Windows Synchronization Manager from the laptop just fine.
David
Hilary Cotter - 24 Dec 2005 03:37 GMT
Unregister this SQL Server in Enterprise Manager and then add it back again.
I think you are having name resolution problems.

Signature
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
> We are setting up a test laptop to use with Merge replication to a SQL 2K
> server that serves as both Publisher and Distributor. I was hoping to
[quoted text clipped - 11 lines]
>
> David
David Chase - 28 Dec 2005 21:41 GMT
That did not work.
David
> Unregister this SQL Server in Enterprise Manager and then add it back
> again. I think you are having name resolution problems.
[quoted text clipped - 14 lines]
>>
>> David
Hilary Cotter - 29 Dec 2005 03:19 GMT
What is the sa account you are using? It should be the sa account of the
publisher - not the subscriber.

Signature
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
> That did not work.
> David
[quoted text clipped - 17 lines]
>>>
>>> David