topic Re: Register database in Data Management Questions

Register database

JoshObrecht — Mon, 11 Feb 2013 16:38:36 GMT

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.

Re: Register database

MichaelVolz — Mon, 11 Feb 2013 16:47:08 GMT

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.

Re: Register database

JoshObrecht — Tue, 12 Feb 2013 20:41:19 GMT

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

Re: Register database

JakeSkinner — Wed, 13 Feb 2013 09:26:43 GMT

Hi Josh,

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

Re: Register database

JoshObrecht — Wed, 13 Feb 2013 12:46:42 GMT

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?

Re: Register database

JoshObrecht — Fri, 15 Feb 2013 14:41:22 GMT

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

Re: Register database

JakeSkinner — Tue, 19 Feb 2013 18:30:56 GMT

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?

Re: Register database

JoshObrecht — Wed, 20 Feb 2013 13:12:08 GMT

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]

Re: Register database

JakeSkinner — Fri, 22 Feb 2013 10:26:12 GMT

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

Re: Register database

JoshObrecht — Fri, 22 Feb 2013 18:20:37 GMT

It does and I do.

Re: Register database

JoshObrecht — Mon, 04 Mar 2013 18:49:00 GMT

I'm still looking to resolve this issue so I'm bumping it.

Re: Register database

BillLotz — Thu, 18 Apr 2013 18:38:08 GMT

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

If the arcgis server account is a loca acount on the server, does an identical account need to be created on my local computer?

Does it need access to this location: C:\Users\username\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog ?

Re: Register database

JakeSkinner — Fri, 19 Apr 2013 09:59:52 GMT

Hi Bill,

If you don't want the data to be copied to the ArcGIS Server machine, then Yes, a local arcgis server account must also exist on your machine. You can then create a data store from this directory. The arcgis server account will need to have read privileges to any directory you wish to create a data store from.

If you have SDE connections, the path you mentioned stores the connection files there when you create an SDE connection under Database Connections. So, if you wish to create a data store from an SDE geodatabase, the arcgis server account should have read privileges to this directory.

Re: Register database

BillLotz — Fri, 19 Apr 2013 13:28:09 GMT

Hello Jake,

Thanks for the reply, got that part done. Now if I can get a folder registered on the server...... I granted the Server Account permissions to a an empty test folder, but the register folder in Server manger just seems to hang.

Off to search the forum.

Thanks,
Bill

Re: Register database

JakeSkinner — Fri, 19 Apr 2013 14:08:07 GMT

Make sure the folder is shared, and when adding it to the data store, use a UNC path. Ex:

\\server\gis\data