SOC account cannot resolve path to data

[HenryMoore]

I have a SqlServer 2008 Express installation with w/ArcSDE_Personal. I've successfully restored a database and repaired sde connections to my mxd's. I can analyze the map without error but when I try to publish the map I get:

"The SOC account cannotresolve the path to the data, or the SOC account has not been granted read permissions to the data. In the case of ArcSDE, direct connect may not be configured properly, or the SOC may not have permission to access the database."

I've added the SOC account and granted read/write permissions to the folders containing the database. The SOC, SOM and geodatabase are all on the same server (Windows 2003 Standard x64 SP2). I've searched the forums and found that this was a bug for Oracle when trying to publish map services, but I don't see anything for SqlServer. I can connect to the geodatabase using Database and Operating System authentication. It appears to be a "Direct Connect" issue. I'm running ArcGIS 10.0 w/ ArcGIS Desktop SP5 and ArcGIS Server .net GIS Services SP5. Can anyone help me with this?

[MandarPurohit]

Hi treeninja,

Did you try adding the local SOC account to the geodatabase (SQL Server Express) and assigning read permissions to the datasets? 

You can add the SOC account to the geodatabase using ArcCatalog > Database Servers:
Adding users or groups to a database server.

and provide Read Only permissions:
Altering geodatabase permissions.


- Mandar

[HenryMoore]

Hey Mandar,

Thanks for the response. I did as you suggested and granted the SOC read only privaleges using ArcCatalog and I still recieve the same error. I think the problem has to do with this string in the connection dialog box: sde:sqlserver:server name\SQLEXPRESS

[MandarPurohit]

Do you have ArcCatalog on this same machine (which has SOC, SOM and the geodatabase)? Does the connection work ok from ArcCatalog on this machine? Could you also try giving read permissions to SOC on the folder containing the mxd?

- Mandar

[HenryMoore]

Hey Mandar,

I had already granted ArcGISSOC permission to the mxd folder and geodatabase. I can connect to the database using database and operating system authentication using user login in catalog.

[MandarPurohit]

One more thing to check would be to copy the database connection file to a location accessible to SOC.

Right click the connection within 'Database Servers' > Save. (this will create a .sde file in 'Database Connections'.)
Copy that .sde file to the folder containing .mxd (or accessible to SOC) > Resource the mxd.

Also, if you login to this machine using SOC account can you launch this .mxd?

-Mandar