CA Service Management

 View Only
  • 1.  Error configuring service desk

    Posted Sep 03, 2020 03:58 PM
    Hello,

    I'm doing a fresh installation of 17.1 Service Desk on a Windos Server 2016 with a remote DB MS SQL 2016.

    I'm using a sysadmin, sql authentication user.

    During the installation it fails on installing remote schema of the db and it shows this error later on configuring SDM:

    I have checked all the DB settings with the broadcom team and nothing works...

    Any suggestions of what we should check?

    Regards.


  • 2.  RE: Error configuring service desk

    Posted Sep 03, 2020 07:47 PM
    Was any part of the mdb created? Does any error show up in the SQL Server logs?

    I always install SQL Server Management Studio on the Windows server on which I am going to install the Service Desk server before I do the install. That way, I can test the account that has sysadmin rights and test it first.

    Cheers

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------



  • 3.  RE: Error configuring service desk

    Broadcom Employee
    Posted Sep 04, 2020 05:15 AM
    In addition to what @Lindsay_Estabrooks mentioned, see this KB article:

    https://knowledge.broadcom.com/external/article?articleId=17125​

    ------------------------------
    Kind Regards,
    Brian
    ------------------------------



  • 4.  RE: Error configuring service desk

    Posted Sep 04, 2020 10:45 AM
    Hello Brian,

    The link doesn't work:



  • 5.  RE: Error configuring service desk

    Posted Sep 04, 2020 10:44 AM
    Hello Lindsay,

    Yes, the mdb is created and like 6-7 seven tables are created. On the logs i see some login failed but i doesn't understand why because testing wth the Management Studio from the app server it works fine.


    Regards.


  • 6.  RE: Error configuring service desk

    Posted Sep 04, 2020 10:35 AM
    Hi all,

    I had the same situation and I found the problem was the support of TLS from the SQL Server Client I resolved instaling a patch from Microsoft

    https://www.microsoft.com/en-us/download/confirmation.aspx?id=50402

    Greetings,
    Ricardo Lorenzi


  • 7.  RE: Error configuring service desk

    Posted Sep 04, 2020 10:47 AM
    Hello Ricardo,

    That patch is installed on the SDM server?


    Regards.


  • 8.  RE: Error configuring service desk

    Posted Sep 04, 2020 10:53 AM
    Yes

    Ricardo Lorenzi

    Consultor

    Netnix SA

    Av Caseros 3405 Piso 7

    (C1263AAD) Ciudad Autónoma de Buenos Aires, Argentina

    Tel: +54-11-3220-1710 • Cel: +54-911-2761-0201

    Email: rlorenzi@netnix.net