Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have OLTP Databases on SQL Server 2000 on my client's Prod Server. Planning to create Data Warehouse on the same Server but use SQL Server 2012. Can I install without any issues?

share|improve this question
    
Thank you everyone for valuable input. This really helps. Got the point loud and clear. Will definitely thoroughly test with Separate instances and then move to production. You might see me posting more questions if I run into issues. –  user21729 Mar 25 '13 at 16:34
    
Wooooee.. So much negativity.... Why all the down-voting? I feel we have answered the question. Chill out a bit. –  StanleyJohns Mar 28 '13 at 20:17
    
@StanleyJones I don't see any negativity. The question has 2 upvotes. If you are referring to the answers, people probably think that those answers are either wrong or do not really answer the question. –  ypercube Mar 29 '13 at 20:49
add comment

6 Answers

As stated on MSDN side-by-side installation of SQL 2012 with earlier version is supported. However take note of the instance name, if your SQL 2000 instance is a default instance then your SQL 2012 install will have to be a named instance.

I would take note also that some issues may occur with SQL 2000 tools as your SQL Server 2012 installation may attempt to upgrade any shared components it finds. Although I don't know what of SQL 2000 would still exist in SQL 2012.

Now, my opinion and not the opinion of StackExchange, or my dog...I would not suggest configuring a side-by-side install with a SQL 2000 instance. Not knowing the setup, I would highly doubt the server configuration of a SQL 2000 instance is very well suited to what Microsoft suggest for a SQL Server 2012 installation. Especially considering the fact that SQL Server 2012 is only supported on Window Server 2008 SP2 and higher. This all depends on how old the server is and such but just my opinion.

share|improve this answer
add comment

You should be able to run separate instances of those versions on the same server without issue, though I usually recommend against doing that in production environments as I have experienced problems in our dev environments with updates sometimes refusing to apply (I forget which, but for us one of the SQL2005 service packs refused to install on the machines that had both SQL2005 and SQL2008 instances present).

SQL2000 does not reach EOL until later this year but it is in the "extended" support period, see http://support.microsoft.com/lifecycle/?LN=en-us&x=14&y=10&p1=2852, so it is likely that MS have tested the combination as part of their release testing process but if you do have problems that are not security related you'll end up paying for resolution if you need to refer to MS support. I would therefore recommend fairly rigorous testing of your own before you try this combination in a production environment. Also see Shawn Melton's points regarding SQL2012's system requirements, which may mean that your old SQL2000 box is not suitable even though it is theoretically possible.

share|improve this answer
add comment

Sure you can. Just note that you have to install an older version first, and then install the newer one

share|improve this answer
add comment

I tried to install SQL Server 2012 and 2014 on the WIN2008R2 server with Sql Server 2000 Desktop Edition named instance installed. The installation process failed showing error:

TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: '.', hexadecimal value 0x00, is an invalid character. Line 1, position 444345. Error code 0x84B10001.

After taking a brief look to the log files I concluded that there may be some unexpected values in the registry with SQL2000 that cannot be processed by SQL2012/14 installation process.

share|improve this answer
add comment

I have not tried your exact case, but you will certainly experience some problems (deprecated functions, sql instructions...). You will also have to name your instances carefully.

I would much prefer having multiple instances with the same version. If you wish to migrate your 2000 database, keep in mind that according to the MSDN, the migration from Sql Server 2000 to Sql Server 2012 is not supported, as you need an intermediate step, usually Sql Server 2008R2.

[25/03/2013 Edit] my initial message looked a bit off-topic.

share|improve this answer
2  
The OP didn't ask about migration, but about side-by-side co-existance ... –  marc_s Mar 25 '13 at 11:36
add comment

Yes, you can install SQL 2000 and SQL 2012 as separate instances on the same machine without issues.

share|improve this answer
2  
Can you expand and clarify this answer? Why will there be no issues? Have you tested it? Is there a MS paper or web page that reassures of this? (And I don't object to the answer but longer answer are usually more accepted here). –  ypercube Mar 25 '13 at 16:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.