English

Problem: Cannot create SDE schema geodatabase with ArcSDE for SQL Server

Description

After installing ArcSDE for SQL Server, even if the user chooses to install ArcSDE as SDE schema, the ArcSDE database is created as DBO-schema.

Cause

The SDE login is granted with more server roles than necessary.

Solution or Workaround

Revoke any unnecessary database roles from the SDE login, and keep only the default 'Public' role.

  • For SQL Server 2000:

    1. Click Start.
    2. Select All Programs.
    3. Select Microsoft SQL Server.
    4. Select Enterprise Manager.
    5. Select Microsoft SQL Server.
    6. Click SQL Server Group.
    7. Select Instance.
    8. Go to Security.
    9. Click Logins.
    10. Right-click SDE.
    11. Select Properties.
    12. Go to Server Roles.
    13. Uncheck 'System Administrators'.
  • For SQL Server 2005:

    1. Click Start.
    2. Select All Programs.
    3. Select Microsoft SQL Server 2005.
    4. Click SQL Server Management Studio.
    5. Select Security.
    6. Go to Logins.
    7. Right-click SDE.
    8. Select Properties.
    9. Go to Server Roles.
    10. Uncheck 'sysadmin' (keep only the 'public' role).