AnsweredAssumed Answered

Can we create a core and back office database in MS SQL Server 2012 by running the Unix Installer on AIX box.

Question asked by Ajay Dhyani on Jan 11, 2019
Latest reply on Jan 11, 2019 by Jasmine Zakir Hussain

Like • Show 1 Like1
Comment • 6

Hi All,

I have few questions regarding RSA AAOP 7.3 installation. Any kind of help will be highly appreciated !!!

1. I am trying to install a RSA AAOP 7.3 on my AIX operating system and where I have setup MS SQL Server 2012 for the RSA database creation on my Windows box. Now, I just have a question that is it possible to create the core and back office databases by running the RSA AAOP 7.3 Unix installer from my AIX box or do I need to run the Windows installer on the MS SQL Server box separately to configured the core and back office databases.

2. As per the installation guide I have to download sqljdbc4.jar for MS SQL Server 2012 but this version is no longer available in Microsoft download central. Is their any other authenticated source from where I can download this jar file or if I download any other available version of this jar file than is their any dependent file on RSA AAOP installer where I have to made any changes. .

3. Do I need to place the downloaded jar in both AIX and Windows box or is it needs to be placed only in AIX box from where I am going to deploy and run the RSA AAOP.

Thanks in Advance !!!

Thanks,

Ajay Dhyani,

Farshad Mahjoubi

Jan 11, 2019 10:14 AM

Correct Answer

Hi Ajay,

(RSA answer on question 1), Yes you can generate the MSSQl scripts on Linux and then run them on your database.

(RSA answer on question 2), sqljdbc.jar or sqljdbc4.jar it is should work.

(RSA answer on question 3) You need to place the sqljdbc.jar file in the AIX lib directory of your appserver where you deploy the WAR files only and then configure your datasources from app server to point to the database.

Hope this helps, please let us know if you have any other questions. We have released 7.3 P5. You should really upgrade to that release.

Regards,

Farshad

See the reply in context

No one else had this question

Outcomes

Erica Chalfin

Jan 11, 2019 8:42 AM

Ajay Dhyani,

I've moved your question to the RSA Adaptive Authentication space where it will be seen by the product's support engineers, other customers and partners. Please bookmark this page and use it when you have product-specific questions.

Alternatively, from the @RSA_Customer_Support page, click on Ask A Question on the blue navigation bar and choose Ask A Product Related Question. From there, scroll to RSA Adaptive Authentication and click Ask A Question. That way your question will appear in the correct space.

Regards,

Erica

Actions

Farshad Mahjoubi

Jan 11, 2019 10:14 AM

Hi Ajay,

(RSA answer on question 1), Yes you can generate the MSSQl scripts on Linux and then run them on your database.

(RSA answer on question 2), sqljdbc.jar or sqljdbc4.jar it is should work.

Hope this helps, please let us know if you have any other questions. We have released 7.3 P5. You should really upgrade to that release.

Regards,

Farshad

1 person found this helpful

Actions

Ajay Dhyani @ Farshad Mahjoubi on Jan 11, 2019 11:10 AM

Hi Farshad,

Thank you so much for your prompt response. Can you please also help me to know from where I can get sqljdbc4.jar as it's no longer provided by the Microsoft.

Thanks & Regards,

Ajay Dhyani,

Actions

Jasmine Zakir Hussain

@ Ajay Dhyani on Jan 11, 2019 11:16 AM

Please use the link below to download the driver

Download Microsoft JDBC Driver 4.1 for SQL Server from Official Microsoft Download Center

Thanks,

Jasmine

Actions

Ajay Dhyani @ Jasmine Zakir Hussain on Jan 11, 2019 11:53 AM

Thaks Zakir for providing me the link. I have downloaded the unix version of it and has extracted it to my Unix box.

Inside the sqljdbc_4.1/enu/jre7 folder I can see sqljdbc41.jar file however I have a query here that will my RSAAAOP 7.3 installer can refer sqljdbc41.jar or do I need to rename it from sqljdbc41.jar to sqljdbc4.jar as in the installation guide sqljdbc4.jar is mentioned. Please advise.

Actions

Jasmine Zakir Hussain

@ Ajay Dhyani on Jan 11, 2019 1:29 PM

You can use it as sqljdbc41.jar or if you would like you can rename it to sqljdbc4.jar but renaming it is not mandatory.

Thanks,

Jasmine

1 person found this helpful

Actions

6 Replies

Erica Chalfin Jan 11, 2019 8:42 AM
Mark Correct
Correct Answer
Ajay Dhyani,

I've moved your question to the RSA Adaptive Authentication space where it will be seen by the product's support engineers, other customers and partners. Please bookmark this page and use it when you have product-specific questions.

Alternatively, from the @RSA_Customer_Support page, click on Ask A Question on the blue navigation bar and choose Ask A Product Related Question. From there, scroll to RSA Adaptive Authentication and click Ask A Question. That way your question will appear in the correct space.

Regards,
Erica
Like • Show 1 Like1
Actions
Farshad Mahjoubi Jan 11, 2019 10:14 AM
Unmark Correct
Correct Answer
Hi Ajay,

(RSA answer on question 1), Yes you can generate the MSSQl scripts on Linux and then run them on your database.
(RSA answer on question 2), sqljdbc.jar or sqljdbc4.jar it is should work.
(RSA answer on question 3) You need to place the sqljdbc.jar file in the AIX lib directory of your appserver where you deploy the WAR files only and then configure your datasources from app server to point to the database.

Hope this helps, please let us know if you have any other questions. We have released 7.3 P5. You should really upgrade to that release.

Regards,
Farshad
1 person found this helpful
Like • Show 1 Like1
Actions
- Ajay Dhyani @ Farshad Mahjoubi on Jan 11, 2019 11:10 AM
  Mark Correct
  Correct Answer
  Hi Farshad,
  
  Thank you so much for your prompt response. Can you please also help me to know from where I can get sqljdbc4.jar as it's no longer provided by the Microsoft.
  
  Thanks & Regards,
  Ajay Dhyani,
  Like • Show 0 Likes0
  Actions
  - Jasmine Zakir Hussain @ Ajay Dhyani on Jan 11, 2019 11:16 AM
    Mark Correct
    Correct Answer
    Please use the link below to download the driver
    
    Download Microsoft JDBC Driver 4.1 for SQL Server from Official Microsoft Download Center
    
    Thanks,
    Jasmine
    Like • Show 0 Likes0
    Actions
    - Ajay Dhyani @ Jasmine Zakir Hussain on Jan 11, 2019 11:53 AM
      Mark Correct
      Correct Answer
      Thaks Zakir for providing me the link. I have downloaded the unix version of it and has extracted it to my Unix box.
      Inside the sqljdbc_4.1/enu/jre7 folder I can see sqljdbc41.jar file however I have a query here that will my RSAAAOP 7.3 installer can refer sqljdbc41.jar or do I need to rename it from sqljdbc41.jar to sqljdbc4.jar as in the installation guide sqljdbc4.jar is mentioned. Please advise.
      Like • Show 0 Likes0
      Actions
      - Jasmine Zakir Hussain @ Ajay Dhyani on Jan 11, 2019 1:29 PM
        Mark Correct
        Correct Answer
        You can use it as sqljdbc41.jar or if you would like you can rename it to sqljdbc4.jar but renaming it is not mandatory.
        
        Thanks,
        Jasmine
        1 person found this helpful
        Like • Show 0 Likes0
        Actions

Can we create a core and back office database in MS SQL Server 2012 by running the Unix Installer on AIX box.

Outcomes

Related Content

Recommended Content