Please help me on this one. my office hour yesterday was gone and haven't solve the problem. This is what i've noticed.
on services.msc cannot start the MSSQL server and sql server agent and others only SQL Server browser works. I've opened SQL server configuration manager and started from there it also didn't work..change the log.on account of each services..didn't work also. Now we have two SQL that was clustered and i guess the database of the SQL was connected to the SAN with physical disk e:. I've opened the Cluster Administrator and find out that physical disk e: is offline..tried to make it online but it won't....it's not shown either on the my computer the physical disk e: and also in the disk management. going to properties on the physical disk e: the location is drive c and d...tried to create another physical disk pointing to the SAN storage but only 3 out 5 storage are shown..i believe that the others not shown is the one the points to physical disk e:. open the HP SAN viewer and all of the storage has a status good.
i'm guessing that why the MSSQL Server did not start because it cannot locate the physical disk e of the SAN...but im losing anymore options...Please help expert.
a big thanks