Skip to Content
avatar image
Former Member

Error connecting SQL Server on SAP B1 9.2 SLD

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Mar 01, 2017 at 11:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2017 at 05:04 AM

    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

    Add comment
    10|10000 characters needed 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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 10, 2017 at 07:10 AM

    Hi,

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

    2. Disable if any antivirus and windows firewall.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 14, 2017 at 04:56 AM

    Hi,

    It's still not working.

    Regards

    Sonil

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2017 at 07:22 AM

    Did you open service manager?

    Add comment
    10|10000 characters needed characters exceeded