CA Service Management

  • 1.  Cannot connect to mdb database - pdm_confgure

    Posted Mar 28, 2018 01:50 AM

    Hi,

     

    We are using CA service desk 12.6 version and backend DB as sql server 2005.

    Currently we moved this mdb database from 2005 sql to 2008 sql server and trying to configure this in the service desk application server using pdm_configure.

    While doing configuration via pdm_configure after providing the DB details and ServiceDesk login password  it is throwing the error message "Can not connect to mdb database on server nxtdevsdmapp01", "Error running sql script to check permission"

     

    Able to connect to the mdb database via sql client using the ServiceDesk login from the service desk application server.

    Please help us to fix this. Thanks.

     

    Maheswari.K



  • 2.  Re: Cannot connect to mdb database - pdm_confgure
    Best Answer

    Posted Mar 28, 2018 03:34 AM
    • Can you see any SQL error messages in configure.log?  Can you identify the command that is failing?
    • Is the SQL 2008 mdb on the default instance or on a named instance?  If on a named instance then check that you have a static port configured.
    • Is the SQL 2008 mdb marked as SQL 2005 compatible or has it been marked as SQL 2008 compatible?  Do you have the same Client Connectivity version (2005 or 2008) on the application server?
    • Does the servicedesk login have 'db_owner' access to the new SQL 2008 mdb?  Compare the SQL logins and mdb users to the SQL 2005 mdb and make sure that all of the settings are the same on the SQL 2008 mdb.

     

    Hope that helps.  If not then please post configure.log to this thread and we'll see what we can do.  R12.6 is of course out of support, so hopefully you're doing this to set up a 'swing box' for an upgrade to r17.1 :-).

    Regards,

    James



  • 3.  Re: Cannot connect to mdb database - pdm_confgure

    Posted Mar 28, 2018 06:26 AM

    Hi James,

     

    Thanks for your reply.

     

    Problem is resolved.

     

    In the Environment Path variable value for the sql client 2008 we set was wrong. Now the same is corrected and its working fine. Thanks.



  • 4.  Re: Cannot connect to mdb database - pdm_confgure

    Posted Mar 28, 2018 08:23 AM

    Maheswari.K thats great news!  Can you mark the post from camja06 as correct?

    Thanks!

    Jon I.