Latest Contributions by KimPeter

Hi all, As Vince pointed out in this forum post, ArcSDE doesn't control database privileges. ArcGIS clients have tools, such as the Privileges tool, that allow you to grant UML privileges to datasets, but those just pass the SQL grant or revoke statements to your DBMS.  What DBMS are you using? @Karim, who are you logged in as when you try to edit PPL_AREA?  Did you use the ArcGIS Privileges tool to directly grant INSERT, UPDATE, and DELETE privileges on PPL_AREA to that login (user)? @Sergiy, I'm not sure what you mean by Yes you're right if I give userA right to dataset B for write, will be fine, but i don't want.   If you don't grant write access on dataset B to userA, userA will not be able to edit dataset B. ... View more

Hi, ArcSDE commands are not "geodatabase aware", which means they do not update geodatabase system tables. They are legacy utilities from a time before the geodatabase existed.  If your data participates in any geodatabase functionality, including replication, you should not use ArcSDE data management commands with the data. -Kim ... View more

I cannot seem to get the multiediting functionality of SDE to work becasue when one person has the file open the other cannot make edits. William, You mentioned that the user's can't edit the file...You're referring to a table (or feature class) that is in the geodatabase, right?  Is the table registered as versioned?  Or are the users attempting to perform nonversioned edits on the same table at the same time? ... View more

I do not want ArcGIS Server Workgroup in my ArcSDE support for my SQL Server 2008 Express.    Is it possible to make a direct connection to a geodatabase in my MS SQL Server 2008 Management Studio (SQL Server 2008 Express) from my ArcGIS Catalog 10?  If it is possible, please tell me how to make such direct connection.  Scott, Going back to the screen shots you provided, it does not look like you have a geodatabase.  What you appear to have is a SQL Server database (DotSpatialGISDatabase) that contains a table with x,y coordinates in it (FtMcNair8pts). To connect to a table in a database, create a query layer in ArcMap.  That will add the table to the ArcMap table of contents.  I think your previous attempt to create a query layer failed because you had the wrong information in the Database Connection dialog box.  Based on your screen shots, the Data Source is NAB-WK-02554356\SQLSCOTT and your Database is DotSpatialGISDatabase. Then, if you want to use Database Authentication to connect, you must provide the user name and password for a database user who has permission to connect to the database and see your dbo.FtMcNair8pts table.  If you are unable to make the query layer database connection, it is possible that your SQL Server instance is not configured to use Database Authentication.  Try choosing OS Authentication instead.  If you are still unable to make a query layer connection, please contact support so they can help walk through your steps and configuration. Once you have created the query layer, though, and the table is listed in the ArcMap table of contents, you can right-click that table and click Display XY Data. In the Display XY Data dialog box, specify which field contains your x coordinates and which contains your y coordinates and indicate which coordinate system to use. Then your points will render on the map. In regards to Management Studio, I think you're using that name when you really mean SQL Server Express.  The two are not the same thing - SQL Server Express is an edition of the Microsoft SQL Server RDBMS; whereas Management Studio is the application Microsoft provides for you to manage your SQL Server instances.  You do not connect to Management Studio from ArcGIS. I hope this helps. -Kim ... View more

Yeah, if they don't own data, they don't have to have a matching schema. The only time that wouldn't be true is if you changed your ArcSDE log file configuration.  If you didn't touch that (which most people don't as there is no need to), you should be fine. ... View more

To be used with ArcGIS, all users who will create data in or import data to the geodatabase must have a schema name that matches its user name.  Even though the database itself allows multiple users to write to one schema, ArcGIS can't work with that. That is true no matter what your underlying database version is. If you have users who only edit data (they don't create data; some other user creates it and they just have rights to edit the data), those users don't have to have matching schemas.  Same thing for read-only users.  You just have to be careful that you don't later grant those users the privileges necessary to create data...at that time, their data creation efforts will fail because the schema names don't match the user names. Hope this helps. Kim ... View more

I should start creating ArcSDE geodatabase first, then use Add Spatial Database Connection to my NAB-WK-02554356 in ArcCatalog 10. Yes, that is correct; you must create an ArcSDE geodatabase before you can connect to it from the Spatial Database Connection dialog box in ArcCatalog 10. I can't fill out the User Name & Password of Database Authentication in the Database Connection box Do you mean the user name and password fields are inactive/you can't physically type in them?  Are you attempting to connect to the same SQL Server instance and database that you show in your second attachment?  If so, the information you typed in the Database Connection dialog box does not match the datasource and database.  The datasource in this case is your SQL Server instance name. That should match what you provided for the "server name" when you logged in through Management Studio.  The database is the name of the specific database to which you want to connect.  In your second graphic, the database you are connected to in Management Studio appears to be DotSpatialGISdatabase. Additionally, does the SQL Server instance you want to connect to allow for database authentication?  By default, SQL Server allows Windows-authenticated logins only.  To use database authentication, you must configure the instance for mixed-mode authentication, then add the logins, database users, and schemas you require, and grant permissions. Should I ask my Computer Team to upgrade... You don't have to upgrade Management Studio or your SQL Server instance to 2008 R2; SQL Server 2008 is supported with ArcGIS 10. http://resources.arcgis.com/content/arcsde/10.0/sql-server-system-requirements -Kim ... View more

