Help regarding SQL Server (2016) for SAP Business One 9.3

[former_member557544]

Hello Everyone

I am presently installing SAP BOne 9.3 on the new SQL Server 2016.I am worried regarding the softwares and services that should be present on the SQL Server before we start installing SAP B1 9.3 software.My Infra team has also not done before.Can anyone please help me regarding this.I have listed down following SAP Components that should be there but I am worried for other services or softwares on SQL Server 2016.It will be really a great help.

Have a nice day! 🙂

Thanks & Regards

Remote Support Platform for SAP B1SAP B1 Browser Access Server GatekeeperSAP B1 Client 64 bitSAP B1 Client AgentSAP B1 DTW WorkbenchSAP B1 DTW Workbench x64SAP B1 DI API 32 BitSAP B1 DI API 64 BitSAP Business One Server Tools (32 bit)SAP Business one Studio 64 bitSAP Crystal Reports runtime engine for .NET Framework 32 bitSAP Crystal Reports runtime engine for .NET Framework 64 bitCoresuite Cloud Connector

[kothandaraman_nagarajan · Accepted solution]

Hi,

1. Make sure port 3000-30010, 40000 and 1433 are open in Windows server.

2. Confirm there is enough space for install SQL server, Crystal report and other components

3. Confirm enough space for backup of databases.

Once confirmed above,

1. Install SQL server 2016

2. Install Crystal report

3. SAP B1 - all services will be installed automatically.

4. RSP - Install as last step.

Follow Administrative guide for installing SAP B1.

Regards,

Nagarajan

[former_member557544]

Hello Mr.Nagarajan

Thank you for reply.I will try to find 🙂

Wish u a nice day!

Best Regards

Anushka

[kothandaraman_nagarajan]

Hi,

You are most welcome. I am not sure about below programs and its purpose,

1. Classic ShellLicence Service : From where do we get this?

2. HPE Data Protector A.09.09Microsoft Monitoring AgentMicrosoft Report Viewer 2012 Runtimesql server 64 bit and 32 bit

3. SQLLanguge serviceSQLcompiler servicesql server data tier

Please follow administrative guide for requirements and installation.

Regards,

Nagarajan

[former_member557544]

Hello Mr.Nagarajan

Thanks a lot for your quick reply.I just compared mine old server, where sap B1 9.2 was there and new SQL 2016 server which my infra team got ready.

I have seen following services were not there?

Is it stil okay if i go ahead without all these or is anything important out of them to be installed.

I am sorry if i am asking senseless questions but I have no experience from server side 🙂

Please let me know!

Thanks again!

Best Regards

Anushka

Classic ShellLicence Service : From where do we get this?HPE Data Protector A.09.09Microsoft Monitoring AgentMicrosoft Report Viewer 2012 Runtimesql server 64 bit and 32 bit: Are both needed if we have 64 bit SAP B1 client?SQLLanguge serviceSQLcompiler servicesql server data tier application Framework (x86)Microsoft system CLR Types for SQL Server 2014 and 2016 : 32 or 64 bit ?Microsoft visual C++ 2010/2015 RuntimeVisual Studio 2010 Prequisties english