cancel
Showing results for 
Search instead for 
Did you mean: 

How to setup MS-SQL Server connection in SAC 2019.9 version

bosegsap
Participant

Hi Team

I hold Admin privileges & trying to define MS SQL Sever connection using SQL Databases option under Connection

While defining connection in below window, passing below info

for Location -> Default Location

Connection Type-> I couldn't see any info in the drop down

Please suggest

Regards

Bose

Accepted Solutions (1)

Accepted Solutions (1)

MateKiss
Explorer
0 Kudos

Dear Bose,

Thank you for the provided summary.

Have you followed the below help guide about creating import data connection to an SQL Database?

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd011...

In case, yes could you please let us know if any of the steps during the configuration is failing?

Best Regards,
Mate

bosegsap
Participant
0 Kudos

Mate

all steps went fine without any error

Regards

Bose

Answers (3)

Answers (3)

MateKiss
Explorer

Dear Bose,

Thank you for the confirmation.

Some more questions to narrow down the issue:

  1. What is the result if you go to System >> Administration>> Datasource Configuration and click on "Check configuration" for the default location?
  2. Have you deleted the "#" of the databases you would like to connect to and entered the path to the driver as the property value from the .properties file?
  3. Do you get any error in the Google Chrome Dev Tool Network panel when trying to create the new SQL connection?

Best regards,
Mate

bosegsap
Participant
0 Kudos

1)Default location

2) NA

3) No

0 Kudos

What type of SAC license do you need to establish a connection to a sql database? Is it possible to establish it with the "Business Intelligence" license? Thank you!

bosegsap
Participant
0 Kudos

Hi All

Thank you all for your support.

BR

Bose

former_member36448
Discoverer
0 Kudos

I have exactly the same problem..

I have done the installation manually and with SCC development kit. I have correctly configured the .properties file, with the correct JDBC, tested with different databases, I have restarted tomcat but the problem is always the same .. I can´t select the Connection Type when a I try to create a new sql data import connection..

the connection test from SAC in Administration tab is correct .. Please, how did you solve this error?