Register database

JoshObrecht · ‎02-11-2013

I'm tyring to publish a feature service using features obtained from SDE using SQL Server. I can connect to the SDE fine. However, when I use the connection string to register the database during the publishing process, it tells me that I cannot register the database. I tried giving all privileges to the sde admin, however that did not work.

MichaelVolz · ‎02-11-2013

Are you using ArcGIS Server v10.1?

I ask because this server is 64 bit. I'm not sure this would apply to SQL Server as I have Oracle. In order to register the database with ArcGIS Server I needed the 64 bit Oracle Client. I also had ArcMap on the machine so when I published the service, I needed the 32 bit Oracle Client installed so 32 bit ArcMap could connect to SDE.

I'm not sure this applies to you, but maybe it might help in your research to find the problem.

JoshObrecht · ‎02-12-2013

I am using ArcGIS Server 10.1 and my version of SQL Server is 64 bit.

JakeSkinner · ‎02-13-2013

Hi Josh,

Add the arcgis server account to the database and then see if you can register the database.

JoshObrecht · ‎02-13-2013

I added the ArcGIS Server account as an user and am still receiving the error. Since SQL Server is on another server than my ArcGIS Server, are there certain permissions that I need to give the account?

JoshObrecht · ‎02-15-2013

Will I need to specify the server name before the account?

JakeSkinner · ‎02-19-2013

The arcgis server account name must match the arcgis server account on the other server (username and password).

How are you connecting to your SDE geodatabase, are you using Windows or Database Authentication? If you are using Windows Authentication, make sure the arcgis server account has read privileges to the feature classes (i.e. right-click on the feature class > Manage > Privileges.

Also, can you send a screen shot of the error you are receiving?

JoshObrecht · ‎02-20-2013

I have attached the message I am receiving. The machine name is the server that contains ArcGIS Server. SQL Server is on another machine that does not have ArcGIS Server on it. The user name I log into ArcGIS Server with has read permissions to the feature class.

[ATTACH=CONFIG]21983[/ATTACH]

JakeSkinner · ‎02-22-2013

Does the arcgis server account have read privileges to the directory where the .sde connection file is stored?

Also, be sure you have the 64-bit SQL Server native client installed on the ArcGIS for Server machine:

http://www.microsoft.com/en-us/download/details.aspx?id=16978

JoshObrecht · ‎02-22-2013

It does and I do.