Directory Sync Pro 5.1.1 install

Directory Sync Pro 5.1.1 install

Directory Sync Pro 5.1.1 install

15 August 2019

08:43

 

Introduction

This guide is a full install of Directory Sync Pro 5.1.1 using an existing SQL database. 

Directory Sync Pro 5.1.1 Install

Launch Directory Sync Pro Installer, click  "Next >" to go to next page.

 

 

1. Click "1 accept the terms in the license agreement" then click "Next>" button.

 

 

 

 

License Details

<<licensedetails.txt>>

 

If you have SQL installed use Advanced

 

 

 

 

 

 

 

 

 

 

It is best practice to use the default directories

 

 

Use browse to find the SQL server.

 

If the server is not available please speak to the DBA admin as the SQL server is not correctly installed.

 

 

Use SA or Windows Authentication.

 

As longs as access is available DSP will work properly.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Reboot if prompted.

 

This is a Windows requirement and will be due to .Net and C++. Please do not ignore the reboot request.

 

 

<<BinaryTree.DirSync.Exchange.exe.Config>>

 

<<DirSyncProLogDatabaseUpdateLog.txt>>

 

<<DirSyncProDatabaseUpdateLog.txt>>

 

<<BinaryTree.DirSync.UI.exe.config>>

 

 

 

 

 

 

 

Database Tables and indexes.

 -----------------------------------------------

 

511DirSyncProDatabaseUpdateLog

 

Publishing to database 'DirSyncPro511' on server 'IIS-DSP\SQLEXPRESS'.

Initializing deployment (Start)

Initializing deployment (Complete)

Analyzing deployment plan (Start)

Analyzing deployment plan (Complete)

Updating database (Start)

Done.

Creating [BTScheduleSqlClassLibrary]...

Creating [dbo].[ADM_Action]...

Creating [dbo].[ADM_ActionCommand]...

Creating [dbo].[ADM_AdminAgentCsv]...

Creating [dbo].[ADM_AdminAgentCsv].[IX_ADM_AdminAgentCsv]...

Creating [dbo].[ADM_AdminAgentCsvData]...

Creating [dbo].[ADM_Batch]...

Creating [dbo].[ADM_Command]...

Creating [dbo].[ADM_Credentials]...

Creating [dbo].[ADM_DeviceJob]...

Creating [dbo].[ADM_DeviceProperty]...

Creating [dbo].[ADM_DeviceReAclProfile]...

Creating [dbo].[ADM_GlobalVariable]...

Creating [dbo].[ADM_LoadTest]...

Creating [dbo].[ADM_MigrationOption]...

Creating [dbo].[ADM_NetworkProfile]...

Creating [dbo].[ADM_OfflineDomainJoin]...

Creating [dbo].[ADM_Report]...

Creating [dbo].[ADM_Setting]...

Creating [dbo].[ADM_Share]...

Creating [dbo].[ADM_ShareReAclProfile]...

Creating [dbo].[ADM_ViewState]...

Creating [dbo].[AspNet_SqlCacheTablesForChangeNotification]...

Creating [dbo].[BT_Applications]...

Creating [dbo].[BT_Config]...

Creating [dbo].[BT_ConnectionPoint]...

Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_ConnectionPointConfig]...

Creating [dbo].[BT_Device]...

Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_Device].[IX_BT_Device_SAMAccountName]...

Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'IX_BT_Device_SAMAccountName' has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_DeviceConfig]...

Creating [dbo].[BT_FieldValues]...

Creating [dbo].[BT_GroupMemberRelations]...

Creating [dbo].[BT_GroupMemberRelations].[IX_BT_GroupMemberRelations_BT_ContainingGroup]...

Creating [dbo].[BT_Groups]...

Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_Groups].[IX_BT_Groups_TruncatedDN]...

Creating [dbo].[BT_Groups].[IX_BT_Groups_ObjectSID]...

Creating [dbo].[BT_Groups].[IX_BT_Groups_SourceDirectoryID]...

