topic Re: Adding Addition Geodatabase to SDE/SQLserver in ArcGIS Enterprise Questions

Adding Addition Geodatabase to SDE/SQLserver

KenMarshall1 — Mon, 27 Feb 2012 12:34:30 GMT

I'm currently designing/creating a GIS enterprise system with SDE and Sqlserver. I like to have mutiple Geodatabase in SQLserver and wondering how to add more the one geodatabase. Do I have to run another post install to add additional geodatabase in SDE/SQLserver?

Re: Adding Addition Geodatabase to SDE/SQLserver

JoeBorgione — Mon, 27 Feb 2012 17:52:24 GMT

That's the only way I know how to do it. Remember to use a different port than whatever you've used before; the default is 5151. I have the firewall guys open 5150-5160 so I can have mulitple instances; I create them in numeric order. If your clients are outside your firewall, they'll need to get the right ports opened on thier end as well.

Re: Adding Addition Geodatabase to SDE/SQLserver

AlexeyTereshenkov — Mon, 27 Feb 2012 18:55:53 GMT

Ken, this is right. A geodatabase in SQL Server should have ArcSDE system tables aka repository which are created during the post install procedure.

The details of this procedure are outlined in this page:
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000000m000000

Re: Adding Addition Geodatabase to SDE/SQLserver

KenMarshall1 — Tue, 28 Feb 2012 11:15:49 GMT

This is great info. thanks so much exspecially the idea on changing the ports on my side and client side of things would not have thought of that.

Thanks
Ken

Re: Adding Addition Geodatabase to SDE/SQLserver

MelissaJarman — Tue, 15 May 2012 17:17:47 GMT

Keep in mind also at version 10.1 there will be a 'Create Enterprise Geodatabase' tool for this operation as well instead of running through a complete Post Installation Wizard.

"The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database. "

Re: Adding Addition Geodatabase to SDE/SQLserver

JoeBorgione — Tue, 15 May 2012 17:43:35 GMT

Keep in mind also at version 10.1 there will be a 'Create Enterprise Geodatabase' tool for this operation as well instead of running through a complete Post Installation Wizard.

"The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database. "

Hmmmmm.... If it sounds to good to be true.....

All seriousness aside, I'll be real interested to see this. My last update from 9.3.1 to 10.0 was a real pain in the backside with permissions, schemas, sde in sysadmin group, blah, blah blah....