Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster.

I've only done standard install before and I don't know how to go about it.

Does SDE have to be install on each of the cluster servers?

Does it have to be installed outside the cluster , on a seperate machine?

share|improve this question
    
It's similar to the 2005 "ArcSDE clustered installation the software should be installed on the system disk of each node." esri.com/systemsint/kbase/docs/arcsde-sqlserver.pdf –  Mapperz Feb 24 '12 at 21:54
    
SQL 2012 (Enterprise Version) has Geo-Clustering and it much faster than 2008 R2 - microsoft.com/sqlserver/en/us/future-editions/… –  Mapperz Feb 24 '12 at 21:56
1  
@Mapperz Is it relevant to the question? I believe that SQL Server 2017 (Universe Version) will be faster than SQL 2012 (Enterprise Version). –  r.pankevicius Feb 28 '12 at 21:38
    
@Mapperz after call to ESRI Technical Support. The document esri.com/systemsint/kbase/docs/arcsde-sqlserver.pdf is the most recent that they have. –  Dom Mar 2 '12 at 23:42
1  
This would be a good question instead of an answer. –  Kirk Kuykendall Mar 13 '13 at 14:28

1 Answer 1

up vote 3 down vote accepted

Provided you have an existing R2 cluster...

Create a domain service account and give it "Log on as a service" on each node. Open port 5151 in the Firewall of each node for the SDE service. Install ArcSDE on both nodes. ( Do not Run post- install on second node!) Run the Post Install wizard and select complete. Use the cluster sql name\instance to create the DB and repository. Complete the authorization wizard using the sql cluster name. When creating the service enter the domain account info from earlier . You will also use the DB name created in the earlier wizard. Use the SQL clustername\Instance for "SQL Server Instance name" and SQl Cluster name for "Server name". After post install is complete make sure the service starts, and that your domain account is starting it. Then stop the service and change startup to "Manual".

Run post-install on second node and install the service only using settings in previous step. (Do not start the service when prompted) Change service to "Manual"

Open Failover cluster manager and right-click the SQL Server () and "Add Resource" followed by "Generic Service"

Select the ArcSDE service and finish the wizard.

Right click the newly created resource and select properties .

Delete contents of the startup parameters box Add SQL Server Agent as dependency.

Optional if using SQL for other purposes besides ArcSDE Uncheck both boxes under "Policies tab" so the SDE service will not cause a failover.

Right click the SDE service resource and bring online. If it is successful test failover.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.