Creating [dbo].[BT_Groups].[IX_BT_Groups]...

Creating [dbo].[BT_GroupsConfig]...

Creating [dbo].[BT_NotesDatabases]...

Creating [dbo].[BT_NotesServers]...

Creating [dbo].[BT_Permissions]...

Creating [dbo].[BT_Person]...

Warning: The maximum length of the row exceeds the permissible limit of 8060 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_Person].[_dta_index_BT_Person_InternetAddress]...

Warning! The maximum key length for a nonclustered index is 1700 bytes. The index '_dta_index_BT_Person_InternetAddress' has maximum length of 4000 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[BT_Person].[IX_BT_Person]...

Creating [dbo].[BT_Person].[IX_BT_Person_TruncatedDN]...

Creating [dbo].[BT_Person].[IX_BT_Person_ObjectSID]...

Creating [dbo].[BT_PersonConfig]...

Creating [dbo].[BT_Scripts]...

Creating [dbo].[BT_SystemGroup]...

Creating [dbo].[BT_ViewOverrideDefaults]...

Creating [dbo].[BT_ViewOverrides]...

Creating [dbo].[BT_Workstation]...

Creating [dbo].[DirSync_Attributes]...

Creating [dbo].[DirSync_AutoMapBlacklist]...

Creating [dbo].[DirSync_DefaultMapping]...

Creating [dbo].[DirSync_DomainControllers]...

Creating [dbo].[DirSync_Domains]...

Creating [dbo].[DirSync_GroupsToIgnore]...

Creating [dbo].[DirSync_HostPlatforms]...

Creating [dbo].[DirSync_License]...

Creating [dbo].[DirSync_LicensedObjects]...

Creating [dbo].[DirSync_LicensedObjects].[IX_DirSync_LicensedObjects_Checksum]...

Creating [dbo].[DirSync_MappedValue]...

Creating [dbo].[DirSync_MappedValue].[IX_DirSync_MappedValue]...

Warning! The maximum key length for a nonclustered index is 1700 bytes. The index 'IX_DirSync_MappedValue' has maximum length of 5024 bytes. For some combination of large values, the insert/update operation will fail.

Creating [dbo].[DirSync_Mapping]...

Creating [dbo].[DirSync_Nodes]...

Creating [dbo].[DirSync_Settings]...

Creating [dbo].[DirSync_SyncReport]...

Creating [dbo].[DirSync_SyncReport].[IX_BT_SyncReport]...

Creating [dbo].[DirSync_SyncReportMembership]...

Creating [dbo].[DirSync_SyncReportMembership].[IX_BT_SyncReportMembership]...

Creating [dbo].[DirSync_SyncReportProfile]...

Creating [dbo].[DirSync_Tracking]...

Creating [dbo].[InstalledVersion]...

Creating [dbo].[WSM_Group]...

Creating [dbo].[WSM_Group].[IX_WSM_Group]...

Creating [dbo].[WSM_Members]...

Creating [dbo].[WSM_SyncRequest]...

Creating [dbo].[WSM_SyncRequest].[IX_WSM_Source]...

Creating [dbo].[WSM_SyncRequestArchive]...

Creating [dbo].[WSM_SyncRequestArchive].[IX_WSM_SourceArchive]...

Creating [dbo].[WSM_User]...

Creating [dbo].[WSM_User].[IX_WSM_User]...

Creating unnamed constraint on [dbo].[ADM_Action]...

Creating unnamed constraint on [dbo].[ADM_Action]...

Creating [dbo].[DF_ADM_Action_CreatedTimestamp]...

Creating [dbo].[DF_ADM_ActionCommand_CreatedTimestamp]...

Creating [dbo].[DF_ADM_Batch_CreatedTimestamp]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating [dbo].[DF_ADM_Command_CreatedTimestamp]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Command]...

Creating unnamed constraint on [dbo].[ADM_Credentials]...

Creating unnamed constraint on [dbo].[ADM_Credentials]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceJob]...

Creating unnamed constraint on [dbo].[ADM_DeviceProperty]...

Creating unnamed constraint on [dbo].[ADM_DeviceReAclProfile]...

Creating unnamed constraint on [dbo].[ADM_GlobalVariable]...

Creating unnamed constraint on [dbo].[ADM_GlobalVariable]...

Creating unnamed constraint on [dbo].[ADM_MigrationOption]...

Creating unnamed constraint on [dbo].[ADM_MigrationOption]...

Creating unnamed constraint on [dbo].[ADM_MigrationOption]...

Creating unnamed constraint on [dbo].[ADM_MigrationOption]...

Creating unnamed constraint on [dbo].[ADM_MigrationOption]...

Creating unnamed constraint on [dbo].[ADM_NetworkProfile]...

Creating unnamed constraint on [dbo].[ADM_NetworkProfile]...

Creating unnamed constraint on [dbo].[ADM_NetworkProfile]...

Creating unnamed constraint on [dbo].[ADM_NetworkProfile]...

Creating [dbo].[DF_ADM_NetworkProfile_CreatedTimestamp]...

Creating [dbo].[DF_ADM_Setting_CreatedTimestamp]...

Creating unnamed constraint on [dbo].[ADM_Share]...

Creating [dbo].[DF_ADM_Share_CreatedTimestamp]...

Creating unnamed constraint on [dbo].[ADM_ShareReAclProfile]...

Creating unnamed constraint on [dbo].[AspNet_SqlCacheTablesForChangeNotification]...

Creating unnamed constraint on [dbo].[AspNet_SqlCacheTablesForChangeNotification]...

Creating [dbo].[DF_BT_Config_LastModified]...

Creating unnamed constraint on [dbo].[BT_ConnectionPoint]...

Creating unnamed constraint on [dbo].[BT_ConnectionPoint]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Device]...

Creating unnamed constraint on [dbo].[BT_Groups]...

Creating unnamed constraint on [dbo].[BT_Groups]...

Creating unnamed constraint on [dbo].[BT_Groups]...

Creating unnamed constraint on [dbo].[BT_Groups]...

Creating [dbo].[DF_BT_NotesServers_IsHidden]...

Creating unnamed constraint on [dbo].[BT_Permissions]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating unnamed constraint on [dbo].[BT_Person]...

Creating [dbo].[DF_BT_Workstation_IsOnline]...

Creating unnamed constraint on [dbo].[DirSync_Attributes]...

Creating unnamed constraint on [dbo].[DirSync_Domains]...

Creating unnamed constraint on [dbo].[DirSync_Domains]...

Creating unnamed constraint on [dbo].[DirSync_License]...

Creating unnamed constraint on [dbo].[DirSync_MappedValue]...

Creating unnamed constraint on [dbo].[DirSync_Nodes]...

Creating unnamed constraint on [dbo].[DirSync_Settings]...

Creating unnamed constraint on [dbo].[DirSync_Settings]...

Creating unnamed constraint on [dbo].[DirSync_Settings]...

Creating unnamed constraint on [dbo].[DirSync_Settings]...

Creating unnamed constraint on [dbo].[WSM_SyncRequest]...

Creating unnamed constraint on [dbo].[WSM_SyncRequestArchive]...

Creating [dbo].[FK_ADM_ActionCommand_ADM_Command]...

Creating [dbo].[FK_ADM_ActionCommand_ADM_Action]...

Creating [dbo].[FK_ADM_AdminAgentCsvData_ADM_AdminAgentCsv]...

Creating [dbo].[FK_ADM_DeviceJob_BT_Device_RunOn]...

Creating [dbo].[FK_ADM_DeviceJob_BT_Device]...

Creating [dbo].[FK_ADM_DeviceProperty_BT_Device]...

Creating [dbo].[FK_BT_Config_BT_Applications]...

Creating [dbo].[FK_BT_ConnectionPointConfig_DirSync_Domains]...

Creating [dbo].[FK_BT_ConnectionPointConfig_BT_ConnectionPoint]...

Creating [dbo].[FK_BT_ConnectionPointConfig_BT_Config]...

Creating [dbo].[FK_BT_DeviceConfig_BT_Device]...

Creating [dbo].[FK_BT_DeviceConfig_DirSync_Domains]...

Creating [dbo].[FK_BT_DeviceConfig_BT_Config]...

Creating [dbo].[FK_BT_GroupMemberRelations_BT_Groups1]...

Creating [dbo].[FK_BT_Groups_DirSync_Domains]...

Creating [dbo].[FK_BT_GroupsConfig_BT_Group]...

Creating [dbo].[FK_BT_GroupsConfig_DirSync_Domains]...

Creating [dbo].[FK_BT_GroupsConfig_BT_Config]...

Creating [dbo].[FK_BT_NotesDatabases_BT_NotesServers]...

Creating [dbo].[FK_BT_Permissions_BT_Groups]...

Creating [dbo].[FK_BT_Person_DirSync_Domains]...

Creating [dbo].[FK_BT_PersonConfig_BT_Config]...

Creating [dbo].[FK_BT_PersonConfig_BT_Person]...

Creating [dbo].[FK_BT_PersonConfig_DirSync_Domains]...

Creating [dbo].[FK_BT_Scripts_BT_Config]...

Creating [dbo].[FK_BT_Workstation_BT_Applications]...

Creating [dbo].[FK_DirSync_Attributes_DirSync_Domains]...

Creating [dbo].[FK_DirSync_DomainControllers_BT_Config]...

Creating [dbo].[FK_DirSync_Domains_DirSync_HostPlatforms]...

Creating [dbo].[FK_DirSync_MappedValue_BT_Config]...

Creating [dbo].[FK_DirSync_Mapping_BT_Config]...

Creating [dbo].[FK_DirSync_Tracking_DirSync_Domains]...

Creating [dbo].[FK_DirSync_Tracking_BT_Config]...

Creating [dbo].[FK_WSM_Members_WSM_Group]...

Creating [dbo].[TGR_ADM_Action_Update]...

Creating [dbo].[TGR_ADM_ActionCommand_Update]...

Creating [dbo].[ADM_Action_Delete]...

Creating [dbo].[TGR_ADM_Batch_Update]...

Creating [dbo].[ADM_Command_Delete]...

Creating [dbo].[TGR_ADM_Command_Update]...

Creating [dbo].[TGR_ADM_GlobalVariable_Update]...

Creating [dbo].[TGR_ADM_NetworkProfile_Update]...

Creating [dbo].[TGR_ADM_Setting_Update]...

Creating [dbo].[TGR_ADM_Share_Update]...

Creating [dbo].[BT_Groups_Delete]...

Creating [dbo].[BT_Person_Delete]...

Creating [dbo].[ContactChangeMessages]...

Creating [ContactChangeNotifications]...

Creating [dbo].[EscapeAllADReservedCharacters]...

Creating [dbo].[FDIV]...

Creating [dbo].[FirstNameFirst]...

Creating [dbo].[LastNameFirst]...

Creating [dbo].[LERP]...

Creating [dbo].[ReplaceATWithDot]...

Creating [dbo].[ReplaceDomain]...

Creating [dbo].[ts_unid_str]...

Creating [dbo].[UpdateInternetAddress]...

Creating [dbo].[ParseArray]...

Creating [dbo].[Split]...

Creating [dbo].[BT_DeviceUserProfilesView]...

Creating [dbo].[BT_FinalViewOverrides]...

Creating [dbo].[DirSync_SyncReportMembersView]...

Creating [dbo].[DirSync_SyncReportView]...

Creating [dbo].[GetConnectionPointViewField]...

Creating [dbo].[GetDeviceViewField]...

Creating [dbo].[GetGroupsViewField]...

