SQL Server 2000 and SQL2005

Search Options	close
Search the following clips: All Clips

news science politics food economy art
technology health internet religion psychology

Sign Up Install Learn More Login


	SQL Server 2000 and SQL2005

foxclip

10-27-2006 3:08 PM

205 views

tags:

sql, server, 2005

Add a Comment

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from October 27, 2006

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/7134c5f5-ceb7-4c27-84f6-ed3aa8466ae9/0B81123D-6A4F-4390-A2CF-B5553E6D3C1B/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://www.simple-talk.com/community/forums/permalink/1838/1821/ShowThread.aspx#1821" href="http://www.simple-talk.com/community/forums/permalink/1838/1821/ShowThread.aspx#1821" style="font-size: 11px;">www.simple-talk.com</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://www.simple-talk.com/community/forums/permalink/1838/1821/ShowThread.aspx#1821"><DIV class="ForumPostContentText" id="ctl00_ctl01_bcr_ctl00___PostRepeater_ctl03_PostViewWrapper">
<P>Yes, as Adam says, it is possible, pretty straightforward in fact. You will need to install SQL Server 2000 first if it is not already installed. Then Install SP3 or above on it. Then install SQL 2005 as a named instance. BOL has a handy compatibility chart for the various versions.</p> <P>If SQL 2000 is already installed and working then everything should be simple as long as SP3 or above is installed. This is because, Before SP3, SQL Server 2000 didn't relinquish SQL listener service on port 1434 when SQL Browser Service starts. This meant that the Browser service couldn't start unless you'd stopped SQL 2000 beforehand.</p> <P>Since SP3, all should be well.</p> <P>I'm not sure if there are any snags with installing version 7, 8 and 9 all together on the one machine (handy for a development server that has to cope with existing systems), I haven't tried this, but Microsoft claims that it is possible. What about you, Adam? Have you got all three versions working together?</p> </DIV></blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/0B81123D-6A4F-4390-A2CF-B5553E6D3C1B/blog/" title="blog or email this clip"><img src="http://content8.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>

New from the makers of Clipmarks: Amplify.com - Don't just share the news...Amplify it!

Clipmarks: Home; New Clips; Top Clips; Dashboard

Popular Topics: News; Life; Science; Technology; Entertainment

Get Started: Sign Up; Install Clipping Tool; How Clipping Works; Clip-to-Blog™; ClipSearch

Tools and Resources: FAQ; ClipWeek; Top Clippers; Top Tags; Site Map

About Clipmarks: About Us; Contact; Copyright; Privacy; EULA

Search Options

Today's Top Clips