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?

[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 · Accepted solution]

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

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