Skip to Content (Press Enter)
2022-08-31 18-26-36
Easy Batch
20Views
4Comments
Solved
Database credentials to access detached application
Question
Traditional Web
Application Type
Traditional Web

Hi dears,

I have a detached OS application and I intend to move the servers to another cloud provider. I am aware of the configuration file that has the credentials for accessing the database. However, they are all encrypted. How do I replace them with the new database credentials? 

Best Regards,

Roberto Campos


0
0
02 Feb 2024
Copy Link
2022-08-31 18-26-36
Easy Batch
Solution

Hi Bas de Jong,

You are correct. I put the OS Users OSADMIN, OSRUNTIME, OSADMIN_LOG, OSRUNTIME_LOG and OSTATE with all rigths, using the sql command GRANT CONTROL TO and it worked.

Thanks,

Roberto

See solution in context
1
0
08 Feb 2024
Copy Link
2022-08-31 18-26-36
Easy Batch

Hi Bas de jong,

Thank you very much. I followed the steps in the document, and I managed to get my application to log in to the database with success. But now this error message comes:

SELECT permission was denied on the object 'ossys_Espace', database 'OUSTYS_MAIN', schema 'dbo'

This database has a backup of the original Outsystems Database where the application is running. Do you have any idea what it is ?

Best regards,

Roberto



0
0
07 Feb 2024
Copy Link
2023-04-19 18-38-51
Bas de Jong

Probably the user to access the database has insufficient rights. You have to set this up in the sql server. However I'm not sure how to do that...

0
0
07 Feb 2024
Copy Link
2022-08-31 18-26-36
Easy Batch
Solution

Hi Bas de Jong,

You are correct. I put the OS Users OSADMIN, OSRUNTIME, OSADMIN_LOG, OSRUNTIME_LOG and OSTATE with all rigths, using the sql command GRANT CONTROL TO and it worked.

Thanks,

Roberto

1
0
08 Feb 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.