Reda20

Configure SQL Instance of a MS SQL Server Database from a GIS Server through ArcSDE.

Discussion created by Reda20 on Dec 16, 2013
Latest reply on Dec 19, 2013 by crafty762
Dear,


I am working in a highly configured three tier architecture where I need to connect to a database server.
I have access to the virtual GIS server and my database server.
The database that I want to connect to is an SQL Server 2008 R2 created and stored in the database server.
So, in my GIS Server, after verifying and performing all the necessary prerequisites actions :
- Installing SQL Server Native Client 2012 in the GIS Server.
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q000000m5000000

I have gone through the ArcSDE installation and I checked only the option to "enable geodatabase storage on SQL Server Express"
as soon as MS SQL Server 2008 R2 as well as the database are stored within the Database Server, so as per my understanding, I do not need to install SQL Server Express 2008 on my GIS Server.

Now the problem is as follows:
When I want to enter the Database Server SQL Server Instance Name, I do not have the choice to change it from the dropdown menu(screen.jpg).
What could be the solution?


Technical specifications:
O.S: Windows Server 2012 R2(GIS Server & Database Server).
ArcGIS Desktop 10.1 (GIS Server)
ArcGIS for Server 10.1 (GIS Server)
SQL Server 2008 R2 (Database Server).


Please help asap !
Thank you!

Attachments

Outcomes