Unsupported database type <Microsoft_SQL_Server> specified as repository

[Former Member]

Unsupported database type <Microsoft_SQL_Server> specified as repository

Getting this error when executing the jobs.. connecting the data services through citrix .

What is the issue causing this error?

Please help!!!!!!!!!!!!

[former_member234353]

Hi Anandhi,

Please confirm from the document if the version of the MS SQL Server is supported by the version of the dataservices.

I faced a similar issue when I was using Dataservices 3.2 and MS SQL Server 2012 and hence had to use odbc to resolve(using the odbc.ini file)

You will usually need to define the ip address of the SQL SERVER and user access for the account that have the admin privilege.

Hope this helps.

Thanks,

AJ

[former_member202812]

Hi ,

Are you using dataservices 4.1 ?

I encountered the same problem earlier . My Job server is on unix, was not able to use database type as SQL SERVER 2008 instead I used ODBC . It worked fine for me .

Thanks,

David King J.

[jeffrey_kresse]

That was a good workaround for 4.1, but for current versions; this note shows that from DS 4.2 onward, native SQL Server connections are supported for unix servers.

[vnovozhilov]

MSSQL Server is not supported to be used as a repository on UNIX machines of any kind. Please see PAM here support.sap.com/pam

The aforementioned note talks about source and target databases only, whereas TS is unable to use MSSQL Server as a repository - it can be seen from the error message (presumably JS machine resides on UNIX).

Thank you,

Viacheslav.

[jeffrey_kresse]

Might be an incompatible (too old, or too new) version of SQL Server. Check Product Availability Matrix for your version of Data Services.

The latest supported SQL server for DS 4.2 is MS SQL Server 2014.