Register database

[JoshObrecht]

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.

[JoshObrecht]

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

[BillLotz]

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 ?

[JakeSkinner]

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.

[BillLotz]

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

[JakeSkinner]

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

\\server\gis\data