2005 SQL Instance on a 2008 SQL SERVER

Posted on 2012-09-20
Medium Priority
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
  • 3
  • 2
LVL 30

Accepted Solution

Rich Weissler earned 2000 total points
ID: 38419040
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

ID: 38419109
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 30

Expert Comment

by:Rich Weissler
ID: 38419170
*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:  http://support.microsoft.com/kb/295732.)

Author Comment

ID: 38419192
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

ID: 38421784
Thank you

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

807 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