I have a problem creating an enterprise geodatabase, two days ago I have created a geodatabase throw ArcMap with an SQL Server connection and everything went well, but today I'm trying to create another geodatabase using the same SA and SDE Credentials but it fails when running the process, and this message appears:
And the route marked in red shows the following message:
Then I open SQL Server Management Studio and there is the Database created.
I will aprecciate if someone could tell me how to fix this problem.
Solved! Go to Solution.
Just a guess. The sde password that was generated could be a one-time password. Login to SQL Server via sde credential, and define a new password. Let me know if it works?
Have you applied 'sysadmin' role to your SDE user? If so, you can revoke this in SQL Server Management Studio. Security > Logins> right-click the SDE user > Properties > Server Roles. Uncheck 'sysadmin'.
EDIT: If the above solution doesn't work, you might want to have a look at this article.
When I did that, I could not connect to any other geodatabase, so I have returned the previous passwoord.
But I think I have fixed it deleting the sde login and databases linked in SQL Server, and creating again a new BD throw ArcMap and new sde too, so at the moment it works.
Thank you for your support!.
If you look at the error message it says.....
"...revoke database owner from the SDE login..."
I do not think it has anything to do with the password.