Installing different SQL Server versions on one machine

by
Greg Low

Different SQL Server versions can be installed on one machine, learn how and get the best practices for SQL Server installation and compatibility.

Can you install two different versions of SQL Server on the same box?

Yes you can. While you theoretically can install them in either order, I'd always suggest installing the software in the order it was released: SQL Server 2000 first, then SQL Server 2005.

Step 2 of 2:

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor

Check out this helpful tip:

Compatibility of SQL Server 2005 and 2000 coexisting
So, you've decided to upgrade your databases to SQL Server 2005. Database expert Michelle Gutzait highlights some issues that may arise when installing a SQL Server 2005 instance on your SQL Server 2000 machine. Also discussed are options for interaction between the two versions, such as: linked servers, multi-server administration and log shipping.

This was first published in September 2007

Dig Deeper on Microsoft SQL Server Installation

All
News
Get Started
Evaluate
Manage
Problem Solve

Finding the right problem for SQL Server 2014's in-memory OLTP

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Pricing out the new Windows Azure SQL Database

Related Q&A; from Greg Low

SQL Server id permission to create and modify tables

A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading

Is it possible to find disabled indexes in SQL Server 2000?

If you're working with SQL Server 2000 and trying to find a disabled index, here's something you should know.continue reading

Schedule stored procedure and save output to network drive

Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Analytics applications get governance, customer data protection

Companies such as Intuit are taking steps to try to ensure that customer data analytics initiatives don't give them a black eye ...

How big data analytics tools can help your organization

Expert David Loshin examines the different types of big data analytics tools available today, and takes a look at how each can be...

Enova's chief analytics officer on managing an analytics team

Joe DeCosmo, chief analytics officer at Enova International Inc., discusses his approach to building and managing the financial ...

SearchDataCenter

Matching applications to the right converged technologies

Users in the data center share how the converged technology they chose -- from hyper-converged infrastructure to appliance -- ...

Purging zombie servers saves AOL money, energy

AOL shares the lessons it learned from a project to rid its data centers of 14,805 zombie servers that saved the company about ...

Bright data center ideas that lacked staying power

The data center has seen its fair share of failed attempts to uproot traditional thinking. New ideas for power, cooling and ...

SearchDataManagement

Aerospike NoSQL DBMS overview

The Aerospike open source, in-memory NoSQL DBMS is a key-value data store that enables applications to deliver high performance ...

Apache Spark architecture quiz: Do you know Spark?

Apache Spark is an open source processing engine designed for use in big data applications. Take this quiz to see if you're up to...

Which in-memory DBMS best fits your company's needs?

Database expert Craig S. Mullins examines some top in-memory DBMS software offerings to help you determine which is the best fit ...

SearchAWS

New AWS instances drive down previous-generation prices

New AWS instances will mean cost savings for IT pros, even if they don't purchase instances from the new M4 line.

Amazon Elastic File System roadmap details revealed

AWS officials discussed the features customers can expect at the launch of AWS EFS, as well as what's still on the roadmap.

Optimizing your AWS costs

Doing business in AWS is easy; understanding what it costs you is not. Just when you think you understand your AWS pricing ...

SearchOracle

Oracle Enterprise Manager 12c R5 focuses on the hybrid cloud

Release 5 of Oracle Enterprise Manager 12c adds new features for managing hybrid cloud environments. Oracle hopes OEM 12c R5 will...

Oracle ADDM helps resolve SQL performance problems

An Oracle DBA describes how he uses Oracle ADDM to resolve SQL performance problems. ADDM is his go-to tool for finding problem ...

Solaris 11.2 proves to be a cloud-worthy Oracle OS

Oracle's Solaris 11.2 includes cloud-ready features such as a complete OpenStack distribution, kernel zones, Unified Archives and...

SearchContentManagement

Online communities create social 'stickiness,' say experts

While social media platforms like Twitter and Facebook may get audiences to the door of a corporate website, online communities ...

Office 365 Groups part of Microsoft strategy to spur cloud adoption

Microsoft's Office 365 Groups strives to make it easier for teams to collaborate and share documents. But if you're not in the ...

OneDrive for Business and SharePoint fill different niches

Microsoft is unveiling new OneDrive for Business features in a bid for enterprise cloud file-sharing turf, while leaving more ...

SearchWindowsServer

Patch Tuesday fixes focus on Office, IE, Exchange Server

June proves less buggy for Microsoft as Redmond issues only two critical patches targeting Internet Explorer and Windows Media ...

Five quick tips on Microsoft Azure management

Strapped for time? Get the lowdown on Azure Pack, Microsoft Cloud Platform System and more in this fast feature on Azure.

A walk-through of Windows Server 2016 Group Policy

Group Policy users will appreciate that the structure hasn't changed in Windows Server 2016, but there are a few new policies ...

Dig Deeper on Microsoft SQL Server Installation

E-Handbook

Related Q&A; from Greg Low

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: