I already have a Windows-based server with sql server installed and D drive set to the default database location for outsystems1.
In this situation, I am trying to configure additional outsystems2 databases by adding only E drives, but I am contacting you because I am worried that an error may occur when running the Grant Permissions and Create/Upgrade Database buttons with Configuration Tool 11 when installing O11.
I think there won't be a problem with the schema if you create a database in advance and use the Upgrade method,
In the case of permissions, I'm not a DBA and since it's a corporate cloud VPC server, if something goes wrong in the middle, Rollback won't be easy.
In the case of oracle, I know that database creation and authorization are done with sql scripts in advance. In the case of sql server, does it not provide such sql scripts?
Hello @SungGeun Song,
Yes, SQL Server also supports pre-creating databases and permissions manually, similar to Oracle. You do not have to rely only on Configuration Tool automation.
Recommended approach for your case:
Pre-create the catalog/database files on the desired drive (E:). Pre-create SQL logins/users and assign required roles manually. Then use Configuration Tool with Upgrade Database instead of Create. Avoid running Grant Permissions blindly in restricted corporate environments unless validated with DBA.
For SQL Server, OutSystems does not provide standalone SQL scripts officially like Oracle scripts, because Configuration Tool generates them dynamically during execution. So the safest enterprise approach is usually:
DBA creates DB + storage layout manually OutSystems performs only schema upgrade/deployment
This is a common setup in regulated/VPC environments and works fine with O11.Thanks and Regards,Akshay Deshpande
Hello,
You can generate the scripts to create and configure the databases in SQL Server using Configuration Tool. Open it, configure the details of the database and then go to the File menu, choose "Generate Platform SQL Script", "Generate Logging SQL Script" or "Generate Session SQL Script".You can customize the scripts to your needs and execute them.
If you create the database in advance in the location you want, later you can use Grant Permissions in Configuration Tool and it won't change that.