I have attached geodatabase "Riverside" to databases list in MS SQL SERVER 2012 Enterprise edition :
After that I created two logins using :
USE [master]
GO
CREATE LOGIN [sde] WITH PASSWORD='sde_class', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
CREATE LOGIN [GISADMIN] WITH PASSWORD='gisadmin', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
Then I tried to add a database connection from catalog window within ArcMap ,but the connection failed :
After that I went to security folder inside the "Riverside" I found a user with name "GISADMIN" . I thought I could delete this user and create another user with same name . The deletion failed ,
my last option was mapping this user"GISADMIN" to the login "GISADMIN" .
use RIVERSIDE
go
exec sp_change_users_login 'GISADMIN', 'gisadmin'
go
Nothing changed!
I'm using ArcGIS 10.3 running on Windows 7 machine.
Best Answer
It's working: