Customer Checkout Manager embebed in SQL database

[diana_smc]

Hi all,

To set up the customer checkout manager, for the database management system I decided to go for the SQL and I followed what SAP recommended which was to to create a separate Microsoft SQL Server instance in order to install SAP Customer Checkout manager.

I also created the CCOS database and schema with the same name with the sa user in this new instance.

When connecting the C.C. manager, on the database string option I put:

jdbc:sqlserver://BE1SVM66\CHECKOUT:1433;databaseName=CCOS

It was giving a error saying it's impossible to access the database CCOS.

As a workaround I create the same database in default instance and worked.

My question is, Is any problem to have the CCOS database in the same instance of SQL as the other databases?

[R_Zieschang · Accepted solution]

Hi Diana,

you should remove the port number in your connection string. When connecting to mssql instances via jdbc you may not include the port number.

As an alternative you also may try this syntax:

jdbc:sqlserver://<hostname>;instanceName=<instance_name>;databaseName=<database_name>

Let me know, if this worked for you.

Kind regards

Robert

[diana_smc]

Hi Robert

Thanks a lot for your help and sorry for the delay.

Yes, it worked. I just needed to set up first the new instance with TCP/IP port for a different port. I used 1434.

Also, I restored the CCOS database in the new instance in order to use the same data but when I logged in in the CC manager, the data was lost. Do you know why didn't assume the data?

Last question, what is the consequence of using the same instance, do you know?

Thanks a lot

Diana

[R_Zieschang]

Hi Diana,

have a look at (I assume you used a windows machine) C:\SAP CustomerCheckout Central Server\config\app_default.properties.

CCOm saves it's jdbc connection string in this file. Maybe it's still linked to the wrong sql instance.

hth

Regards

Robert

[R_Zieschang]

Hi Diana,

were you successful?

Kind regards

Robert