2005 Cluster problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

2005 Cluster problem

Hi All
I am new to sql 2005 clustering i got the below error while installing sql 2005 on cluster mode. I got the below error in node2. "SQL Server Remote Setup .job" (setup.exe) 5/10/2007 4:30:04 PM ** ERROR **
Unable to start task.
The specific error is:
0x80070005: Access is denied.
Try using the Task page Browse button to locate the application.
[ ***** Most recent entry is above this line ***** ] Please help me. If any body have installation steps please provide me. Thanks
S. Ramesh
Make sure that:
– you login and install with an account that is administrator on both nodes
– the remote registry service is started in both nodes.
I am able to login both system using administrator account.
the remote registry service is started on both systesm Thanks
S. Ramesh
Take help from this kBAhttp://support.microsoft.com/kb/910851 Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Hi, the problem is resolved. I have istalled from network drive… But now i have another one question…I have one shared disk which is called drive R. while doing setup, where can i place my datafiles? Shared device (R) or C drive? Thanks
S. Ramesh
I have 3 drives c, h, r. R is shared device. I have installed sql programs to H drive. Where can i place system dbs? H drive or R drive? Thanks
S. Ramesh
You should always place the Quorum on a shared volume. How big is drive R? Never place the Databases on C: as it is generally used for OS files. Raulie
It depends on what kind of configuration you have for these drives… If you are not seperating the data and log files then you can place on either of them… and make sure you have enough space for tempdb to grow… Where is quoram? do not put any database file on quorum drive…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

I would go with H for system databasesand R for user databases.
quote:Originally posted by sramesh I have 3 drives c, h, r. R is shared device. I have installed sql programs to H drive. Where can i place system dbs? H drive or R drive? Thanks
S. Ramesh

Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I would not place system databases on local storage, I would place all DBs especially system on a shared cluster disks and would want them always on shared storage in the SQL Resource Group. Sramesh – As a general rule of dumb create seperate volumes on shared storage, for the Quorum I would prefer to use the letter "Q:" on shared storage and only place the Quorum in this location. Place all Databases on a seperate shared volume. Are you on a SAN???? Keep in mind before you even think about clustering anything you must have storage requirments defined and ready to avoid extra work. Raulie
Hi thanks.. I need one more solution….
I have configured two server. I want add one more node to this clustering. How it is possible?
The third node in cluster group without sql installation. How could i install sql server in the third node? Thanks
S. Ramesh
http://technet2.microsoft.com/windowsserver/en/library/8e8bd392-62b5-4a76-9145-ac1eb7765cbd1033.mspx?mfr=true Raulie
]]>