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?

  • 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, 2012 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, 2012 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). Feb 28, 2012 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, 2012 at 23:42
  • 1
    This would be a good question instead of an answer. Mar 13, 2013 at 14:28

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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