replicating SQL 2000 to SQL 2005 database

Hi All,
I am having some memory issues and SSL issues with my SQL 2000 box. I had
SQL 2005 installed on this box, I uninstalled it when I had a crash of my
production server. I installed SQL 2000 on this box and moved everything
over. Everything including my replication was working fine then all of a
suddend we were not able to connect due to SSL issues, then we started
getting Out of memory issues. in my research I have found a hot fix for SQL
2000, and I installed it. the fix was for the memory issue in SQL 2000 but I
dont think it will completely cure my server. Everything I read also said
SQL2005 SP1 fixes these issues.
Now for the question if your all still with me
I have my 20 locations running SQL 2000 and I would like to upgrade my main
server to SQL 2005. Are there any known issues doing this? My publisher and
Subcscribers wil be coming from this SQL2005 machine.
TIA,
Joe
On Feb 12, 4:05 pm, jaylou <jay...@.discussions.microsoft.com> wrote:
> Hi All,
> I am having some memory issues and SSL issues with my SQL 2000 box. I had
> SQL 2005 installed on this box, I uninstalled it when I had a crash of my
> production server. I installed SQL 2000 on this box and moved everything
> over. Everything including my replication was working fine then all of a
> suddend we were not able to connect due to SSL issues, then we started
> getting Out of memory issues. in my research I have found a hot fix for SQL
> 2000, and I installed it. the fix was for the memory issue in SQL 2000 but I
> dont think it will completely cure my server. Everything I read also said
> SQL2005 SP1 fixes these issues.
> Now for the question if your all still with me
> I have my 20 locations running SQL 2000 and I would like to upgrade my main
> server to SQL 2005. Are there any known issues doing this? My publisher and
> Subcscribers wil be coming from this SQL2005 machine.
> TIA,
> Joe
I think I've seen this before... the ssl certificates are created by
domain controllers. In Active Directory's meta-data you have to delete
the oldest entry for the domain controller that was used to
authenticate your sql server account.
|||Thank you I will look into this.
"mrdba2001@.gmail.com" wrote:

> On Feb 12, 4:05 pm, jaylou <jay...@.discussions.microsoft.com> wrote:
> I think I've seen this before... the ssl certificates are created by
> domain controllers. In Active Directory's meta-data you have to delete
> the oldest entry for the domain controller that was used to
> authenticate your sql server account.
>