HTTP error: 500 (Internal Server Error) "CreateTab ContentStorage, connect error SQLConnect failed, [SAP AG][SQLOD32 DLL][MaxDB] Invalid au

[Former Member]

Hi,

while creating content server repository am getting below error, kindly help me solve this issue..

Content server 6.4

MaxDB Version: 7.8

HTTP error: 500 (Internal Server Error)  "CreateTab ContentStorage, connect error SQLConnect failed, [SAP AG][SQLOD32 DLL][MaxDB] Invalid au

Message no. CMS025

Diagnosis

Error in accessing via HTTP

500 (Internal Server Error)

"CreateTab ContentStorage, connect error SQLConnect failed, [SAP AG][SQLOD32 DLL][MaxDB] Invalid au

Regards,

Vino

[Reagan · Accepted solution]

Hello

This is what I see

CreateTab ContentStorage, connect error SQLConnect failed, [SAP AG][SQLOD32 DLL][MaxDB] Invalid authorization

You have problem with the connection to the MaxDB database and it is mostly due to authorization or incorrect username and/or password.

Please check these SAP Notes.

Note 706664 - SAP Content Server cannot access database

Note 1829919  - HTTP ERROR 500 - Connect Error SQL Connect Failed, [SAP AG][SQLOD32 DLL][MaxDB] Unable to connect to data source;-709 CONNECT: (database not running), Error Code: -709

Also disable the AdminSecurity parameter in the cs.conf file with value 0 and check.

Good Luck

RB

[Former Member]

Hello,

You must change the LiveCache parameters taking into account you are using Content Server driver.

You should have something like : (For Windows)

E:\sapdb\SA1\db\pgm>odbcreg MAXDB -i -p  "E:\sapdb\SA1\db\pgm" -d sdbodbc.dll

ODBC Driver for 'MAXDB' has been successfully registered

You can confirm this ODBC setup using this command:

E:\sapdb\SA1\db\pgm>odbcad32

MaxDB drivers must appear.

There is a bug into the Content Server installation, especially CS 6.5 the ODBC driver is not registered.

Please let us know if that not fixe you issue.

Regards

Denis Rossi

[former_member327055]

Very Good , you are right

[priyatha_jeyarhaaj]

Thanks Denis Rossi.

[JPReyes]

This is usually a problem with the ODBC driver description on CSADMIN

Instructions on SAP Note 977091 - CS 640 Driver should fix the issue

Regards, Juan

[Former Member]

Hi,

I tried SAP Note: 977091, 698915, 582765, 1764842, 1293399 also..

But it shows same error..

Regards,

Vino

[former_member206552]

Hi Vino

have you tried

Note 301352 - ODBC driver is not registered

Best Regards

Marius

[JPReyes]

Can you post a screenshot of your CSADMIN config and your windows ODBC drivers?

Regards, Juan

[Former Member]

Hi,

yes

Regards,

vino

[Former Member]

Hi Juan,

Pls refer below details..

Regards,

Vino

[Reagan]

Hello

Instead of putting the ContentStorageHost with localhost try with the host name.

Additionally click on the ? mark icon next to the tick mark icon to get the full message.

Good Luck

RB