Creating [dbo].[GetPersonViewField]...

Creating [dbo].[AddDefaultMapping]...

Creating [dbo].[ADM_Report_ContactMigPct]...

Creating [dbo].[ADM_Report_DeviceMigPct]...

Creating [dbo].[ADM_Report_DevicesFailedCutover]...

Creating [dbo].[ADM_Report_GetBatches]...

Creating [dbo].[ADM_Report_GetDeviceDetail]...

Creating [dbo].[ADM_Report_GetDevicesCutover]...

Creating [dbo].[ADM_Report_GetDevicesFailedCutover]...

Creating [dbo].[ADM_Report_GetDevicesPreparedMigration]...

Creating [dbo].[ADM_Report_GetDeviceUserProfiles]...

Creating [dbo].[ADM_Report_GetProfiles]...

Creating [dbo].[ADM_Report_GetUserDetail]...

Creating [dbo].[ADM_Report_GetUsersMigrated]...

Creating [dbo].[ADM_Report_GetUsersPreparedMigration]...

Creating [dbo].[ADM_Report_GroupMigPct]...

Creating [dbo].[ADM_Report_NasMigPct]...

Creating [dbo].[ADM_Report_RoomMigPct]...

Creating [dbo].[ADM_Report_UserMigPct]...

Creating [dbo].[AspNet_SqlCacheUpdateChangeIdStoredProcedure]...

Creating [dbo].[BT_ChangeTracking]...

Creating [dbo].[CheckTimerProcedure]...

Creating [dbo].[CreateDeviceReAclProfileDefault]...

Creating [dbo].[CreateOrUpdateConnectionPointView]...

Creating [dbo].[CreateOrUpdateDeviceView]...

Creating [dbo].[CreateOrUpdateGroupsView]...

Creating [dbo].[CreateOrUpdatePersonView]...

Creating [dbo].[CreateShareReAclProfileDefault]...

Creating [dbo].[NodeRunning]...

Creating [dbo].[NodeShutdown]...

Creating [dbo].[NodeStartup]...

Creating [dbo].[ValidateGroupViewOverride]...

Creating [dbo].[ValidatePersonViewOverride]...

Creating [dbo].[DirSync_Settings].[ClearLogOffset].[MS_Description]...

Creating [dbo].[DirSync_Settings].[ClearLogAuto].[MS_Description]...

Creating [dbo].[DirSync_Settings].[ClearLogType].[MS_Description]...

Checking existing data against newly created constraints

Update complete.

Updating database (Complete)

Successfully published database.

 

511 Dir Sync Pro Log Database Update Log

 

Publishing to database 'DirSyncProLog511' on server 'IIS-DSP\SQLEXPRESS'.

Initializing deployment (Start)

Initializing deployment (Complete)

Analyzing deployment plan (Start)

Analyzing deployment plan (Complete)

Updating database (Start)

Creating [dbo].[BT_Keys]...

Creating [dbo].[BT_Log2]...

Creating [dbo].[DirSync_Audit]...

Creating [dbo].[DirSync_AuditData]...

Creating [dbo].[InstalledVersion]...

Creating [dbo].[Profile_Audit]...

Creating [dbo].[Profile_AuditData]...

Creating unnamed constraint on [dbo].[BT_Keys]...

Creating unnamed constraint on [dbo].[BT_Log2]...

Creating [dbo].[FK_DirSync_AuditData_DirSync_Audit]...

Creating [dbo].[FK_Profile_AuditData_Profile_Audit]...

Creating [dbo].[GetNextKeyValue]...

Checking existing data against newly created constraints

Update complete.

Updating database (Complete)

Successfully published database.

DirSyncProLogDatabaseUpdateLog.txtlicensedetails.txtDirectory Sync Pro 5.1.1 install.docxDirSyncProDatabaseUpdateLog.txtBinaryTree.DirSync.Exchange.exe.ConfigBinaryTree.DirSync.UI.exe.config