DS 4.0 Cannot add Repository in CMC

dataservices administration
1

When I try to create a connection to the repository in the CMC I get a message that says:

“There is a problem to connect to repository: This driver is not configured for integrated authentication.”

How do I enable that so I can create repository connections?

Thanks

fblau (BOB member since 2005-02-07)

2

are you trying to use windows authentication for SQL Server Repo ?
is SQL Server authentication working ? what is the version of SQL Server ?

manoj_d (BOB member since 2009-01-02)

3

Yes, we are trying to use Windows Authentication.

We do not have the option to use SQL Server Authentication.

This is SQL Server 2008 R2.

Thanks,

fblau (BOB member since 2005-02-07)

4

is the user login under which the SIA/tomcat service is running has acess to the SQL Server 2008 Database ?

manoj_d (BOB member since 2009-01-02)

5

fblau,

I am experiencing the same error when trying to add a repository. Did you get a resolution yet. I am also using windows authentication.

thanks,

bv

basisvasis (BOB member since 2011-08-01)

6

Yes, the user that the SIA and Tomcat is running as has permissions to the database where the repository lives.

From my diagnosis… the CMC uses a JDBC connection/driver to “test connection” to the Repo before saving it.

But there is no way to configure the settings for that driver to support the Integrated Authentication mode.

fblau (BOB member since 2005-02-07)

7

there is one more issue in DS 4.0 and windows auth for SQL Server, windows authentication requires sqljdbc_auth.dll, and this should be loaded only once, but from DS 4.0 the connection is being made from 2 different webapp (CMC and ManagementConsole), so the connection is successful from either of this

if test connection is successful in CMC then management console will give this error, if you restart the tomcat and connect from Management console first, then test connection will give this error

to workaround this
stop tomcat
Copy the C:\WINDOWS\system32\sqljdbc_auth.dll to <BOE_HOME>\Tomcat6\bin\win64_x64 folder, so this will be loaded by tomcat itself as common dll on startup and driver will not try to load it instead will use already loaded reference
Start tomcat

manoj_d (BOB member since 2009-01-02)

8

I have followed your instructions verbatim, changed all 3 services to user that have access to sql database, yet I still encounter the problem when attempting to use Windows auth but still get the error. SQL auth is not an option for us here - must be windows auth as it is a super secure environment…ideas. Thanks!

ChitraliC (BOB member since 2011-02-24)

9

did you restart the tomcat after copying the DLL ?

manoj_d (BOB member since 2009-01-02)

10

sure did - also stopped all services, set to manual, rebooted and then restarted them as well and no luck

ChitraliC (BOB member since 2011-02-24)

11

fblau/chitralic,

did you find a resolution to this ? I tried as suggested by manoj but it didnt work for me.

basisvasis (BOB member since 2011-08-01)

12

the the problem could be something else

few other things to check

  • create a system DSN and use Windows Authentication and see if that works, make sure that you are logged into to machine with the same logon as DataServices Service and Tomcat are running with

manoj_d (BOB member since 2009-01-02)

13

i already have a system DSN and it is set to windows NT authentication. I am logged onto the machine as the Administrator and thats the user under wchich tomcat and SIA are running.

basisvasis (BOB member since 2011-08-01)

14

same here - there are more problems than just that, really is quite frustrating that SAP would release a product that doesnt even work - spent a week testing this to upgrade our prod box. I get all kinds of memory errors and crashes with the designer. For now I guess we will stick with 3.2, which is unfortunate because of the memory limitations. Additionally, I dont think 4.0 works with the BPDM package.

ChitraliC (BOB member since 2011-02-24)

15

the workaround that I mentioned (copying of sqljdbc_auth.dll) is applicable in case you are able to do test connection successfully in CMC for DS repo using Windows authentication and having problems in opening Management Console

if the test connection is failing in CMC for winAuth even after changing the tomcat service logon then the problem is something else, I am not able to reproduce the problem other than the one mentioned above

can you file a case with Support ?

manoj_d (BOB member since 2009-01-02)

16

The current solution that we have been given by SAP is that the issue is with both the CMC and the DSAdmin webapps trying to share a single sqlauth.dll.

We were told that this is being fixed in an upcoming patch.

Workaround would be to have two separate Tomcat installs with one on each.

fblau (BOB member since 2005-02-07)

17

if the issue is because of sharing of sqljdbc_auth.dll then you don’t need to have spearate tomcats for BOE and DS, that should be resolved by copying the dll to tomcat\bin\win64_x64

is this a different ticket than the install issue, can you give me the ticket number of this as well

manoj_d (BOB member since 2009-01-02)

18

2 separate issues for us.

fblau (BOB member since 2005-02-07)

19

is it SAP Incident # 600396 / 2011 ? if yes, I am working with support on this case, and waiting for update from customer, actually I want to take a look at your env

if possible can you update the case, I will have support setup a call, and if time permits I can take a look at your install issue

manoj_d (BOB member since 2009-01-02)

20

Manoj,

Already have a case opened, also talked to you a few days ago :slight_smile: but still dont have the solution from you. Hope you resolve it soon.

Thanks,

BV

basisvasis (BOB member since 2011-08-01)