- The article titled "My team had an issue today when importing the bacpac in their devVM" discusses a problem encountered during the import of a bacpac file in a devVM.
- The first issue was resolved with a fix, but the import process encountered another error.
- The error message displayed was "Unable to connect to target server 'localhost'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server."
- Additionally, there was an error during the login process with the message "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0
- The target principal name is incorrect.)"
- The article provides a solution to the problem by suggesting the addition of the "TargetTrustServerCertificate" parameter in the command and setting it to "Yes".
- The recommended command for resolving the issue is: "SqlPackage.exe /a:import /sf:C:\Users\Admin1234\Downloads\UATbackup.bacpac /tsn:localhost /tdn:AxDBUAT /p:CommandTimeout=6000 /TargetTrustServerCertificate:True" or "/ttsc:True".
- By adding this parameter, the import process was successful without any errors.
- The article highlights the importance of using the correct command and parameter to ensure a smooth import process without encountering any issues.
Registered users can view the full text for FREE!
Sign In Now!