problem with registreting sql server geodatabase with arcgis server

832
7
03-10-2014 05:18 AM
yousradaoudi
New Contributor
please i have a problem with registreting my sql server geodatabase server i made the same steps that i have to do :
-i share with public in read/write the folder where my .sde exist
-in the catalog  i try to register my geodatabase in the server but i have an error saying  the data item is inaccessible

thanks for helping me
0 Kudos
7 Replies
WilliamCraft
MVP Regular Contributor
Please provide the version of ArcGIS Server, ArcSDE, and SQL Server that you are using.  It would also be helpful to provide a screenshot of the error you are getting.  Does the SDE connection file work when trying to simply view the data via ArcCatalog?  In other words, is the problem only occurring when you attempt to register the database with ArcGIS Server?
0 Kudos
yousradaoudi
New Contributor
thanks for your response
desktop: arcgis desktop 10.2
Server: arcgis server 10.1
sql server express 2008 64bit


this problem occures only when i try to register my GDB, i want to publish my GDB in order to be used by multi users in the server

thanks again for ur help
[ATTACH=CONFIG]32073[/ATTACH]
0 Kudos
WilliamCraft
MVP Regular Contributor
Are you attempting to register the 'Test' connection file shown in your screenshot under SQL Server Express in Database Servers, or are you attempting to register a .SDE connection file listed under Database Connections? 

If you're attempting to register a connection under Database Servers, then I think what you're seeing might be expected behavior.  Only .SDE connection files are able to be registered with ArcGIS for Server according to this from Esri's online help:

You can register any of the following with ArcGIS:
Databases accessed through a database connection file (.sde only)


Source: http://resources.arcgis.com/en/help/main/10.1/index.html#/About_registering_your_data_with_the_serve...

If you really are attempting to register an actual .SDE connection file, then check the Windows Services console to see which user account is being used to run the ArcGIS for Server service.  Does that account have privileges on the folder containing the .SDE connection file?

The other possibility is the limitation for administering / managing an ArcGIS for Server instance with a desktop client that is of a different software version.  For example, I don't know if you are able to perform certain administrative tasks such as registering data stores if your server is 10.1 but your desktop client is 10.2.  Try using a 10.1 desktop client to see if the behavior changes.
0 Kudos
yousradaoudi
New Contributor
here is the situation :
i'm trying to publich my .sde like what they said here in the part of regitreting a geodatabase
http://resources.arcgis.com/en/help/main/10.1/index.html#/Registering_your_data_with_ArcGIS_Server_u...
i shared my folder where i have my .sde with public the folder is there: C:\Users\hp\AppData
what i have to do else cause realy i m mixed up

sql server express is in the same machine with arcgis desktop
arcgis server is in an other machine



[ATTACH=CONFIG]32074[/ATTACH]
0 Kudos
WilliamCraft
MVP Regular Contributor
Here is another possible explanation besides the two I've given above: The machine where ArcGIS for Server is installed is missing the 64-bit client libraries for the specific RDBMS to which the connection is being made.  If not already installed, go ahead and install the 64-bit client libraries for SQL Server on the ArcGIS for Server machine.  It is important to remember that ArcGIS for Server is a 64-bit application and requires a 64-bit database client, versus ArcGIS for Desktop which is a 32-bit application and requires a 32-bit database client.

http://support.esri.com/en/knowledgebase/techarticles/detail/40409
0 Kudos
yousradaoudi
New Contributor
thanks william, i have question how can we install the 64-bit client libraries for SQL Server on the ArcGIS for Server machine is it just  like installing it for the client part
0 Kudos
WilliamCraft
MVP Regular Contributor
Here are the paths to both the 32-bit and 64-bit SQL Server Native Clients which will work with SQL Server Express 2008 R2:

32-bit
http://go.microsoft.com/fwlink/?LinkId=123717&clcid=0x409

64-Bit
http://go.microsoft.com/fwlink/?LinkId=123718&clcid=0x409

In your case, I think you would only need the 64-bit client since you appear to be able to connect from a 32-bit app already (e.g., ArcGIS Desktop).  I believe it might simply be ArcGIS for Server (64-bit app) that's having issues.
0 Kudos