Sunday 12 April 2015

How to add new disks to existing SQL Server Failover cluster.

Hello everybody, In this post I’m giving the procedure to add the new clustered disks to existing SQL Server failover cluster.

My Environment: Windows 2008 Enterprise Edition, MS SQL Server 2008 R2 Enterprise Edition

Disk Letters : 'O', 'P', 'R'


Downtime: Zero - '0' ( No service disruption or Zero Downtime)


Lets begin....


My storage team has already given the above 3 LUN's through iSCSI initiator or RDM.


Request from client was to add these disks to the existing windows cluster in order to use them as clustered disks for SQL Server cluster.


Step 1:


To open disk management. Go to RUN--> diskmgmt.msc


You should able to see the disks in offline state on all the nodes available in cluster.







Step 2:


Bring the disks to online in any one of the nodes in the cluster (you can choose only one node). On other nodes it should be in offline mode as we are going to use these disks for failover cluster.






Step 4:


Now the disks are online and unallocated. We have to create a new volume assigning a new drive letter. 


Format the drive with NTFS file system and click finish.


This is how it looks in disk management console.





Step 5: 


Now we are ready to add this disks to windows fail over cluster.


a) click on disk option available on storage pane in fail over cluster manager console

b) It will prompt for all the available disks can be added to cluster
c) select the disks and click OK

Now the disks are added to available storage pool in cluster manager console.


You can also see this disks available from my computer.












Hold on... It's not done yet. you are done with only adding disks in windows cluster. Now we have to add these disk and will be going to use for SQL cluster.


Step 6:


Now Right click on SQL Server and select add storage. It will prompt all the new available disks from storage. Select the disks and click ok.
















Step 7:


Now Right click on SQL Server and select properties of SQL Server. Now we have to add the dependencies for new disks as shown below.


If the disks are not part of dependency list, click insert and add disks and click OK.








You can find the dependency of SQL Server by verifying dependency report.











You can also verify the disks by creating the sample databases on newly added disk as shown below :)









Regards,
Ganapathi varma
Senior SQL Engineer, MCP




Wednesday 1 April 2015

Error: Value cannot be null, Parameter name: viewInfo (OR) Error: Microsoft .NET framework: Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error and attempt to continue

Error Message:
=================================================
Error: Value cannot be null, Parameter name: viewInfo 

(OR) 

Error: Microsoft .NET framework: Unhandled exception has occurred in a component in your application. If you click continue the application will ignore this error and attempt to continue


How to resolve this issue?

Step 1:

The error generally occurs if any missing directory/file in %TEMP% and after that SSMS was not working any longer. The missing file is actually not needed, but the missing directory causes the "Value cannot be null" error.
  



  
Step 2: 

If the below temp and tmp variables are not placed in default location, we have to set them into their default location as shown below and restart the MS SQL services once if required.


C:\Users\Gani>set t
TEMP=C:\Users\Gani\AppData\Local\Temp\2
TMP=C:\Users\GaniAppData\Local\Temp\2


Step 3:

Right click on my computer---> Advanced system Settings environment variables ---> edit user variables and you can see the new path set 

Step 4:
Close the SSMS if opened and connect SSMS again. Now the issue gets resolved and able access the GUI interface without any issues




Appreciate your suggestions. Please comment your feedback and reach me out via email


Regards,
Ganapathi varma