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; } } }

Create Role Error

newbieGIS

I'm trying to Create Role using GP tool and encounter error.

[Operation succeeded with warning messages written to error log file] Error creating role. Failed to execute (CreateRole). Connected as sa. SQL Server 2014. ArcGIS Desktop 10.4.

Can anyone figure out what is wrong.

Encuentra más publicaciones etiquetadas con

Accepted answers

AsrujitSengupta

You seem to be hitting a Bug:

BUG-000093032 - ‘Create Role’ tool fails with ‘Error Creating Role’ error for SQL Server geodatabases at 10.4

The workaround is to create the Role from the Database end.

For more information on this and to make sure you are hitting that Bug, please contact Esri Tech Support.

All comments

WWalker

ESRI support states this bug is fixed at 10.4.1.

WWalker

While waiting for ESRI support to respond, I found a work around. Using the pyodbc python library, I was able to replace the following line in my script

arcpy.CreateRole_management(my_connection.sde, "EDITOR", "GRANT", "My Domain\Domain Users")

with

import odbc
conn = pyodbc.connect(r'DRIVER={ODBC Driver 11 for SQL Server};SERVER=MySqlServerInstance;DATABASE=my_database_name;Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute("CREATE ROLE EDITOR AUTHORIZATION DBO")
cursor.execute("CREATE USER [My Domain\Domain Users]")
cursor.execute("EXEC sp_addrolemember 'EDITOR', 'My Domain\Domain Users'")
conn.commit()
conn.close()

I hope it helps someone else who doesn't like to wait

-WW

JayantaPoddar

Looks like it's fixed in ArcGIS 10.5.

NIM102049: Unable to revoke database roles from SQL Server 2012..

Asrujit_SenGupta

As details of that Bug is not public, you will need to contact Esri tech Support for a status update mentioning the Bug#.

WWalker

Is there any update regarding this bug?

newbieGIS

Thanks for your suggestion Adrian Welsh. The logins. user, and privileges are Okay.

Thank you Asrujit SenGupta for the info regarding BUG .

AsrujitSengupta

You seem to be hitting a Bug:

BUG-000093032 - ‘Create Role’ tool fails with ‘Error Creating Role’ error for SQL Server geodatabases at 10.4

The workaround is to create the Role from the Database end.

For more information on this and to make sure you are hitting that Bug, please contact Esri Tech Support.

AdrianWelsh

Hi,

Have you tried following the steps at the following page:

Add logins and users to SQL Server—Help | ArcGIS for Desktop

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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