I've removed all files relating to SQL Server 2005 from my desktop. Control Panel > Add remove programmes. I've noted that SQL server 2005 files don't have the 2005 included unlike 2000 & 2008? I've removed all SQL Server files accept for the VSS writer one which was associated with 2008.
Next, I've run the install and just follow the step on the wizard. I've ensure that when I got to the feature selection screen that I selected all the client components.
Grrr, just had the install blocked due to 2008 being on there. Now have to un-install that lot too. Can't just install as said is running, and couldn't just end the service via task manager as can't locate the instance.
Being dumb, the SQL Server 2005 install was stopping the 2008 un-install. Have cancelled the install and now run the un-install. Takes a while so go and have a coffee.
Great, now lets re-do the 2005 install.
I've opted for mixed installation mode within one of the screens to set up a user now rather than later.
Oh joy, again the install has failed... must have some thing else that needs removing.
Tried a new install with a new instance name, early indications bad :(
Further investigation reveals that there can be issues from the registry keys. So I've run regedit and gone to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ and I've tried to delete what I can.
This still didn't work... so I left it for a couple days!!!
Right fresh start. First I removed all traces of SQL Server from:
- Add/remove programmes
- Programme files
- Local users settings
- and registry as indicated on this site
Make sure you install the express version with tools as otherwise you get a lot of extra agro trying to get SQL Server Management Studio installed.
To summarise:
- Try to upgrade in normal way if not work use the following:
- Remove programmes
- Remove files
- Delete registry keys
- Install 2005 or Install 2008
- Update Config Settings to allow TCP/IP and correct port etc.
No comments:
Post a Comment