Configuring this setting will create SQL Server database connection profile for DBM Tools
SQL Server: This should be the name of the server, fully qualified if necessary.
Including SQL instance and\or port number if applicable
Examples
SQLServer01
SQLServer02.MyDomain.local
SQLServer03\MyInstance
SQLServer04,1433
SQLServer05\MyInstance,1433
Example using IP Address instead of server name
192.168.1.2
192.168.1.3\SQLInstance1
192.168.1.4,1433
192.168.1.5\SQLInstance2,1433
Database: This should be the name of the database to connect to.
You can find the name of the database by connecting to the server with SQL Server Management Studio.
Type: This should be the type of database, meaning software platform.
Choose from the list of supported software.
If your software is not listed here but is supported, you may be using an outdated version of the GP template; update your template by running the GP template install script again, which can be downloaded from DBMTools.com
Note: This GP setting will configure the connection profile to use integrated security.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | DBMToolsSqlServer3 |
Value Type | REG_DWORD |
Enabled Value | 1 |
Disabled Value | 0 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLServer3 |
Value Type | REG_SZ |
Default Value |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLDatabase3 |
Value Type | REG_SZ |
Default Value |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | American Contractor |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | ComputerEase |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | DBM Tools |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | Spectrum V13 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | Spectrum V14 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | Timberline Office |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | Viewpoint |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\DBMTools\DBProfiles |
Value Name | SQLPlatform3 |
Value Type | REG_SZ |
Value | Other |