2 Node Cluster Active/Active each with an instance
Windows Server 2003
SQL Server 2005
Project: we are changing our SAN from an HP EVA to NetApp and we needed the drives in the cluster moved to the NetApp
Plan: The SAN Admin provisioned drives from the NetApp to both nodes on the cluster, I added the disk resources to the cluster keeping the old disk resources there (for rollback if needed), I then shut off the SQL Server Services, copied all the Database files, Log Files, Program File Folders and MS SQL Server folders from the old drives to the new drives, give the old drive new names, Drive letters and Cluster Resource names and then gave the new disk the name, drive letters and cluster resource names of the old disks. Hope that was not more work than needed. I did this because of the Program File Folders and did not want to spend hours detaching and attaching databases.
Problem: the exact same problem happened on both servers.
A: When I first tried to start SQL Server Service it failed (would not start in a timely manner), I checked the event log and found access denied messages to errorlog files. I tried several permission modifications, but the one that fixed it was to give Users Full control to the whole MS SQL Server folder.
B: I got the service started, but when I tried to access the properties of any of the database I would get an error … disk either does not have sufficient space, there is not enough memory or access is denied. I also tried several permission modifications like taking owner ship, letting folders inherited from parent, but the fix was to give the SQL Service Account full control to the DATA and LOG folders. Once done the database properties and tables could be viewed.
I don’t understand why I had to add this permission to get SQL to work. I copied all these folders from the original EVA SAN Disk drives to the new Net App SAN and all the permission were exactly the same.
Do you guys have any idea what could be the problem?
Your help is appreciated.