Connector Errors: Sphere Integration Service not connecting to server

After updating the Connector on the server, the following errors occur in succession on the log tab of the Scheduler:

Error: Batch not initialized. Check Configuration / Sphere connection.

Error: Sync has been disabled.
 
Error: @end_date is not a parameter for procedure _sp_batch_init.

 

Try each of the following until the issue is resolved:
  1. Verify the user is logged in as a local administrator.
     
  2. On the machine where the service is installed, go to Start > Run > Services.msc:
                      o Locate Integration Service [Account ID] and verify this matches your organizations Blackbaud Sphere Account ID
                      o If the Sphere Account ID is incorrect, Uninstall/Reinstall the Connector with the correct Account ID.
     
  3. Ensure the Connector service is installed on only one machine.
     
  4. Check Help/About Sphere Integration on all machines to ensure each connector instance has been updated.
     
  5. Verify the Server Name is correct:
                      o  To locate server name: On the Server: Start > Right Click on My Computer > Computer Name Tab.
                      o To edit server name in Connector: The Raiser's Edge > Sphere > Scheduler > Configuration > Sphere Host Connection.
     
  6.  Verify you can log in to Sphere with the Connector Username and Password:
                      o If you are unable to login, reset the connector user password
                      o  Enter the new password in RE > Sphere > Scheduler > Configuration > Sphere Connection.
     
  7. Ensure  network's proxy and firewall settings are valid.
     
  8. Change the user running the integration service from local system to Administrator:              
                     o  
    Start > Run > Services.msc > Integration Service [Account ID
                     o   Right click > Choose Properties > Logon Tab
                     o   Select second radio button , enter Administrator username/password
                     o   Apply & OK > Restart Service
     
  9. Uninstall and Reinstall the latest version of the Connector.
If you are still receiving the errors, please Chat With Support and reference this article. .

Environment

 4.0.5.4 ; 4.1.0.1 ; 4.0.4.2

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.