Windows Server woth SQL

[JustWorking]

I don't know if this is the right form to ask this but I didn't know where else to post it. I have windows server 2003 and in it I have SQL server 2000. My question is can I install SQL 2005 over my server and have both 2000&2005? Does this make any problem? Can I have both SQlServers over the same windows server? Thanks in Advance.

[Mycroft Holmes]

You will not be installing 2005 OVER 2000, that is an upgrade, you should install 2005 using a named instance on the server. Then you use the named instance in the connection string in your apps.

[JustWorking]

So if i do this i can have both sql servers 2000%2005 on my machine?

[Mycroft Holmes]

You should be able to, have you Googled to see if you can?

Never underestimate the power of human stupidity RAH

[Ashfield]

Yes, and 2008 as well if you want.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP