SQL 2000 Upgrade
Home > IT Answers > SQL Server > SQL 2000 Upgrade
Hydra
145 pts.
0
Q:
SQL 2000 Upgrade
SQL Server 2000, SQL Server 2005, SQL Server upgrades, SQL Server 2000 to SQL Server 2005 upgrade, Upgrade from SQL Server 2000 to SQL Server 2005
I am upgrading four sql servers 2000 to 2005. If i do an inplace upgrade to the default instance would i need to change any passwords for linked servers, services or sql accounts?
ASKED: May 14 2009  4:23 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
If you do an in place upgrade then all those passwords should remain.

You'll want to have copies of the passwords just in case though.
Last Answered: May 15 2009  0:51 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Hydra   145 pts.  |   May 15 2009  2:15PM GMT

Thank you for your response Mr. Denny, I forgot to mention i have dts packages on the sql server 2000 will thos remain working?

 

Hydra   145 pts.  |   May 15 2009  5:54PM GMT

I also have log shipping. Will the upgrade affect log shipping?

 

Hydra   145 pts.  |   May 15 2009  6:07PM GMT

i should have asked this question first. What should i watch out for when upgrading sql server 2000 to sql server 2005?

 

Hydra   145 pts.  |   May 19 2009  6:47PM GMT

I have log shipping also witll that have problems?

 

Hydra   145 pts.  |   May 29 2009  2:06PM GMT

well this is how my upgrade went on four sql servers:
1. First error I got was in the tools installation part. I chose to install the tools but i did not have the tools folder and the servers folder together.
2. Log shipping broke! I had to fix it by backing up the main database in the primary server then restoing it in a standby mode in the secondary server. then applying all new transaction logs created after the full backup.
3. The rest was a piece of cake.

 
0