Showing posts with label names. Show all posts
Showing posts with label names. Show all posts

Friday, March 30, 2012

MSDE Subscriber names

I plan to set up merge replication and have laptops with an MSDE
subscription for replication. I want my application to use the database
name and wondered if I can (and should?) have the same database name on both
the laptop and the main publication. Thanks.
David
It helps to identify the subscriber database, but there is no real
requirement. All the subscribers should have the same database name if you
are publishing to multiple subscribers at once.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23KWrAVCpFHA.320@.TK2MSFTNGP09.phx.gbl...
> I plan to set up merge replication and have laptops with an MSDE
> subscription for replication. I want my application to use the database
> name and wondered if I can (and should?) have the same database name on
both
> the laptop and the main publication. Thanks.
> David
>

Monday, March 19, 2012

MSDE names instance as Replication publisher?

I'm trying to setup a named instance of MSDE on my local machine, as a
Replication Publisher and I always get an error. My named instance is called
"MSDE"
Error 18483: Could not connect to server 'mymachine\msde' because
'distributor_admin' is not defined as a remote login at the server.
The only remote thing I can find on the MS support site is:
http://support.microsoft.com/default...;en-us;Q324992
but that really didn't help, since it was talking about IP addresses and not
named instances of MSDE.
Can anyone help me get this resolved?
FYI... i also found this article:
http://support.microsoft.com/default...b;en-us;818334
which talks about server names... when I look at the @.@.ServerName variable,
it returns my hostname and instance name: CORPDALL140451\MSDE
is that the problem? I already have a SQL Server instance with no name
running on my machine, but I must have this MSDE instance be the replication
publisher.
"Derick Bailey" <DerickBailey@.srcp.com> wrote in message
news:eR7q4xUtEHA.3788@.TK2MSFTNGP09.phx.gbl...
> I'm trying to setup a named instance of MSDE on my local machine, as a
> Replication Publisher and I always get an error. My named instance is
> called "MSDE"
> Error 18483: Could not connect to server 'mymachine\msde' because
> 'distributor_admin' is not defined as a remote login at the server.
> The only remote thing I can find on the MS support site is:
> http://support.microsoft.com/default...;en-us;Q324992
> but that really didn't help, since it was talking about IP addresses and
> not named instances of MSDE.
> Can anyone help me get this resolved?
>