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
SP2
> 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
my
> 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.
Steve
> 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.
> Steve
1. SQL Server 2000 SP2 and Windows 2000 SP3
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.
TIA
Kohinoor
2. How to put a variable into Like clause?
3. NW server abend - P.SQL 2000 SP3 client to P.SQL 2000 SP2 server
5. how to connect remote sql server 2000 from my local sql server 2000
7. SQL Server 2000 and Windows 2000 Server SP3
8. DBGrid question/ not using databond controlls
9. Unable to patch sp3 on msde sql server 2000 sp2
10. SQL 2000 SP2 with Windows 2000 SP3
11. SQL 7 SP3 on Win 2000 SP2 w MDAC 2.5 SP2
12. SQL Server 2000 and Windows 2000 SP3
13. Installation of SQL Server 2000 on Windows 2000 SP3 Environment