FlexNet Manager Suite
2022 R1
(On-Premises)
Once you have selected your staging server to be used with your adapter, and that
staging server can access an operating implementation of Microsoft SQL Server running a
database instance you intend to use for the staging database, you should use the script
provided to create the staging database and set up the appropriate database tables
within it. This can be done from SQL Server Management Studio, or from the command line
as described in the following procedure.
To create staging database tables from the command line:
-
Navigate through the unzipped archive to Adapter Tools
for FlexNet Manager Suite 2022 R1.zip > BMC Atrium Discovery and Dependency Mapping Tools >
SQL.
-
If necessary, copy the script ADDM_staging.sql
from the \SQL folder of your unzipped adapter archive to a
temporary folder on your staging server.
-
Open a command prompt on the staging server, and navigate to
the folder containing the script.
-
In the command prompt window, execute the following command,
as amended:
sqlcmd -S ServerName\InstanceName -i TemporaryPath\ADDM_staging.sql
where:
-
ServerName is the name of the database server hosting the
staging database, or its IP address, or “
.
” (dot) if you are
running the staging script on the same server as the database instance
-
InstanceName is the name of the database instance to use for
the staging tables (this parameter may be omitted if the instance is the
default instance)
-
TemporaryPath is the location where you saved the SQL
procedure.
Example:
sqlcmd -S 192.100.0.20\Development -i C:\temp\ADDM_staging.sql
The database ADDM_Staging
is created with all necessary
tables, indices, and so on.
-
Ensure that the account under which the adapter executable will run has
read/write/execute permissions on this database instance.
Tip: Configuration of the account is done through SQL Server
Management Studio.
Authentication may be through Windows NT authentication
or SQL Server authentication. Using Windows NT authentication:
- The default account is the username running the
FnmpADDMStage.exe adapter
- The SQL connection is specified as a standard connection string, which you may
supply in FnmpADDMSettings.xml, or override with the
-c
option on the command line.
The staging database is now ready for operation.
FlexNet Manager Suite (On-Premises)
2022 R1