Hi all,

I have issue to configure SQL Server Distribution database.
i found warning message " SQL Server Distribution is not define. Define it using Microsoft SQL Server Distribution configuration wizard"

my source OLTP using SQL 2000 and will replicate to SQL 2005.
i cannot configure distribution on SQL 2000 because different actual server name with server name. my actual server name like "OLTPDB' and Logical Server Name in database by using "Select @@Servername" is "YOUR-jklsfsfss".
to change logical server name we must restart SQL Service,and may high impact with out application. i can't do that, because OLTP run 24 hours.

do you have solution for my issue withour enabled Distribution database?

thanks

Yudhi