2005 SQL Instance on a 2008 SQL SERVER

Posted on 2012-09-20
Last Modified: 2012-09-21
We built a 2008 SQL SERVER and presented three drives from the SAN to it.

There are two 2008 instances on the server that installed perfectly but when you install the 2005 instance it cannot see the drives presented to the server from the SAN.

Can anyone provide me direction on assisting the DBA on this?

Thank you
Question by:DB1947
    LVL 29

    Accepted Solution

    Is this a failover cluster?  Was SQL 2005 installed to be cluster aware?
      (Assuming yes, SQL 2005 won't see the LUNs until the SQL Server is set to be dependent on them in the Cluster Administrator tool.)

    Author Comment

    Yes it's a cluster sorry for not making that clear from the get go.  Well check the config with the DBA team.  Thank you
    LVL 29

    Expert Comment

    by:Rich Weissler
    *whew*  Thank goodness... a cluster was the only option which made sense.  :-)
    (The clustering tool usually ends up in the hands of the OS folks rather than the DBAs, but this kb article might help if they have questions:

    Author Comment

    I have a few good friends that are DBAs and they state that a 2005 instance in a two node 2008 SQL cluster won't work.  Shocking we made the changes you suggested and the 2005 instance can see the drives.  So I'm not sure where I'm getting my wires crossed...  Lets see what the DBA says in its functionality.

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now