First, my background is mainly in ESRI ArcGIS Desktop. I have just started using Microsoft SQL Server 2005. I have created a new database using the ArcSDE Post-Install software. The database is an enterprise sde database. My problem is assigning users to the database and defining their roles within the database. As the database administrator I ...

10 logical connections is a hard limit (see http://blogs.msdn.com/angelsb/archive/2005/01/13/352718.aspx and http://blogs.msdn.com/angelsb/archive/2004/09/07/226597.aspx for more details). If you go over this limit, it gets expensive from a performance standpoint. Also see ...