Home > IT Answers > SQL Server > SQL 2000 Upgrade
0 pts.
 SQL 2000 Upgrade
SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server upgrades, 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?

Software/Hardware used:
ASKED: May 14, 2009  4:23 PM
UPDATED: May 29, 2009  2:06 PM
RELATED QUESTIONS
Answer Wiki:
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 Wiki Answer Submitted:  May 15, 2009  12:51 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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
 0 pts.
 

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

Hydra
 0 pts.
 

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

Hydra
 0 pts.
 

I have log shipping also witll that have problems?

Hydra
 0 pts.
 

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.

Hydra
 0 pts.