Error while installing SAP B1

[deepanvip]

Hello experts,

I am attempting to install SAP B1 version 10 patch level 2305 and SQL version 2017. However, I encountered an error while trying to install SLD/server tools.

[10:50:37][WARNING] Step [installer-step-mssql-database][ResponseValidator] The connection to SQL Server failed. Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434. For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

Note:

1. The SQL Server Browser Service is already running.

2. I have also turned off the windows firewall.

Please advise me on hove to solve this issue.

2023-10-11comsapbusinessonein.txt

[wenli_chen]

Hi deepanvip,

1. You can use netstat command to check the port status for ports.

40000 - used for installing SLD

1433/ 1434 - http port for sql server

2. check if SQL Server could be connected via TCP/IP protocol. (You can check it via SQL Server Management Studio -> connect to Server -> Options -> Connection Properties -> Select Network Protocol: TCP/IP -> click on connect

Then please check if TCP/IP protocol is Enabled also in object SQL Server Network Configuration --> Protocols for MSSQLSERVER.

Regards,

Relle

[Sriram2009]

Hi Deepan,

Thanks for your information,

1. Are you able to ping the MS SQL Server host? or DNS resolutions

2. Once again you may have to check the firewall settings on DB and SAP B1 installation servers. refer to the SAP help portal link

https://help.sap.com/docs/SLTOOLSET/d7dfdcbeb0d14de9a17c7e07ecb08565/c7a6e99a69a3403fa9c114adbe3336d...

3. Check this SCN tread common error about the :Connection refused"

https://answers.sap.com/questions/10026609/installing-b1if-on-a-application-server-and-a-db-s.html

Regards

SS

[Sriram2009]

Hi Deepin,

Have you installed the MS SQL client components? From the server are you able to connect the MS Sql management console?

Regards

SS

[deepanvip]

Yes, I have installed all the components and I am able to connect to SQL server management studio.

[Sriram2009]

Hi Deepan,

Could you share the full error message as text format?

Regards

SS

[deepanvip]

s.sriram

I have attached the log in the question.