Latest Contributions by MarcoBoeringa

I can say that the people administering this SQL Server are pointing to ESRI as the problem because they cannot log into the renamed geodatabase using the logins/passwords that the original production sde geodatabase had and they think that ESRI security is causing the problem.  I don't even know how to respond to that. ESRI geodatabase security = RDBMS security = (most likely in case of SQL Server) Windows Authentication So if you can't login after recreating your database and nothing else changed, you've taken the wrong path (as Vince already told you: you can't rename the database with an established geodatabase in it). The path you probably should take if you really need to "rename" (note the quotes): 1) - Create a new database using the new name in your instance (or if desired an entire new instance) 2) - Re-create any database users / roles etc. of the old database you wished to "rename" in the new database 3) - Use the "Enable enterprise geodatabase" tool to create a new ArcSDE Repository in the new geodatabase (Alternatively you could have used the "Create enterprise geodatabase" tool to do steps 1 and 3) 4) - Copy over any datasets (Feature Datasets / Feature Classes) from the old geodatabase to the new one, or use One-Way Geodatabase Replication to do it. There may be some headaches here, especially if there are outstanding versions and editing is going on. See also Understanding distributed data Vince can probably give you more details and correct/supplement what I wrote. ... View more

I understand.  I was hoping to confirm that your DGNs are read correctly.  I can tell you that in the upcoming release, my test cases of DGN BSplines work correctly. You are probably already familiar with this, but this older thread has some more detailed info about B-spline issues (e.g. see remark Ray Carnes - ESRI Technical Marketing) and some test datasets: http://forums.esri.com/Thread.asp?c=93&f=982&t=266100 ... View more

Jamal, Any users not allowed to export data, should probably not be using ArcGIS for Desktop at all... there is just to many access points to data and tools for data conversion. Instead, they probably should be using some custom web-application to access non-editable ESRI Image or OGC WMS services serving out just images and not true features. By the way: you can access these webservices too through the ArcMap interface. This might be a part solution: make the Feature Classes only directly accessible to the geodatabase administrator, and than create ESRI Map / Image or WMS webservices using ArcGIS for Server to allow access to other users from within ArcMap. If the users do need editing capabilities, than a custom web editing application using ESRI Feature Services or OGC WFS-T (transactional WFS) might be in order, but that would still allow access to feature geometry data somehow, but at least not directly from an interface like ArcGIS for Desktop with its many options... ... View more

To confirm, a direct connect is sufficient for a feature service - as long as the database supporting the feature service has the SDE tables within it, correct? Karyn, ArcGIS for Server is, just like ArcGIS for Desktop, fully capable of using both an ArcSDE Application Server, or Direct Connect, for connecting to an enterprise geodatabase. From a functionality point of view, there is absolutely no difference between using an Application Server or Direct Connect. So yes, "Direct Connect" is sufficient for ArcGIS for Server to create (editable) Feature Services. ... View more

As far as I understood it from reading the Help pages (I haven't a setup running now), the whole point of the Web Adaptor was integration with your web server security model and hiding the GIS Servers from direct access. Maybe some others with real experience can give better directions. ... View more

With SDE, I guess you mean you are contemplating installing an ArcSDE Application Server? Note ESRI currently pushes for Direct Connect as the default connection method to a geodatabase, eleminating the need for installing an ArcSDE Application Server. This doesn't mean you can't install and run one, but be aware of this. Also note the standard "Database Connections" option in ArcCatalog at 10.1 no longer supports connecting to an Application Server. You will need to use the new specific "Create ArcSDE Connection File" tool for that. See this Help topic: Making an ArcSDE service connection from ArcGIS As to the question of running the Application Server from another server than the database server, unless you run a >= 10Gbit ethernet network connection between the servers, your Application Server will likely be limited by the network bandwidth. Even a single modern 7200 harddisk of an ordinary desktop computer can throughput over 160-180MB/s (not even talking about server RAID configurations), which equates to over 1,5Gbit/s, which means a 1Gbit (or worse) ethernet connection may prove a bottleneck. ... View more

It sounds to me that maybe some vital field indexe(s) may have been corrupted. Have you tried re-indexing? I am not to familiar with the specifics of SQL Server, but this Microsoft MSDN page: ALTER INDEX (Transact-SQL) may be of Help. It seems a "ALTER INDEX ALL ON YourTableName REBUILD" or something similar might be in order (or an equivalent menu option from SQL Server Management Studio), but maybe some SQL Server experts here on the forum can give better specifics for recovery... ... View more

Before trying to re-invent the wheel, I think you should look at the ESRI ArcGIS for Aviation product. It has tools for creating and visualizing obstacle surfaces: ArcGIS for Aviation: Key Features ... View more

1) ArcSDE doesn't use UDP, so there's no reason to have duplicate service name entries Vince, this was my understanding always too, but looking at the 10.1 Help regarding Starting a remote ArcSDE service on Linux or UNIX, I now read this: "2. As the root user, duplicate the service name in the /etc/services file as a User Datagram Protocol (UDP) entry that uses the same port number on both the local and remote servers. # \etc\services esri_sde 5151/tcp esri_sde 5151/udp 3. As the root user, update the /etc/inetd.conf file. Add this line to the bottom of the file. <ArcSDE instance> dgram udp wait <owner of ArcSDE home> <$SDEHOME>/bin/sderemote iomgr_inetd <$SDEHOME><ArcSDE instance>" The UDP connection seems necessary for running the ArcSDE service from a remote server, so in case it is installed on a physically separate server from the database server it uses the data from, as written on this Help page. P.S. Just to clarify for other Forum users reading this thread... ... View more

