Start-SqlMigration Bug

**********************
Windows PowerShell transcript start
Start time: 20160915221915
Username: MANATARMS\wshaw
RunAs User: MANATARMS\wshaw
Machine: MANATARMS (Microsoft Windows NT 10.0.14393.0)
Host Application: C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
Process ID: 11940
PSVersion: 5.1.14393.187
PSEdition: Desktop
PSCompatibleVersions: 1.0, 2.0, 3.0, 4.0, 5.0, 5.1.14393.187
BuildVersion: 10.0.14393.187
CLRVersion: 4.0.30319.42000
WSManStackVersion: 3.0
PSRemotingProtocolVersion: 2.3
SerializationVersion: 1.1.0.1
**********************
Transcript started, output file is C:\Users\wshaw\Documents\dbatools-startmigration-transcript.txt


Migrating SQL Server Configuration
Updated recovery interval (min) from 0 to 0
Updated allow updates from 0 to 0
Updated user connections from 0 to 0
Updated locks from 0 to 0
Updated open objects from 0 to 0
Updated fill factor (%) from 0 to 0
Updated disallow results from triggers from 0 to 0
Updated nested triggers from 1 to 1
Updated server trigger recursion from 1 to 1
Updated remote access from 1 to 1
Updated default language from 0 to 0
Updated cross db ownership chaining from 0 to 0
Updated max worker threads from 0 to 0
Updated network packet size (B) from 4096 to 4096
Updated show advanced options from 1 to 1
Updated remote proc trans from 0 to 0
Updated c2 audit mode from 0 to 0
Updated default full-text language from 1033 to 1033
Updated two digit year cutoff from 2049 to 2049
Updated index create memory (KB) from 0 to 0
Updated priority boost from 0 to 0
Updated remote login timeout (s) from 10 to 10
Updated remote query timeout (s) from 600 to 600
Updated cursor threshold from -1 to -1
Updated set working set size from 0 to 0
Updated user options from 0 to 0
Updated affinity mask from 0 to 0
Updated max text repl size (B) from 65536 to 65536
Updated media retention from 0 to 0
Updated cost threshold for parallelism from 40 to 5
Updated max degree of parallelism from 0 to 0
Updated min memory per query (KB) from 1024 to 1024
Updated query wait (s) from -1 to -1
Updated min server memory (MB) from 0 to 0
Updated max server memory (MB) from 2048 to 1024
Updated query governor cost limit from 0 to 0
Updated lightweight pooling from 0 to 0
Updated scan for startup procs from 0 to 1
Updated affinity64 mask from 0 to 0
Updated affinity I/O mask from 0 to 0
Updated affinity64 I/O mask from 0 to 0
Updated transform noise words from 0 to 0
Updated precompute rank from 0 to 0
Updated PH timeout (s) from 60 to 60
Updated clr enabled from 0 to 1
Updated max full-text crawl range from 4 to 4
Updated ft notify bandwidth (min) from 0 to 0
Updated ft notify bandwidth (max) from 100 to 100
Updated ft crawl bandwidth (min) from 0 to 0
Updated ft crawl bandwidth (max) from 100 to 100
Updated default trace enabled from 1 to 1
Updated blocked process threshold (s) from 0 to 0
Updated in-doubt xact resolution from 0 to 0
Updated remote admin connections from 0 to 0
Updated common criteria compliance enabled from 0 to 0
Updated EKM provider enabled from 0 to 0
Updated backup compression default from 1 to 0
Updated filestream access level from 0 to 2
Updated optimize for ad hoc workloads from 0 to 0
Updated access check cache bucket count from 0 to 0
Updated access check cache quota from 0 to 0
Updated backup checksum default from 0 to 0
Updated Agent XPs from 1 to 1
Updated Database Mail XPs from 0 to 0
Updated SMO and DMO XPs from 1 to 1
Updated Ole Automation Procedures from 0 to 0
Updated xp_cmdshell from 0 to 1
Updated Ad Hoc Distributed Queries from 0 to 0
Updated Replication XPs from 0 to 0
Updated contained database authentication from 0 to 0
Server configuration update finished


Migrating custom errors (user defined messages)
Custom error migration finished


Migrating SQL credentials
Getting NetBios name
Checking if remote access is enabled
Checking if Remote Registry is enabled
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
Collecting Credential logins and passwords on manatarms\number14
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
PS>TerminatingError(): "Unknown key size. Cannot continue. Quitting."
>> TerminatingError(): "Unknown key size. Cannot continue. Quitting."
>> TerminatingError(): "Unknown key size. Cannot continue. Quitting."
Start-SqlMigration : Credential migration reported the following error Unknown key size. Cannot continue. Quitting.
At line:1 char:1
+ Start-SqlMigration -Source manatarms\number14 -Destination manatarms\ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Start-SqlMigration
Start-SqlMigration : Credential migration reported the following error Unknown key size. Cannot continue. Quitting.
At line:1 char:1
+ Start-SqlMigration -Source manatarms\number14 -Destination manatarms\ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Start-SqlMigration



Migrating database mail
Migrating mail server configuration values
Migrating accounts
Migrating mail profiles
Migrating mail servers
Mail migration finished


Migrating user objects in system databases (this can take a second)
Copying from master
Copying from model
Copying from msdb
Migrating user objects in system databases finished


Migrating Central Management Server
Connecting to Central Management Servers
Central Management Server migration finished


Migrating Backup Devices
Resolving NetBios name
backup device migration finished


Migrating linked servers
Getting NetBios name
Checking if remote access is enabled
Checking if Remote Registry is enabled
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
Collecting Linked Server logins and passwords on manatarms\number14
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or
use HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information,
see the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
[manatarms] Connecting to remote server manatarms failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x8009030e occurred while using Negotiate authentication: A specified logon
session does not exist. It may already have been terminated.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the two domains.
 After checking for the above issues, try the following:
  -Check the Event Viewer for events related to authentication.
  -Change the authentication method; add the destination computer to the WinRM TrustedHosts configuration setting or use
HTTPS transport.
 Note that computers in the TrustedHosts list might not be authenticated.
   -For more information about WinRM configuration, run the following command: winrm help config. For more information, see
the about_Remote_Troubleshooting Help topic.
    + CategoryInfo          : OpenError: (manatarms:String) [], PSRemotingTransportException
    + FullyQualifiedErrorId : 1312,PSSessionStateBroken
PS>TerminatingError(): "Unknown key size. Cannot continue. Quitting."
>> TerminatingError(): "Unknown key size. Cannot continue. Quitting."
>> TerminatingError(): "Unknown key size. Cannot continue. Quitting."
Start-SqlMigration : Linked server migration reported the following error Unknown key size. Cannot continue. Quitting.
At line:1 char:1
+ Start-SqlMigration -Source manatarms\number14 -Destination manatarms\ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Start-SqlMigration
Start-SqlMigration : Linked server migration reported the following error Unknown key size. Cannot continue. Quitting.
At line:1 char:1
+ Start-SqlMigration -Source manatarms\number14 -Destination manatarms\ ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Start-SqlMigration



Migrating System Triggers
Server trigger migration finished

Migrating databases
Attempting to connect to Sql Servers..
Resolving NetBIOS names
Performing SMO version check
Checking to ensure the source isn't the same as the destination
Checking to ensure network path is valid
Checking to ensure server is not SQL Server 7 or below
Checking to ensure detach/attach is not attempted on SQL Server 2000
Checking to ensure SQL Server 2000 migration isn't directly attempted to SQL Server 2012
Ensuring user databases exist (counting databases)
Ensuring destination server version is equal to or greater than source
Writing warning about filestream being enabled
Building database list
Building file structure inventory for 11 databases

######### Database: AdventureWorks2014 #########
Started: 09/15/2016 22:19:49
Successfully restored AdventureWorks2014 to MANATARMS\NUMBER16
Finished: 09/15/2016 22:19:58
Elapsed time: 00:00:09

######### Database: AdventureWorksDW2014 #########
Started: 09/15/2016 22:19:58
Successfully restored AdventureWorksDW2014 to MANATARMS\NUMBER16
Finished: 09/15/2016 22:20:04
Elapsed time: 00:00:05

######### Database: avail #########
Started: 09/15/2016 22:20:04
Successfully restored avail to MANATARMS\NUMBER16
Finished: 09/15/2016 22:20:05
Elapsed time: 00:00:00

######### Database: AzureStorageEmulatorDb44 #########
Started: 09/15/2016 22:20:05
Successfully restored AzureStorageEmulatorDb44 to MANATARMS\NUMBER16
Finished: 09/15/2016 22:20:06
Elapsed time: 00:00:00

######### Database: CollegeScorecardData #########
Started: 09/15/2016 22:20:06
Successfully restored CollegeScorecardData to MANATARMS\NUMBER16
Finished: 09/15/2016 22:20:06
Elapsed time: 00:00:00

######### Database: Database With Space #########
Started: 09/15/2016 22:20:06
Successfully restored Database With Space to MANATARMS\NUMBER16
Finished: 09/15/2016 22:20:31
Elapsed time: 00:00:24

######### Database: DatabaseFS #########
WARNING: Skipping DatabaseFS (contains FILESTREAM)

######### Database: Northwind #########
Started: 09/15/2016 22:20:31
Successfully restored Northwind to MANATARMS\NUMBER16
Finished: 09/15/2016 22:21:25
Elapsed time: 00:00:53

######### Database: PerfDataCollection #########
Started: 09/15/2016 22:21:25
Successfully restored PerfDataCollection to MANATARMS\NUMBER16
Finished: 09/15/2016 22:24:26
Elapsed time: 00:03:01

######### Database: PSGallery #########
Started: 09/15/2016 22:24:26
Successfully restored PSGallery to MANATARMS\NUMBER16
Finished: 09/15/2016 22:24:28
Elapsed time: 00:00:02

######### Database: SSISDB #########
Started: 09/15/2016 22:24:28
Successfully restored SSISDB to MANATARMS\NUMBER16
Finished: 09/15/2016 22:24:33
Elapsed time: 00:00:04

Database migration finished
Migration started: 09/15/2016 22:19:49
Migration completed: 09/15/2016 22:24:33
Total Elapsed time: 00:04:43


Migrating logins
Attempting to connect to SQL Servers..
Migration started: 09/15/2016 22:24:33
Attempting Login Migration
Skipping ##MS_PolicyEventProcessingLogin##
Skipping ##MS_PolicyTsqlExecutionLogin##
Skipping ##MS_SQLEnableSystemAssemblyLoadingUser##
Skipping ##MS_SSISServerCleanupJobLogin##
MANATARMS\wshaw is skipped because it is a local machine name.
NT AUTHORITY\SYSTEM is skipped because it is a local machine name.
NT Service\MSSQL$NUMBER14 is skipped because it is a local machine name.
NT SERVICE\SQLAgent$NUMBER14 is skipped because it is a local machine name.
NT SERVICE\SQLAgent$NUMBER14B is skipped because it is a local machine name.
NT SERVICE\SQLWriter is skipped because it is a local machine name.
NT SERVICE\Winmgmt is skipped because it is a local machine name.
Attempting to add Test_App_1 to MANATARMS\NUMBER16
Setting Test_App_1 SID to source username SID
Setting login language to us_english
Set Test_App_1 defaultdb to master
Successfully added Test_App_1 to MANATARMS\NUMBER16
Successfully performed Grant CONNECT SQL to Test_App_1
WARNING: Failed to add Test_App_1 (Test_App_1) to avail on MANATARMS\NUMBER16.
WARNING: See error log C:\Users\wshaw\Documents\dbatools-exceptions.txt for more details.
WARNING: Failed to perform Grant on CONNECT for Test_App_1 on avail.
WARNING: See error log C:\Users\wshaw\Documents\dbatools-exceptions.txt for more details.
Attempting to add Test_App_2 to MANATARMS\NUMBER16
Setting Test_App_2 SID to source username SID
Setting login language to us_english
Set Test_App_2 defaultdb to master
Successfully added Test_App_2 to MANATARMS\NUMBER16
Successfully performed Grant CONNECT SQL to Test_App_2
WARNING: Failed to add Test_App_2 (Test_App_2) to AdventureWorks2014 on MANATARMS\NUMBER16.
WARNING: See error log C:\Users\wshaw\Documents\dbatools-exceptions.txt for more details.
WARNING: Failed to perform Grant on CONNECT for Test_App_2 on AdventureWorks2014.
WARNING: See error log C:\Users\wshaw\Documents\dbatools-exceptions.txt for more details.
Login migration completed: 09/15/2016 22:24:35
Total elapsed time: 00:00:02


