I think your best option is upgrading from SQL Server 2000 SP2 to SP3.Quote:> I have attempted to register a Sql Server 2000 SP3 on my SQL Server 2000
> Server and each time I receive the server does not exist or cannot connect
> error. I am able to ping the system in which the sp3 server is located so
> is not a connectivity issue. My connection is over a VPN using PPTP and
> intention is to conduct replication between the two servers. Replication
> have worked so far with most of my users but not with this one. The only
> common denominator is the fact that this is a sp3 server. Are there any
> suggestions on how to solve this problem? Short of reinstalling the Sp3
> server to bring it back to sp2, I don't see a solution to the issue.
> Upgrading the sp2 server to sp3 is not an option.
> I think your best option is upgrading from SQL Server 2000 SP2 to SP3.
> Replication relies heavily on stored procedures and the SQL Server agent,
> ideally you'd want your servers at the same SP level.
We wish to install SQL 2k SP2 on Windows 2K SP3. Are
there any know problems with this ?
I could'nt find information on such a compatibility.
Any detail would be greatly appreciated.