SQL 2005 and GIS server

Question

SQL 2005 and GIS server

SQLQuest29

SSCrazy Eights

Points: 8264
More actions
January 16, 2009 at 7:57 am

#205113

Hi all,
I am not sure whether this is a right post to post in this section !
I am new to SQL 2005. My project manager has told me to install SQL 2005 enterprise edition (which i did), then he told me to install spatial layer on it (I dont know how to do it) and then he told me that SQL server and the ArcGIS server should talk to each other (does this mean to set up a link server between the two).
Please help me and it will be good if some documentation is provided on how to install spatial layer on SQL 2005 and creating linked server between sql 2005 and ArcGIS server.
Thanks !!!:)
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Shabba SSCertifiable Points: 5007 More actions · Answer 1

Hi SQL_Quest,

If only it were that simple... ESRI GIS software tends to be quite specialised and requires SQL to be configured in a certain way. Have you checked out the ESRI website? (see link below) You should find what your looking for there in terms of ArcGIS installation guides etc, if not give them a call.

http://www.esri.com/software/arcgis

We are a large ESRI site but thankfully we have a dedicated GIS team who support and generally lookafter ArcGIS and other ESRI products. As for me I just look after the SQL side of things!

I Will try and help where I can but my knowledge of ArcGIS is somewhat limited... i'm not aware of any 'linked servers' in our configuration.

Cheers,

Mark

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

SQL_Quest

what version of ArcGIS are you using?

The spatial layers are part of the ArcSDE engine. You can use direct connect to connect to the database from the SDE engine rather than install SDE on the database server.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 3

Hi SSC-Enthusiastic

I am told to install SQL enterprise edition and after that the SQL server and the ArcGIS server should talk to each other. So that means that SQL server should be linked with the ArcGIS server, so that the user can get the data from both epending upon the request.

So for that I am thinking that ArcGIS server should be as a " Linked Server".

Correct me if I am wrong.

Thanks for your help.. but I need some in detail .. as I am new to ArcGIS ...and have started newly my career as SQL DBA...

Any help is appreciated !!!

Thanks 🙂

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

we use SQL2005 std edition! What version ArcGIS are you using?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Shabba SSCertifiable Points: 5007 More actions · Answer 5

Interestingly ESRI's website has no reference of "Linked Servers" and ArcGIS on their website. Have you been to their website downloaded installation guides etc? Why not call ESRI themselves or the 3rd party who supplied the software to you?

It would make sense to have the SQL Server in place before you attempt to install ArcGIS as ArcGIS requires a SQL repository for it's database.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 6

Hi,

I will be using SQL 2008 enterprise edition. and presently we are using 9.2 version of ArcGIS.

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 7

Mark (1/16/2009)
Hi SQL_Quest,
If only it were that simple... ESRI GIS software tends to be quite specialised and requires SQL to be configured in a certain way. Have you checked out the ESRI website? (see link below) You should find what your looking for there in terms of ArcGIS installation guides etc, if not give them a call.
http://www.esri.com/software/arcgis
We are a large ESRI site but thankfully we have a dedicated GIS team who support and generally lookafter ArcGIS and other ESRI products. As for me I just look after the SQL side of things!
I Will try and help where I can but my knowledge of ArcGIS is somewhat limited... i'm not aware of any 'linked servers' in our configuration.
Cheers,
Mark

Hi Mark,

I will also be looking at the SQL side things as we have a specialized ArcGIS specialist. But being a SQL DBA, I have to set up a server having SQL 2008 enterprise edition and then have SQL and ArcGIS communicate with each other. How have u achieved this... can you explain in more detail.

Thanks for your help !!! 🙂

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 9

Perry Whittle (1/26/2009)
we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008

hi Perry Whittle,

can you explain for SQL 2005 how it works and I have checked ESRI website, but they are having the latest 9.3. I just confused on how to make SQL 2k5 or 2k8 to talk to ArcGIS server. Is there any special setup required for that. You can explain regarding 2005.

Thanks for your help 🙂

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

joao.rolo.sa Valued Member Points: 59 More actions · Answer 10

Hello,

Im Almost certain, that you need to use ArcSDE to make Sql / Oracle talk to ArcGIS Server.

Meaning SDE is some cloud Between the DBMS and Sql Server

Cheers

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 11

joao.rolo.sa (1/27/2009)
Hello,
Im Almost certain, that you need to use ArcSDE to make Sql / Oracle talk to ArcGIS Server.
Meaning SDE is some cloud Between the DBMS and Sql Server
Cheers

Hi,

Thanks for the reply... but can you give some more details on the installation of ArcSDE ... i.e first I have to install sql and on the top of it I have to install ArcSDE... am I correct ? .... are there any specific settings to be done while installing ArcSDE ... can you prove some steps or documentation ...

Thanks... 🙂

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

steve block SSCertifiable Points: 7698 More actions · Answer 12

ArcSDE is installed on the same server as the Sql Server. It sounds like you need some ArcSDE training. Check into the class "ArcSDE Administration for Sql Server". http://www.esri.com/training

I would not attempt to set this up without proper training.

Steve

Perry Whittle SSC Guru Points: 234013 More actions · Answer 13

sblock (1/27/2009)
ArcSDE is installed on the same server as the Sql Server.

in an ideal world no. In v9.2 SDE is part of the ArcGIS server suite and the SDE libraries are installed on the application server. You then use direct connect to access the database. You don't want any apps running on the sql server.

Install and configure the ArcGIS software according to the documentation (which you should have with the software)

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

steve block SSCertifiable Points: 7698 More actions · Answer 14

Whether you install ArcSDE on the Sql Server machine as a service and use an application server connection or use a direct connection from another machine with ArcGis installled, you still have to set up the spatial database on Sql Server with what Esri calls Post Installation. This creates a database, sets up the sde user, etc.

Steve