Latest Contributions by ShannonShields

Scott, please read the following Online Documentation topics: http://resources.arcgis.com/en/help/main/10.1/#/What_are_database_servers_in_ArcGIS/018t0000000p000000/ http://resources.arcgis.com/en/help/main/10.1/#/A_quick_tour_of_setting_up_and_using_database_servers/018t00000018000000/ In order to create and work with a geodatabase in SQL Server Express you must enable the SQL Server Express instance to store geodatabases. This is a separate setup operation detailed here: http://resources.arcgis.com/en/help/main/10.1/#/Enabling_SQL_Server_Express_to_store_geodatabases/018t0000000w000000/. With an ArcGIS Desktop Standard or Advanced license you can create a geodatabase that can have up to 3 simultaneous users - you'd choose the setup for 'Desktop'. If you are licensed for ArcGIS Server Workgroup you can create geodatabases that can have up to 10 simultaenous editors - you'd choose the setup for 'Workgroup'. The Create Enterprise Geodatabase tool that Jake mentioned requires an ArcGIS Server Enterprise license and is not specific to SQL Server Express. -Shannon ... View more

That article is pretty dated - it appears to have been written for much older versions of ArcGIS and SQL Server. There is really nothing specific to do for SQL Server 2012, other than make sure you apply both ArcGIS 10.1 SP1 and SQL Server 2012 SP1. As it is a new release the first few service packs are useful to apply. The standard geodatabase maintenance tasks apply - maintain statistics, rebuild indexes if the data is changing a lot, and compress regularly. And the standard SQL Server tasks apply as well - make sure you have a sound backup and recovery plan, make sure you size your database and logfiles appropriately and do not rely on small autogrowth increments, and keep tempdb on a separate disk if possible. -Shannon ... View more

Chuck, In the 'Login Properties' dialog look under 'User Mapping'. Your logins must be mapped do users in databases before those databases will appear to them in a dropdown list - at minimum they need 'connect' permission to a database, which is granted automatically when they are mapped to a database. [ATTACH=CONFIG]17812[/ATTACH] In this example, login 'foo' does not have access to any databases. If they try to create a connection in ArcGIS, they'll get the same error message you are seeing. Granting people access to data in SQL Server is a two-step process. Logins are given permission to connect to SQL Server, but in order to see data, they must be mapped to specific databases, then granted the ability to read and/or write objects within those databases. See these topics for more information on creating logins & users in SQL Server: http://resources.arcgis.com/en/help/main/10.1/#/Adding_Windows_authenticated_logins_or_groups_to_a_SQL_Server_database/002q00000029000000/ http://resources.arcgis.com/en/help/main/10.1/#/Adding_database_authenticated_logins_to_a_SQL_Server_database/002q0000002m000000/ -Shannon ... View more

What type of date field did you add? The datetime and datetime2 types are supported in ArcGIS, but the date type is not. -Shannon ... View more

Sree, are you able to connect from SQL Server Managment Studio using the same parameters? -Shannon ... View more

This is a known issue; ArcCatalog is hanging on to the old connection information.  If you close ArcCatalog and re-open it, you should be able to make a connection to the new geodatabase.  I'll try to dig up the bug number. The bug is NIM080776 Changing the database of an existing connection in ArcCatalog does not change subsequent connections without a refresh of database connections node. This only appears to affect connections made with Windows Authentication. Connections made using SQL Server-managed logins behave correctly. Refreshing the database connections node will update the connection to the new database without having to restart ArcCatalog. -Shannon ... View more

I am working on ArcSDE geodatabase, I have privilege on one Schema called E_USER, but when I am trying to save my edits on any feature or table "let's say E_USER.Incidents" on this schema I got this error Unable To Save Edits Insufficient Permissions[Insufficient privileges to table A_USER.PPL_AREA the current user lacks full access to table.] Karim, Is it possible that there is a relationship class between E_USER.Incidents and A_USER.PPL_AREA? If there is, and you haven't been granted permission to A_USER.PPL_AREA then you may not be able to successfully edit the Incidents table. -Shannon ... View more

The ArcGIS 10 media ships with SQL Server 2008 Express w/ Advanced Services RTM (not patched). This particular edition of SQL Server Express is not available as a patched download like the plain vanilla SQL Server Express. However, you really only need Advanced Services if you intend on using this with Metadata Server  which requires full-text indexing capability. Otherwise you can safely use the smaller edition. If your internet connection is slow, and you need the Advanced Services capability, I'd install the version that is delivered with the ArcGIS 10 media, then download the service pack, which is somewhat smaller. SQL Server 2008 is now up to SP3. I'd recommend installing that instead of SP1 - I usually try to keep my SQL Server instances patched with the latest. You'd download the generic 'SQL Server' service pack - one install applies to all editions of SQL Server. If you don't need advanced services you can download regular SQL Server Express 2008 SP3 here: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=27597 It is one third the size of the full SP3 download, which can be found here: http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=27594 The ArcSDE for SQL Server Express setup will automatically install the version that matches your OS - if you are running 64-bit, you'll get the 64-bit SQL Server Express. If you download and install your own SQL Server Express, you'll still need to run the ArcSDE for SQL Server Express setup to license the instance for use with ArcGIS - just uncheck the option to install SQL Server, but make sure the second option (Enable Geodatabase Storage) is checked. And...if you are downloading your own SQL Server Express setup, you may want to go with SQL Server 2008 R2 (the next version up from 2008). It is supported with 10 and contains numerous enhancements to 2008. -Shannon ... View more

Hi Alan, at 10.1 there is no need to install the ArcSDE software unless you need to run an ArcSDE service. If all of your users are making Direct Connections to the geodatabase then the ArcSDE installation is not necessary. As well, most of the functionality offered by ArcSDE commands is now available in ArcGIS Desktop & through GP tools. -Shannon ... View more

Try running the post-installer as Administrator (right-click from the Start Menu & choose 'Run as Administrator'). This should allow you to only run the authorization component. Re-running the repository setup will not overwrite anything - it will detect the existance of a geodatabase and move on. -Shannon ... View more

I have an administrative account I use to perform installations.  I used that account to install SDE.  That account is still a login to the SQL Server, but that account is now just part of the public role, whereas before it was part of sysadmin. If your login no longer has any elevated permissions such as sysadmin then you will not be able to see the existance of other logins on SQL Server. By default logins and users have no permissions to do or see anything unless explicitly granted. By downgrading your permissions from sysadmin to a regular login, viewing any system metadata like logins becomes very restricted. -Shannon ... View more