kiran_shakya

ArcGIS Server 10 security settings > security store

Discussion created by kiran_shakya on Dec 20, 2011
Latest reply on Jun 22, 2012 by jzambrana-geosystems-cc-esridist
I am having some issue setting up security stores in remote SQL server.  I am using ArcGIS Server 10 with sp3 and SQL server 2008.

At first I did Security > settings > configure (button) > SQL Server (select option) and
typed the IP address of remote SQL Server xxx.xxx.xxx.xxx, it shows following error "Login failed for user \'NT AUTHORITY\ANONYMOUS LOGON\'."

After that, I creaded a user "kiran" (granted dbcreator) in remote SQL server (which is same local user to logon ArcGIS Server Manager) with same password as in ArcGIS Server (kiran is a GIS WebService account). Again Security > settings > configure (button) > SQL Server (select option) and typed the IP address of remote SQL Server xxx.xxx.xxx.xxx, it shows following same error "Login failed for user \'NT AUTHORITY\ANONYMOUS LOGON\'." :confused:

Then I did "GIS server post installation", made my domain user as GIS WebService account, added the domain user to remote sql server, granted dbcreater.  Still the problem is same. :mad:

So what is the solution to connect remote SQL server 2008 from security settings ??  Most of the helps only deals with SQLExpress.  Is there any help for remote sql server connection.

Thank you in advence.

Kiran

Outcomes