Latest Contributions by WilliamCraft

You have SQL Server Express, which calls for a slightly different setup process for ArcSDE than the Enterprise or Standard levels of SQL Server.  Furthermore, at the express version of SQL Server your geodatabase is considered to be 'Workgroup' rather than Enterprise.  There are some limitations of Workgroup geodatabases that you can read about later so that you understand the difference.  For now, you need to following either of the two workflows below: (1) Launch the ArcSDE for Microsoft SQL Server Express installation wizard from your installation media and follow the steps at the following URL: http://resources.arcgis.com/en/help/main/10.2/index.html#//018t0000000w000000 OR (2) Open ArcCatalog, expand the Database Servers section, double click "Add Database Server" and input '<your_server_name>\sqlexpress', and then right click the new database server entry and choose New Geodatabase (see screenshot below): [ATTACH=CONFIG]31710[/ATTACH] ... View more

What part of the ArcSDE application do you need to be available after installation?  What is the business need to perform the installation silently?  For many people, it's simply having the ArcSDE command line tools that is the driving factor.  Assuming it's the command line tools you really care about and not the post installation tool (for authorizing a GDB or setting up the application service), all you really need is the bin folder which contains all of the executables and associated binaries.  For example, an Oracle ArcSDE installation folder would contain the command line tools under: ...\ora11gexe\bin.  All that's needed is to install ArcSDE on one machine and then copy/push the bin folder that the installation produces over to other machines remotely using RoboCopy, XCopy, or Copy.  Users will then have those tools on their machines, but they will want to add the path to the bin directory to their PATH system variable if they want to use the SDE command line tools without having to start the command prompt at the bin directory. ... View more

Installing ArcGIS Server on a laptop isn't standard practice; I'll even go so far as to say it's not recommended practice.  AGS is meant to be more of an enterprise-level application where clients access content hosted from the server.  Putting your laptop to sleep at night when AGS is installed doesn't seem like a configuration that would support anyone's business needs.  That being said, the services should have a parameter to check called "Periodically check and repair data connections for idle instances".  Try checking this option and setting the interval to something like 1 or 2 minutes.  I doubt it will make any difference, but it might be worth trying. ... View more

Exposing your web adaptor to a FQDN is essentially configuring a reverse proxy, which gives you the ability to publish your GIS services to be accessible externally from the internet.  The article below might be helpful to you, despite it being a bit older.  It also contains other URL references that will be helpful if you're using Apache or IIS 7: http://support.esri.com/en/knowledgebase/techarticles/detail/32634 ... View more

Ok, so yes, first add the new scale using the Manage Map Server Cache Scales tool and then create tiles for the new scale using the Manage Map Server Cache Tiles tool.  Again, you'll need to modify your map document first in order to produce a new service definition (SD) file to re-publish.  Typically, I've had good luck with using group layers within a map document; one per scale level for my map service. ... View more

There are probably many approaches you can take to achieve what you're wanting to do.  The complexity depends on your data model, in my opinion.  In general, I think the following options might work for you: Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, manually perform a copy/paste in ArcCatalog of all data (making sure to be connected using the correct schema owners for each object class). Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, connect to your Oracle 9i geodatabase using the 10.1 client (if it works) and export an XML schema file, connect to your new 10.1 geodatabase and import the XML schema document, use Simple Data Loader in ArcCatalog or Load Objects tool in ArcMap to bring your data in (has to be done per feature class and per table). Create a new Oracle 11g database, use the Create Enterprise Geodatabase tool, use the Enable Enterprise Geodatabase tool, connect to your Oracle 9i geodatabase using the 10.1 client (if it works) and export an XML file with data option checked, connect to your new 10.1 geodatabase and import the XML file. Upgrade your Oracle 9i database to an 11g database following upgrade documentation from Oracle, upgrade from 9.1 to a currently supported release (I think that's 10.0 now), use the 10.1 Upgrade Geodatabase tool to upgrade a second time to get it to a 10.1 GDB.  There may be other paths to get where you need to go, but these paths pop out at me as the first ones to look at.  Some are better than others and some are more risky.  Your choice may depend on how much data you have, if you have a versioned GDB or not, if you have geometric networks or topologies or not, and how comfortable you are with Oracle upgrades. Option 1 might be the most straight forward and the cleanest method.  Option 2 might not work if a 10.1 client can't connect to an older 9i database; not to mention it's tedious to load everything manually at separate times.  Option 3 might fail if you have too much data; XML files with data aren't always the most reliable method of data migration.  Option 4 could be terrifying; I've done a few Oracle upgrades and they are painful.  Equally as painful is the Upgrade Geodatabase tool... which won't actually tell you if the GDB will upgrade or not until it actually tries (the pre-req check doesn't behave well).  ArcSDE 9.x allows some geometry issues to persist in your data that 10.1 might otherwise complain about; the upgrade may fail and you'll be left holding the bag.  Once you're done getting your data migrated or upgraded, you'll of course need to address things like permissions for users and roles.  The SDE user will need specific permissions too; upgrading tends to require more system permissions.  There is documentation about all of this on the ArcGIS Resource Center website.  Caveat to all options listed or not listed: Take a good backup of your database first! ... View more

Can you run the following queries in SQL Server Management Studio and post the results? SELECT @@VERSION SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') So you have verified that no ArcSDE system tables are present in your database?  If the SDE account and login now exists, try adding it to the db_owner role for that database and then re-running the Enable Enterprise Geodatabase tool. ... View more

If you have a laptop and put it into sleep then then after resuming everything works OK except ArcGIS server - you have to restart the service. Very annoying. If SQL Server, DB2 etc. all work then so should ArcGIS. Is this supposed to be a question or a comment?  Either way, your statement above is not clear and does not provide adequate detail about what problem you are experiencing.  You should describe specific behavior if you're looking for help from others in the forums.  Making statements about how annoying the software is for you will not achieve anything beneficial.  Are you running ArcGIS Server from a laptop or a server?  When you say "everything works OK except ArcGIS server", what does that mean?  What version of Esri software and database software are you running?  Is the service simply not rendering geographic information or are you receiving a specific error?  There are many who are willing to assist, but you should be more clear and diplomatic in your posts. ... View more

Are you using the Standard or Enterprise version of SQL Server, or are you using SQL Server Express?  When you say that you can create the database connection, are you talking about creating it under Database Connections or Database Servers?  The process for creating the geodatabase is different than simply connecting to an existing non-spatial database. ... View more

Great!  Please mark the correct answer with the green check. ... View more

The geodatabase should still work just fine without reauthorizing, but you may want to change the license key for legal reasons.  If none of the various syntax options are working for you with regard to the SDESETUP command, try using the Post Installation wizard for ArcSDE.  Choose the custom option and only select the box for authorizing a geodatabase. ... View more