nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Vind meer berichten getagd met

Accepted answers

All comments

JakeSkinner

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

\\server\gis\data

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

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

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 ?

JoshObrecht

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

JoshObrecht

It does and I do.

JakeSkinner

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

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]

Clipboard01.jpg

CWAPPTEST-CWAPPTEST-20110620-144740.zip

JakeSkinner

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

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

JoshObrecht

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?

JakeSkinner

Hi Josh,

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

JoshObrecht

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

MikeVolz

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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.