Migrating Audits
Server audit migration finished


Migrating Server Audit Specifications
Server audit migration finished


Migrating Endpoints
Server endpoint migration finished


Migrating Policy Management
Migrating conditions
Migrating policies
Policy Management migration finished


Migrating Resource Governor
Updating Resource Governor settings
Migrating pools
Reconfiguring Resource Governor
Resource Governor migration finished


Migrating Extended Events
Migrating sessions
Migrating session Avail_Trace_Statements
Migrating session Watch_Login
Extended Event migration finished


Migrating job server
Operator category migration finished
Alert category migration finished
Job category migration finished
Agent category migration finished
Copying Operator Shawn Melton
Operator migration finished
Copying Alert Defaults
Alert migration finished
Server proxy account migration finished
WARNING: Shared job schedule CollectorSchedule_Every_10min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_15min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_30min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_5min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_60min exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule CollectorSchedule_Every_6h exists at destination. Use -Force to drop and migrate.
Copying schedule DBA - SQL ErrorLog Rollover
WARNING: Shared job schedule Every5Minute exists at destination. Use -Force to drop and migrate.
WARNING: Shared job schedule FTC_Populate exists at destination. Use -Force to drop and migrate.
Copying schedule IAmATSQLTask.IHaveFunnyCharacter!InMyName
Copying schedule mdw_purge_data_schedule
Copying schedule OccursEvery15Minutes
Copying schedule OccursEveryOneHour
Copying schedule OccursOnceADayAt12:01AM
WARNING: Shared job schedule RunAsSQLAgentServiceStartSchedule exists at destination. Use -Force to drop and migrate.
Copying schedule SSISDB Scheduler
WARNING: Shared job schedule syspolicy_purge_history_schedule exists at destination. Use -Force to drop and migrate.
Job schedule migration finished
WARNING: [Job: collection_set_1_noncached_collect_and_upload] Job collection_set_1_noncached_collect_and_upload exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_2_collection] Job collection_set_2_collection exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_2_upload] Job collection_set_2_upload exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_3_collection] Job collection_set_3_collection exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_3_upload] Job collection_set_3_upload exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_8_collection] Job collection_set_8_collection exists at destination. Use -Force to drop and migrate.
WARNING: [Job: collection_set_8_upload] Job collection_set_8_upload exists at destination. Use -Force to drop and migrate.
Copying Job DBA - SQL ErrorLog Rollover
WARNING: [Job: Every5Minute] Job Every5Minute exists at destination. Use -Force to drop and migrate.
Copying Job IAmATSQLTask.IHaveFunnyCharacter!InMyName
Copying Job IAmATSQLTask.IHaveSecondSubPlan
Copying Job MaintenancePlan.Subplan_1
Copying Job mdw_purge_data_[PerfDataCollection]
WARNING: [Job: SSIS Server Maintenance Job] Login(s) ##MS_SSISServerCleanupJobLogin## doesn't exist on destination. Skipping.
WARNING: [Job: Start Optimize Catalog Population on DatabaseFS.DatabaseFTS] Job Start Optimize Catalog Population on DatabaseFS.DatabaseFTS exists at destination. Use -Force to drop and migrate.
WARNING: [Job: syspolicy_purge_history] Job syspolicy_purge_history exists at destination. Use -Force to drop and migrate.
Copying Job sysutility_get_cache_tables_data_into_aggregate_tables_daily
Copying Job sysutility_get_cache_tables_data_into_aggregate_tables_hourly
Copying Job sysutility_get_views_data_into_cache_tables
Copying Job Test-DropWhileRunning
Job migration finished
Copying SQL Agent Properties
WARNING: See error log C:\Users\wshaw\Documents\dbatools-exceptions.txt for more details.
Job server migration finished


SQL Server migration complete
Migration started: 09/15/2016 22:19:15
Migration completed: 09/15/2016 22:24:40
Total Elapsed time: 00:05:24
**********************
Windows PowerShell transcript end
End time: 20160915222440
**********************