Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
insanepaul
Posting Yak Master
178 Posts |
 Posted - 2008-12-16 : 09:16:38
|
| I have sql2000 already installed but want to upgrade to sql2005. So I installed sql2005 (including notifications, reporting services and everything) at the end it said there were errors but didn't specify them. I rebooted but when i click start/microsoft sql server 2005 the only option is configuration tools. So i'm thinking it hasn't installed properly. So i clicked setup.exe to uninstall it. Then in the 'Components to install' section I click them all. It scanned my system and said that i already have them all. I clicked default instance then next a couple of times now it has enough info to proceed to install.What should i do?Well, |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 09:34:59
|
| Are you doing planning to do inplace or side by side upgrade? If SQL 2000(default instance) is already there ,you have to choose named instance for SQL 2005. |
 |
|
|
insanepaul
Posting Yak Master
178 Posts |
Posted - 2008-12-16 : 09:45:28
|
quote:
Originally posted by sodeep
Are you doing planning to do inplace or side by side upgrade? If SQL 2000(default instance) is already there ,you have to choose named instance for SQL 2005.
I wasn't sure so I planned to do it side by side then import databases into it. But I've been told to now upgrade 2000 to 2005. Now that I've tried to install 2005 I can't do anything other than uninstall sql 2005 from the control panel. In the install wizard in the 'Instance Name' I have just clicked 'Installed instances' all of which are 2005.When I run my app, it reads from the database so it's still around somewhere. So I'm stuck what to do. Should I make backups of the database (where are they? I don't have a backup folder in MSSQL folder just install folder) or can I use control panel to manually uninstall each component? Please can I have some advice. |
|
|
|
|
|
|
Installing sql2005