Yes, you can use SQL Server Express with Enterprise.  As for "...it's supposed to work fine", there are no functional limitations that ArcGIS places on it, but your performance will likely not be great because of the limitations inherent in SQL Server Express itself (maximum memory used = 1 GB, maximum use 1 socket or 4 cores, maximum database size 10 GB -  http://technet.microsoft.com/en-us/library/cc645993.aspx)  If you truly have a production enterprise system, then Express is not the recommended DBMS to use for your enterprise geodatabase. ... View more

Joe, Can you post a copy of the SQL used to create the database user and schema?  (You can leave out the password text.) Is the actual name "big kahuna" with a space? Database principals and securables usually shouldn't have spaces in them, so maybe that's messing up things?  I tried to find in Microsoft's doc if they say whether or not you can include spaces.  I couldn't find an explicit statement, but none of their examples show users or schemas with spaces in them. -Kim ... View more

Hi Shana, I'm curious to know where you read that multiversioned views should be dropped via ArcCatalog...Or were you referring to the table on which the view was based? Also, the syntax you mention sdetable -o delete_mv_view -t <view name> -i 5151 -u <user> -p <passord> should be sdetable -o delete_mv_view -t <table>... http://help.arcgis.com/en/geodatabase/10.0/admin_cmds/Support_files/admincmdref.htm The record for the multiversioned view still exists in the ArcSDE system table, so you won't be able to create another multiversioned view with that name on that table until you have successfully run sdetable -o delete_mv_view to drop the existing view. If you find this is not working, please contact support. -Kim ... View more

Hi Scott, I'm not clear on what you were using Microsoft SQL Server 2008 Management Studio for if you weren't using SQL Server 2008.  Normally, you use Management Studio to manage SQL Server instances and databases. That aside, though, it would help to know what you're trying to accomplish.  What data do you need to store?  What do you need to do with it? To answer your questions about query layers and spatial database connections... -If you want to store simple spatial data in a SQL Server database, you can load or create the data outside of ArcGIS. Then you can create a query layer in ArcMap to connect to the spatial tables in your database.  You'll be able to view and analyze that data in ArcMap. -If you want to load or create data in your SQL Server database through ArcGIS, you need a geodatabase.  What edition of SQL Server do you have?  See this Microsoft article on how to determine this: http://support.microsoft.com/kb/321185  What ArcGIS products do you have?  The answers to these questions could affect what type of geodatabase you use.  Once you have a geodatabase, that's when you can create a spatial database connection to it. SQL Azure is not free (as far as I know).  Contact Microsoft about pricing for it.  Either way, though, SQL Azure is not supported with ArcGIS 10.  SQL Server 2012 is also not supported with ArcGIS 10.  To use either of these, you'll need to move to ArcGIS 10.1 when it is released. -Kim ... View more

Hi, For some reason, the link didn't work for me.  But I'll try to clarify (it is confusing; I wish it weren't...) ArcSDE for SQL Server Express is a name used for what are called Database Servers in the Catalog tree UI.  If you have ArcGIS Server Workgroup, ArcGIS Desktop (ArcEditor or ArcInfo), or ArcGIS Engine, you can install SQL Server Express and run the ArcSDE for SQL Server Express wizard to register the SQL Server Express instance as a database server.  Then you can connect to the database server/SQL Server Express instance, create geodatabases, add users, load/create data, and manage the database server and geodatabases all from the Catalog tree in ArcGIS Desktop.  If you have ArcGIS Server Workgroup, you can also publish services using geodatabases on the database server as sources. (In older documentation, posts, and articles, you would have seen these geodatabases referred to as ArcSDE workgroup geodatabases and the ones licensed with ArcGIS Desktop as ArcSDE personal geodatabases.) If you have ArcGIS Server Enterprise, you can install ArcSDE and use it with SQL Server Express.  In that case, ArcGIS considers SQL Server Express as just another edition of SQL Server, like Enterprise or Standard. There are functionality differences and limitations that Microsoft has in place for Express, but it doesn't affect how you create, manage, and interact with enterprise geodatabases using ArcGIS software. Let me know if further clarification is needed. -Kim ... View more

Sorry - I just realized you said you were using ArcGIS 10.  (I was thinking you were on 9.3.1...)  You can see spatial tables in SQL Server if you create a query layer in ArcMap. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Connecting_to_a_database/00s500000037000000/ ... View more

Hi, You don't connect to Management Studio from the Spatial Database Connection; you connect to a geodatabase in one SQL Server database.  Did you run the wizard to use ArcSDE SQL Server Express licensed through ArcGIS Desktop (previously called ArcSDE personal)?  Or ArcSDE SQL Server Express licensed through ArcGIS Server Workgroup (previously called ArcSDE workgroup)?  If you did either of those two things, then you should add a database server connection from ArcGIS Desktop to the SQL Server Express instance.  You would be connecting with your Windows log in since Windows Authentication is the only supported connection method with those. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/A_quick_tour_of_setting_up_and_using_database_servers/003n00000099000000/ Or did you instead install ArcSDE for SQL Server provided with ArcGIS Server Enterprise?  In that case, what user you connect with depends on what logins and users you or your dba have created in SQL Server.  You would also need to provide either an ArcSDE service port or direct connection string (sde:sqlserver:<your_sqlserver_instance> in the Service field and the name of the specific database in the Database field. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Geodatabase_connections_in_ArcGIS_Desktop/002q00000031000000/ If you don't actually have a database server or ArcSDE geodatabase, you can connect to a SQL Server database through the OLE DB connection , but, as Demin mentioned, you won't be able to render spatial data in  ArcMap; you will only see the tables and can view the attributes stored in the rows of the tables. -Kim ... View more