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

Error: ???Revoke database owner from the SDE login???

Anonymous User

Original User: Jamal432@gmail.com

Error: �??Revoke database owner from the SDE login�?�

I tried to �??create an enterprise geodatabase�?� but I got the error shown in the screenshots below:

[ATTACH=CONFIG]20014[/ATTACH], [ATTACH=CONFIG]20015[/ATTACH]
--------------
[To create an SDE schema geodatabase, revoke database owner from the SDE login.]
See the setup log in the following location for additional error information:
C:\Users\m\AppData\Local\Temp\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (CreateEnterpriseGeodatabase).
--------------------

What might be the problem?

Thank you for the answer

Best

Jamal

Clip_41.jpg

Clip_40.jpg

タグ付けされた投稿をもっと見る

Accepted answers

All comments

KarenLizcano1

thanks!!!

JamalNUMAN

I just had this issue and that solution didn't work for me - I got a "not enough permissions" type error. But I followed the solution here: http://support.esri.com/en/knowledgebase/techarticles/detail/40606

And simply re-connected to the geodatabase I wanted to enable with my "sa" user instead of "sde" and ran the "Enable Enterprise Geodatabase" Tool, and that worked. So you might try that alternative if someone comes across this thread.

Thanks douglas. This is useful.

Best

Jamal

Anonymous User

Original User: dougcurl

I just had this issue and that solution didn't work for me - I got a "not enough permissions" type error. But I followed the solution here: http://support.esri.com/en/knowledgebase/techarticles/detail/40606

And simply re-connected to the geodatabase I wanted to enable with my "sa" user instead of "sde" and ran the "Enable Enterprise Geodatabase" Tool, and that worked. So you might try that alternative if someone comes across this thread.

JamalNUMAN

Hi Jamal,

It appears you may have the 'sysadmin' role applied to your SDE user. You can revoke this in SQL Server Management Studio by going to the Security folder > Logins> right-click on the SDE user > Properties > Server Roles. Uncheck 'sysadmin'.

Thank you Jake for the answer. It works.

[ATTACH=CONFIG]20018[/ATTACH], [ATTACH=CONFIG]20019[/ATTACH]

Best

Jamal

Clip_43.jpg

Clip_42.jpg

Anonymous User

Original User: JSkinn3

Hi Jamal,

It appears you may have the 'sysadmin' role applied to your SDE user. You can revoke this in SQL Server Management Studio by going to the Security folder > Logins> right-click on the SDE user > Properties > Server Roles. Uncheck 'sysadmin'.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

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