2. Now, publishing this amount of images (around 6.38 GB in total) is not an easy job. Then I�??m wondering if there might be better approach to be able to publish these images with optimal time Jamal, Could you be a bit more specific as to why "publishing this amount of images... is not an easy job"? Is the problem with the publishing of the service itself? Is it taking excessively long? Or is the problem actually not related to the publishing process, but are you merely unsatisfied with the ECW services performance as a web service when accessed from the internet? These are two different problems... In case of excessive publishing times, you definitely should check out if ArcGIS for Server is accessing the data directly (as it should), or if the publishing process is actually creating uncompressed copies of the data on the server where ArcGIS for Server runs. This could be a huge penalty with something as highly compressed as ECW, even clogging up your entire server's hard disk space. You should make sure ArcGIS for Server uses the data directly as the ECW format it was stored in, which is the whole purpose of buying the ECW for ArcGIS for Server product. In case of inadequate performance of the created web service, how does accessing the data directly from ArcMap perform? Are your file servers up to the task of serving this data? There are several other options offered by ArcGIS for Server, most notably though, the ones offering tiling schemes, cutting up your data in small pieces and predefined pyramid zoom levels, to ensure maximum performance. Read the ArcGIS for Server Help pages for the options. Be aware though, that most of these options will require a decompression of the original data and only very limited re-compression to another format compared to ECW. The penalty in file size increase may be unacceptable in some cases. ... View more

What version of ArcGIS / ArcSDE are you using? Support for SQL is a new thing in 10 and extended in 10.1. It may be that the stored procedure you are trying to use does not exist in your geodatabase until a future upgrade to 10.1. Please note that an upgrade of an existing geodatabase is a separate operation from upgrading your client PC's ArcGIS for Desktop application. You may be running ArcGIS 10.1 locally, but still be connecting to a 10.0 or 9.3.1 geodatabase not having this stored procedure. By the way, I would like to strongly discourage you to tamper with any of the stored procedures or geodatabase system tables using SQL. Unless you are a true expert geodatabase administrator, there is a high chance of wrecking your geodatabase. ... View more

"Hung" - not released even though no longer in use - licenses are an old problem with concurrent licenses and the license manager in ArcGIS, especially on 8.x and 9.x. You should be able to find information on this topic using the search functions. I guess the mystery switch to ArcView might have to do with that license being the only one available left with the others checked out / in use. See these links: http://forums.arcgis.com/threads/3974-Remove-hung-licenses-using-lmutil-lmremove-changed Using the options file http://help.arcgis.com/en/arcgisdesktop/10.0/install_guides/License_Manager_Guide/index.html#/Using_the_Options_File/00790000000z000000/ TIMEOUT and TIMEOUTALL http://help.arcgis.com/en/arcgisdesktop/10.0/install_guides/License_Manager_Guide/index.html#/TIMEOUT_and_TIMEOUTALL/00790000002w000000/ HowTo:  Release a hung license from a 9.x License Manager server http://support.esri.com/es/knowledgebase/techarticles/detail/26584 HowTo:  Automatically release a hung license http://support.esri.com/es/knowledgebase/techarticles/detail/29828 ... View more

One basic thing to remember is that a geodatabase resides in an RDBMS. It means any valid RDBMS security policies also holds for your geodatabase. That said, there are other tips and things documented in ESRI papers. Some links: Authentication in ArcGIS http://video.arcgis.com/watch/2197/authentication-in-arcgis Building an Enterprise GIS �?? Best Practices, Design Strategies and Performance Benchmarks http://blogs.esri.com/esri/arcgis/2011/08/26/building-an-enterprise-gis-best-practices-design-strategies-and-performance-benchmarks/ Designing an Enterprise GIS Security Strategy http://downloads2.esri.com/resources/enterprisegis/feduc2011security.pdf Enterprise GIS Security http://resources.arcgis.com/en/communities/enterprise-gis/01n200000004000000.htm ArcGIS 10.1 Enterprise Deployment http://support.esri.com/en/knowledgebase/whitepapers/view/productid/66/metaid/1896 http://downloads.esri.com/support/whitepapers/other_/1896J9736_ArcGIS_Enterprise_Deployment.pdf Marco ... View more

I was hoping that I would be able to prepare a mxd document in ArcMap and publish that as a ArcGIS mapservice. Using the ArcGIS Spatial Data Server will not allow that as it streams the data to the client which is then responsible for the drawing. Actually, if your only goal is a read-only map service, than theoretically, ArcGIS for Server should be able to do this. The process would require adding Query Layers to ArcMap (as you seem to have successfully done reading your first post in this thread), and than use this Map Document as the source for publishing to ArcGIS for Server as a Map Service. This should work for any database on your local LAN, and in this way uses the direct SQL access properties of ArcMap and ArcGIS for Server. However, reading your error / remark in the first post: When I then try to register the data source (Azure SQL) I get the message: '...The connection property set was missing a required property or the property value was unregnized... Could not open a connection to SQL Server...' I am starting to think there may be an undocumented limitation that this specific option of direct SQL access / Query Layer does not work for a Cloud based database like Azure in ArcGIS for Server. Maybe not an entire surprise, but not documented if so. ... View more