AnsweredAssumed Answered

Database User name and Schema name must be the same?

Question asked by Wolseley on Mar 21, 2014
Latest reply on Mar 21, 2014 by asengupta
Using ArcGIS 10.2.1 and SQL Server 2008 R2; Using the dbo (NOT sde) schema. Have enabled a SQL Server Enterprise Geodatabase.

Must the database user name and schema name be the same? for example in SQL Server Management Studio:

Database User Name is "X"

Database Schema Name is "dbo"


Is this ok?

OR

must it be like this:

Database User Name is "dbo"

Database Schema Name is "dbo"

Is there a way to get the SQL Server Enterprise Geodatabase to function with a user name and schema name that are different?

Outcomes