cannot connect to the sql server databse

[kasiasulowska]

Hi!

I really would love to try Azimutt on our huge and complex database (over 1000 tables) but I failed to connect...
Firstly I tried to connect through your website, but I got an error:

    Loaded Server=**.***.**.204:,1433;Database=*;User ID=*;Password=*;TrustServerCertificate=True;Encrypt=False database.
    http://localhost:4177: Failed to fetch
    https://gateway.azimutt.app: Failed to connect to**.***.**.204:,1433 - self signed certificate
    Done! 

Then I tried to connect to my local db through npm but also failed and I'm getting an error:

    sqlserver not recognized from url (got undefined), will try anyway but expect some errors...
    
    Source kind 'sqlserver' is not supported :(
    But you're welcome to send an issue or PR at https://github.com/azimuttapp/azimutt ;)

Any advise how to solve these issues?

BTW I also failed (44323 errors :( ) with importing sql structure and after clicking 'send report' I got a blank website.

I'm using Win 11.

Many thanks for any feedback,
kasia

[loicknuchel]

Hi @kasiasulowska

Thanks for reporting this, let's try to get this working...
First let's try to connect with Azimutt CLI to your local database:

• which version of the CLI are you using? (should be shown just below the Azimutt ascii are when you start, it should be 0.0.27)
• what is your database url format? (replace with fake values but keep the format)

Your error Source kind 'sqlserver' is not supported make me guess you are on a old version.

[kasiasulowska]

Hi @loicknuchel,

It looks like I'm using 0.0.27 version:

And the command I used for connecting to the db:
npx azimutt export sqlserver Server=11.111.11.111,1234;Database=XX_111_XX;User ID=xxx;Password=xxx

[paulinejamin]

Hi @loicknuchel!

I'm facing the same issue. Launched the gateway and trying to connect to my SQL Server database with this connection string:
Server=localhost,1433;Database=*;User Id=*;Password=*;Trusted_Connection=True;TrustServerCertificate=True

And go this error:

Loaded Server=localhost,1433;Database=*;User Id=*;Password=*;Trusted_Connection=True;TrustServerCertificate=True database.
http://localhost:4177: Failed to connect to localhost:1433 - self-signed certificate
https://gateway.azimutt.app: Failed to connect to localhost:1433 - Could not connect (sequence)
Done!

NB: CLI version is 0.0.27

[loicknuchel]

Hi!
I just updated the CLI to version 0.0.28 and I hope it will work 🤞
Tell me how it goes.
Cheers!

[kasiasulowska]

Hi!
I just updated the CLI to version 0.0.32 but I'm still encountering the problem:

The string which I used for the connection:
npx azimutt export Server=localhost,1433;Database=*;UserID=*;Password=*;Trusted_Connection=True;TrustServerCertificate=True