Skip to content

Commit cd989dd

Browse files
committed
adding connection section
1 parent 62da20a commit cd989dd

1 file changed

Lines changed: 15 additions & 0 deletions

File tree

docs/tools/sqlpackage/troubleshooting-issues-and-performance-with-sqlpackage.md

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -75,6 +75,21 @@ sqlpackage.exe /at:$AccessToken
7575
sqlpackage.exe /at:$($AccessToken_Object.Token)
7676
```
7777

78+
### Connection
79+
80+
If SqlPackage is failing to connect, the server may not have encryption enabled or the configured certificate may not be issued from a trusted certificate authority (such as a self-signed certificate). You can change the SqlPackage command to either connect without encryption or to trust the server certificate. The [best practice](../../relational-databases/security/securing-sql-server.md) is to ensure that a trusted encrypted connection to the server can be established.
81+
- Connect without encryption: /SourceEncryptConnection=False or /TargetEncryptConnection=False
82+
- Trust server certificate: /SourceTrustServerCertificate=True or /TargetTrustServerCertificate=True
83+
84+
You may see any of the following warning messages when connecting to a SQL instance, indicating that command line parameters may require changes to connect to the server:
85+
86+
```bash
87+
The settings for connection encryption or server certificate trust may lead to connection failure if the server is not properly configured.
88+
The connection string provided contains encryption settings which may lead to connection failure if the server is not properly configured.
89+
```
90+
91+
More information about the connection security changes in SqlPackage is available in this [blog post](https://aka.ms/dacfx-connection).
92+
7893
## Diagnostics
7994
Logs are essential to troubleshooting. Capture the diagnostic logs to a file with the `/DiagnosticsFile:<filename>` parameter.
8095

0 commit comments

Comments
 (0)