nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding Addition Geodatabase to SDE/SQLserver

KenMarshall1

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?

Najděte více příspěvků označených jako

Accepted answers

AlexeyTereshenkov

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

Snag_486a93.png

AlfredBaldenweck_0-1729002812488.png

All comments

JoeBorgione

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.

AlexeyTereshenkov

Snag_486a93.png

AlfredBaldenweck_0-1729002812488.png

KenMarshall1

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

MelissaJarman

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. "

JoeBorgione

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....

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.