Troubleshooting Tips - Some common ArcGIS Mapping for SharePoint issues

Blog Post created by geonetadmin on Oct 26, 2011
While working with the ArcGIS Mapping for SharePoint, you might run into a few of these common issues. The good news is that we’ve got the solutions here to help.Issue: ArcGIS SharePoint install freezes while using installer.exeSolution:
  • Uninstall the solution file using the installer.exe
  • Restart the SharePoint machine
  • At the command line prompt, manually deploy the solution file by using the following commands:
    • stsadm -o addsolution -filename ESRI.ArcGIS.Mapping.SharePoint.wsp
    • stsadm -o deploysolution -name ESRI.ArcGIS.Mapping.SharePoint.wsp -url http://:>

Note: Change the path to "%COMMONPROGRAMFILES%microsoft sharedweb server extensions12bin" to access the stsadm.exe

Documentation regarding the commands: Activating the ArcGIS component in SharePointSolution: As specified in the help document of the Resource Center, ArcGIS Mapping for SharePoint is not automatically activated when you create a new site collection:

The ArcGIS component can be enabled by following these steps:

In the SharePoint Web application site, click Site Settings > Site Collection Administration > Site Collection Features > Activate ArcGIS SharePoint Web Part.

You can also follow the steps below to check whether or not the ArcGIS component in SharePoint is deployed properly:
  • In the Central Administration site, go to System Settings and then, go to Manage Farm solutions. Check if the ESRI WSP file is there. If it is there, click and check to see the deployment status.
  • Also check ArcGIS Mapping for SharePoint > Site Settings > Site libraries and lists and make sure ArcGIS component is deployed.
Issue: Getting "fail to connect to database" error while installing the ArcGIS Mapping for SharePointSolution: Check if the user had required permissions to connect to SQL database:
  • Go to the Services, make sure "SharePoint 2010 Administration" and "SQL server" are running.
  • Right-click the setup.exe wizard to "Run as Administrator"
  • If the above step did not work, go the the Server Manager 'Local Users and Groups ' Group and check the following three groups: WSS_ADMIN_WPG, WSS_RESTRICTED_WPG_V4, and WSS_WPG. Make sure your account is added in these three groups.
  • Ensure that you can login to the SQL Server Management Studio.
  • In the SQL Server Management Studio, go to Security/Logins folder, right-click on your login account and choose “Properties”. In the Login Properties, select "Server Roles" on the left and make sure "sysadmin" role is checked.
  • In the SQL Server Management Studio "Login Properties" window, select "User Mapping" on the left and select "Sharepoint_Config" item. Make sure the "WSS_Content_Application_Pools" database role is checked.

For more details regarding this error, check this KB article.Shwetambari G. - SDK Support Analyst