Skip to Content
0

Error connecting SQL Server on SAP B1 9.2 SLD

Feb 09, 2017 at 12:20 PM

300

avatar image
Former Member

Hi,

On SAP B1 9.2 PL3, I have successfully installed SLD.

But when trying to add the SQL server system is giving me the error as 'Error while connecting to the SQL Server'. Please find below the screen shot.

Can anyone help me on this?

Regards

Sonil

error.png (23.6 kB)
10 |10000 characters needed characters left characters exceeded
Former Member

you able to ping the sql server from SAP BI machine?

Try adding SQL server entry in host file.

Regards,

Amit T

0

Hi Sonil,

Please check if you created a SBO-COMMON database on MSSQLServer according at your instalation Business One Server steps.

0
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Balaji Selvaraj Mar 01, 2017 at 11:55 AM
2

Hi Sonil Garg,

What is the SQL server login name is it with named instance or default based on it if its named try to add port along with server name.

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 14, 2017 at 05:04 AM
1

Hello,

Make sure that you have enabled TCP/IP Protocol and TCP Port is set to 1433, you can check it under SQL Server Configuration Manager.

Regards,

Engr. Taseeb Saeed

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 10, 2017 at 05:04 AM
-1

Hi Amit,

Thanks for your reply.

Can you please help me more about how shall I host the SQL in host file.

Regards

Sonil

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Feb 10, 2017 at 07:10 AM
0

Hi,

1. Make sure SQL is running under Service and sa password is correct.

2. Disable if any antivirus and windows firewall.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 14, 2017 at 04:56 AM
0

Hi,

It's still not working.

Regards

Sonil

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 03, 2017 at 07:22 AM
0

Did you open service manager?

Share
10 |10000 characters needed characters left characters exceeded