JanPie
Intrepid explorer

Skip database creation in db configuration process

Hello everyone,

A client would like to install FNMS in environment, where it's not possible to create dbs manually. They need to be requested separately, and then they will be provisioned automatically.

This means, I cannot use the script to perform the database creation part of installation.

Is it possible to just comment out the db creation part of the script and leave whole configuration?

Kind regards,

Jan

0 Kudos
3 Replies
ChrisG
Community Manager Community Manager
Community Manager

Re: Skip database creation in db configuration process

It is safe to manually create the databases prior to running the database configuration scripts as normal. The configuration scripts are smart enough to detect that the databases have already been created, and will not attempt to re-create them.

This is a common approach taken in environments where the user account running the database configuration scripts can be given db_owner rights on the FlexNet databases, but cannot be given sysadmin rights to the entire SQL Server instance.

(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply helped, give me a kudos. If it solves a question you have raised, please click "ACCEPT AS SOLUTION".)
JanPie
Intrepid explorer

Re: Skip database creation in db configuration process

Hi Chris,

This is actually great news! I will test this now, to see how it will work.

0 Kudos
mfranz
Shining star

Re: Skip database creation in db configuration process

Please make sure to pick the right DB settings, especially the dababase collation (e.g. SQL_Latin1_General_CP1_CI_AS)

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos