Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem connecting to named instance SQL Server #300

Closed
cody-scott opened this issue May 22, 2024 · 1 comment
Closed

Problem connecting to named instance SQL Server #300

cody-scott opened this issue May 22, 2024 · 1 comment

Comments

@cody-scott
Copy link

Issue Description

  • Description of the issue:
    Problem connecting to a named instance in dagster + sling

  • Sling version (sling --version):
    Version: 1.2.10

  • Operating System (linux, mac, windows):
    linux

  • Replication Configuration:

source: DataDB
target: DWH_Source

defaults:
  mode: full-refresh
  object: "{stream_schema}.{stream_table}"

streams:
  mao.tbl_to_replicate:
  • Log Output (please run command with -d):
    NA since running from dagster
Exception: �[90m7:21PM�[0m �[32mINF�[0m Sling Replication [1 streams] | DataDB -> DWH_Source

�[90m7:21PM�[0m �[32mINF�[0m [1 / 1] running stream mao.tbl_to_replicate
�[90m7:21PM�[0m �[32mINF�[0m �[31mexecution failed�[0m
�[90m7:21PM�[0m �[32mINF�[0m �[31m~ could not parse URL
parse "sqlserver://UserAccount:UserPassword@0.0.0.21\\DEFL:1433/DEFL?&database=DataDB": invalid character "\\" in host name�[0m

�[90m7:21PM�[0m �[32mINF�[0m Sling Replication Completed in 0s | DataDB -> DWH_Source | �[32m0 Successes�[0m | �[31m1 Failures�[0m

�[31mfatal:
~ failure running replication (see docs @ https://docs.slingdata.io/sling-cli)
--------------------------- amo.tblAssetRegistryMain ---------------------------
~ could not parse URL
parse "sqlserver://UserAccount:UserPassword@0.0.0.21\\DEFL:1433/DEFL?&database=DataDB": invalid character "\\" in host name�[0m
Sling command failed:

This seems to stem from something related to named instances on SQL Server and connecting with either a connection string, or parameters.

@flarco
Copy link
Collaborator

flarco commented May 22, 2024

Hi, does this work with the CLI (running sling conns test and sling run -r path/to/replication.yaml)?

@flarco flarco closed this as completed Jun 2, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants