Can we install SUP 2.2 with MS SQL Server as Database

[former_member201782]

Hi All,

I would like to do installation of SUP 2.2 with MS SQL Server as Database.

Can anyone share document if you have any?

Thanks,

Srikanth

[Lyle_Johns · Accepted solution]

Good day Srikanth

The short answer is No, SUP comes pre packaged with SQL Anywhere and uses propriety methods for the both the RBS and MBS communication methods allowing for monitoring etc. to be done with the packaged database tools.

Using MS SQL for a data source is possible but not for the cache DB.

Regards

Lyle

[former_member201782]

Thanks for your inputs Tahir and Lyle.

Regards,

Srikanth

[former_member201782]

Thanks for the information Vikas.

@Tahir.. I want to use MS SQL Server as database instead of SQL Anywhere at the time of installation.

Thanks.

[tahir_z]

Not possible, as i know at installation time there is no any step to choose database instead of SQL Anywhere.

Regards

Tahir

[tahir_z]

Hi,

Can you eleborate your demand ? Do you want to connect to MS SQL server from SUP or do you want to use MS SQL instead of SQL Anywhere database which SUP uses for storing caches?

Regards

Tahir

[Former Member]

Hi Srikanth,

Yes you can add MS SQL server to your SUP 2.2 SDK. Although i don't have any step by step document for that but may be below steps can help:

1. In you SUP SDK, right click to add new Database connection

2. Select SQL Server from the list

3. Configure drivers using the delta sign on top rigth of popup window

4. You need to have sqljdbc4.jar or sqljdbc.jar as per the version.

5. You can use integrated authentication based on your sql db configurations/ access

6. Test connection and finish

7. You will see one more DB available along with My Sample Database in Enterprise Explorer.

Hope this helps,

Vikas