CMC - database connection string

[Former Member]

Hi,

I'd like to change server name in my DataServices connection in CMC (CMC -> DataServices).

Does anybody has idea where can I change Database Connection String which is autmated filled in CMC-> DataServices -> Repository ?

Every time when I want to connect to this repository database I'm getiing infoamtion with error of connection where is information with old server name

My DS version: 4.0 SP3

I'm

Regards

[Former Member]

Try changing the Database Connection using Repository Manager.

[Former Member]

Hi,

I tried: get version and upgrade version options in Repository manager and still I see old server name. I don't wan't to create this repository one more time because I have a lot of processes and I will lose it.

Maybe here is somwhere table where I can update this data?

[Former Member]

Hi Rad,

As per my understanding from your query, there is nothing to do with "get version and upgrade version in SERVER MANAGER" .

Can you please show the screenshot what exactly are you looking for.

As per my understanding you are looking for changing DSN( database source name) or Database connection string , which you can create at control panel and change at Information Plateform Service.

Caution: Before changing any details for Repository ( let it be very small thing that even does not even gives any effect) please take backup of your repository ( Database that holds Local Repository).

For more clarification please post the screenshot.

Thanks & Regards,

Shiva Sahu

[Former Member]

Hi Shiva,

yes it's a Database connection string. I will check your idea and will back to inform if it's working.

Regards

[Former Member]

Hi Shiva

Below is screen where I see - Database Connection String - the field which I'd like to change

[Former Member]

Hi Rad,

I am not sure if you can change this field because this field get filled by SAP Data Services not by us.

Regards,

Shiva Sahu

[Former Member]

But where it's in DataServices?

Should I create new ODBC or something change in DataServices?

[Former Member]

Hi Rad,

Below mentioned is as per my limited assumption and knowledge which may or may not correct and helpful to you.

It(Database Connection String ) is not in data services , it is something which is registered at registry level (while the time of installation ) and used by any  application to communicate to other application ( in some instances you may say it as computer name ).

Regards,

Shiva Sahu

[Former Member]

Hi Shiva,

thank you for your help. In my opinion it's possible to change it not only from intstallation level but I don't know how to do it yet

I think I will create message to SAP

Regards

[Olj]

Hi Rad,

did you change database connection string is CMC?
I have the same problem.

[Former Member]

Hi Daulet,

I changed it after many hours searching everywhere

In short way you have to open table AL_MACHINE_INFO from your DS repository and find record SERVER_NAME = ‘RepoManager’ and in this record is DatabaseConnectionString. Update it into new server and it should works. Of course change job server/odbc etc. after that

In my situation it was in seqnum = 5

update AL_MACHINE_INFO

set RESERVED2 = 'SQLxxxxx\SQLxxxxx'

where AL_MACHINE_INFO.SEQNUM = 5

Regards

[Olj]

Thank you Rad Nap!