1
vote
0answers
66 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
2
votes
0answers
156 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
3
votes
2answers
89 views

Can't open ArcCatalog Database Connection SQL database Tables with field names greater than 31 characters

I am using SQLEXPRESS as a test environment. My issue: I have a database connection in ArcCatalog to a SQL database. Some tables in the SQL database have field names greater than 31 characters and ...
0
votes
0answers
43 views

What is this ArcSDE 10 for SQL server 2008 Enterprise sp2 64bit setup error?

I setup ArcSDE 10 for SQL Server 2008 Enterprise SP2 64 bit but error. I'm using: ArcSDE 10 for SQL server 64 bit; Sql Server 2008 Enterprise SP2 64 bit; Window Server 2008 Enterprise SP1 64 bit; ...
0
votes
0answers
50 views

using Arcgis silverlight viewer, how to autoload a layer of Lat/Long points stored in MS SQL 2008

I use Arcmap to register a layer into ArcGIS server whose source data is spatial points stored in MS SQL 2008. Everything works fine until a new entry is added into the database table, it doesn't ...
0
votes
1answer
502 views

ArcGIS for Server 10.1 (including ArcSDE) and SQL Server 2012 problem with Create Enterprise-Geodatabase

i have the following server system: -Windows Server 2008R2 -SQL Server 2008 (SDE10 Enterprise Geodatabaees) and SQL Server 2012 on the the same machine -ArcSDE Application Server 10 First - Is that ...
5
votes
1answer
130 views

What exactly does the ArcGIS Server service do? SQL Server service?

What is the purpose of the ArcGIS Server service? It's not used at all to do a direct connect to an SDE database, right? That would just use the SQL Server service? While we are on the ArcGIS Server ...
0
votes
0answers
159 views

Upgraded ESRI .NET ADF application (9.3 to 10.1) intermittently missing service issue

I also asked this question on the ESRI forum but I'm not sure if anyone will see it through the tumbleweeds over there. I had an application based on the .NET Web ADF originally built in 9.3. The ...
2
votes
0answers
206 views

Publish ESRI Feature Services from spatial view on ArcGIS Server 10.1

I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for ...
0
votes
3answers
75 views

database server connection to MSSQL Server with ArcCatalog not possible?

I have a MSSQL Server where my geodata is held. In the ArcGIS Docs, it says... "To administer ArcSDE geodatabases for SQL Server Express, you can also connect to these geodatabases by first making a ...
0
votes
1answer
97 views

How can i generate parcel extracts on demand through a webservice

Ok, i need to generate parcel extract documents on demand. The backend is Arcgis 9.3.1 on SQL server 2008. I would like to build a webservice (C# .Net) on the server that generates these extracts. My ...
0
votes
0answers
68 views

Why does my feature service allow add and delete but can't update attributes

I have published a FeatureService in ArcGIS 10.1. I connect to the service with this JSAPI sample: Using the Attribute Inspector. With this sample I can add features and I can move or delete ...
0
votes
2answers
157 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
2
votes
2answers
2k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
1
vote
0answers
214 views

Why does a geoprocessing service fail every other time it is run?

I have a ArcGIS Server 10 geoprocessing service right now that takes in a string and runs a parameterized query to SQL Server 2008R2 through pyodbc. The service works, but only every other time. I can ...
0
votes
1answer
55 views

number of arcgis server users for CAL-based backends

The licenses for our organization's MS SQL and ArcGIS Server are such: MS SQL: CAL ArcGIS Server: enterprise Are the number of users that can be served still limited to the number of CALs present in ...
2
votes
2answers
685 views

ArcGIS Server 10.1 and SQL Server 2012 SP1

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
1
vote
1answer
410 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
4
votes
1answer
454 views

What licenses are needed for ArcGIS Server and SDE (vs a FOSS setup)?

Does anyone know where I could find a cost breakdown for an ESRI/Microsoft GIS server and database setup? I'm trying to figure out all the costs associated with an ArcGIS Server/SDE sitting on top of ...
2
votes
2answers
410 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
4
votes
1answer
337 views

How to register a Stored Procedure in ArcSDE?

I just registered a SQL Server view with ArcSDE through sdetable -o register [...]. I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view? EDIT ...
4
votes
1answer
151 views

How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
2
votes
1answer
271 views

Live update (the database & Map) possible in ArcGIS Server 10.1?

I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server.. When I get the update say 100 records then I need to ...
1
vote
0answers
173 views

One-way ArcGIS replication copying __ATTACH tables instead of base tables

I'm trying to get one-way replication working in ESRI ArcGIS 10. Here's a quick summary of the steps I followed: Open map in ArcMap with the relevant data layers I want to replicate Choose Create ...
1
vote
2answers
2k views

ArCGIS Server 10/10.1 And Sql Server 2008

Is there any compulsion that SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine and is it possible to install SQL server 2008 and ArcGis server on separate server ...
2
votes
2answers
696 views

ArcGIS Server simple link with SQL Server database

I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps. Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
1
vote
1answer
250 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
0
votes
3answers
678 views

How to load spatial data into ArcGIS Javascript API application from SQL Server 2008?

I have geometry data in SQL Server 2008 R2. How do I load that spatial data using the ArcGIS Javascript API?
3
votes
1answer
2k views

Why does “Add Database Server” in Catalog 10 allow only ArcSDE Personal or Workgroup databases?

Arc Catalog 10 - ArcInfo - Database Severs - Add Database Server: "Add an ArcSDE Personal or Workgroup database server by typing in the SQL Server Express instance you wish to connect to." I want to ...
1
vote
0answers
280 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
1
vote
1answer
767 views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
5
votes
2answers
1k views

why is a gdb query WHERE clause invalid according to the ArcGIS REST API?

Update: This only occurs when the layer being queried has a join. It doesn't matter if it has a join to a different database or not. And the query that fails is not trying to access columns in the ...