SQLAnywhere service creation on Windows server

  • KM03644825
  • 26-May-2020
  • 26-May-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

SQLAnywhere service creation on Windows server

Error

In some cases Business Objects SQLAnywhere service is not created after installation on Windows.

Cause

There is some issue while install the BO packages so it needs manuall install afterwards.

Fix

Run below in CMD:

dbsvc -t Network -s Automatic -as -sn "SQL Anywhere for SAP Business Intelligence" -sd "Provides the CMS repository and auditing database for SAP Business Intelligence" -y -w "SQLAnywhereforBI" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\bin64\dbsrv17.exe" -n BI4 -x tcpip(PORT=2638;DoBroadcast=NO;BroadcastListener=NO) "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_CMS.db" "D:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_Audit.db" -o D:\SQLAW.log

 

Verify is created and start if needed.