Skip to content

Conversation

@savme
Copy link
Contributor

@savme savme commented Jul 15, 2024

Summary

Implements MSSQL connection test.

> cloudquery test-connection mssql.yaml
Loading spec(s) mssql.yaml
Test Connection Results
destination  mssql (grpc@localhost:7777)  Success

> cloudquery test-connection mssql.yaml
Loading spec(s) from mssql.yaml
Test Connection Results
destination  mssql (grpc@localhost:7777)  Failure: UNAUTHORIZED 	 mssql: login error: Login failed for user 'sa'.
Error: at least one test connection failed

@savme savme marked this pull request as ready for review July 15, 2024 09:27
@savme savme requested review from a team and blesniewski and removed request for a team July 15, 2024 09:27
@blesniewski
Copy link
Contributor

Can you also test out the 'unreachable' scenario? It's probably enough to try running the test connection with mssql container stopped

@savme
Copy link
Contributor Author

savme commented Jul 15, 2024

Can you also test out the 'unreachable' scenario? It's probably enough to try running the test connection with mssql container stopped

I tested all the error states but didn't include the output in the PR description to keep it short. Here's what it looks like if you're curious:

> cloudquery test-connection mssql.yaml
Loading spec(s) from mssql.yaml
Test Connection Results
destination  mssql (grpc@localhost:7777)  Failure: UNREACHABLE 	 unable to open tcp connection with host 'localhost:1433': dial tcp [::1]:1433: connect: connection refused
Error: at least one test connection failed

@savme savme added the automerge Automatically merge once required checks pass label Jul 15, 2024
@kodiakhq kodiakhq bot merged commit 2aa965f into main Jul 15, 2024
@kodiakhq kodiakhq bot deleted the feat/2022-mssql-connection-test branch July 15, 2024 10:14
kodiakhq bot pushed a commit that referenced this pull request Jul 16, 2024
🤖 I have created a release *beep* *boop*
---


## [4.7.0](plugins-destination-mssql-v4.6.8...plugins-destination-mssql-v4.7.0) (2024-07-16)


### Features

* Add MSSQL connection test ([#18568](#18568)) ([2aa965f](2aa965f))


### Bug Fixes

* **deps:** Update module github.com/cloudquery/plugin-sdk/v4 to v4.49.3 ([#18513](#18513)) ([d12da90](d12da90))
* Fix user id format in example configuration comment ([#18561](#18561)) ([71eb413](71eb413))

---
This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

area/plugin/destination/mssql automerge Automatically merge once required checks pass

Projects

None yet

Development

Successfully merging this pull request may close these issues.

4 participants