August 19, 2009 at 8:28 pm
We currently have a server running SQL2000 and SQL 2005 Express. We now are going to install the standard edition of SQL 2005. I realise I will have to install it in a new named instance and have read that SQL 2000 will need to be patched to at least SP3. Also have heard that I will need to uninstall the Express version of the management tools otherwise the full tools will not be installed.
Has anyone else have any experience with doing this or can see that it might be a problem. Should I create a virtual server and install it there? Am I asking for trouble doing this?
August 19, 2009 at 9:04 pm
I have installed all of the versions i.e. sql 2000, 2008 express, 2008 standard and enterprise on my testing machine, I do not see any problems. You just need to make sure that you select all the options and tools you need while installing. Might be I have not used the tools that you are referring to.
Swarndeep
http://talksql.blogspot.com
August 20, 2009 at 5:44 am
I've had a problem with SQL 2000 Enterprise Manager becoming corrupt when 2005 std was installed. The database installs were all fine, just the sql 2000 tools needed sorting out.
August 20, 2009 at 4:17 pm
What did you have to do to sort out the tools?
August 21, 2009 at 1:15 am
Enterprise Manager wouldn't load up. It came up with a blank error message and closed. In the end Enterprise Manager was reinstalled. The 2005 Management Studio worked ok and of the three servers that we have running multi versions, only one had this problem.
August 21, 2009 at 6:40 pm
For me, I've never used Enterprise Manager on a machine once I've installed the full SSMS from SQL 2005 or SQL 2008; SSMS has everything I've ever needed from Enterprise Manager and/or Query Analyzer. So it may not matter to you if it gets 'corrupted'.
The only thing sometimes missing (for me) is DTS support, which you have to install separately (download from Microsoft).
I may be just lucky because of the kind of systems I support (all small ones < 50 users).
But I've had SQL 2000, SQL 2005 and SQL 2008 (and maybe even SQL Express) all installed on the same machine without any trouble at all. Except for the extra memory required of course 😛
/Ryan
August 22, 2009 at 3:32 am
These were testing servers that we had multi versions on and even though SMSS has pretty much everything a number of users weren't happy having to use a new tool just yet. We pretty much try to get everyone to use SMSS from SQL 2008 now.
August 22, 2009 at 9:56 am
You may try steps from the following link.
http://geekswithblogs.net/TimH/archive/2005/08/09/49716.aspx
Swarndeep
http://talksql.blogspot.com
August 23, 2009 at 5:28 pm
Thanks to all who have replied. It has given me confidence to attempt this after suitable backups of course.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply