This object is in archive! 

Import External Database (Sql Server)

Ernesto Godoy shared this question 2 months ago
Answered

We are testing this product before purchase and having difficulties with importing from SQL Server.

In "Import External Database" I have two questions;

1. Is it entrypt or encrypt for connection URI?

2. Can someone please supply a sample URI because when I fill it with our DB info, the connect button just does not respond. Only when I revert the password to the word 'password' will try to connect. But obviously this will not work.

Thanks in advance,

Ernesto.

Comments (2)

photo
1

NoSQLBooster uses nodejs-mssql module to connect to MSSQL, for details on nodejs-mssql, please refer to:

https://github.com/tediousjs/node-mssql#formats


options.encrypt - A boolean determining whether or not the connection will be encrypted (default: true).

Formats

In addition to configuration object there is an option to pass config as a connection string. Two formats of connection string are supported.

Classic Connection String

Server=localhost,1433;Database=database;User Id=username;Password=password;Encrypt=true

Driver=msnodesqlv8;Server=(local)\INSTANCE;Database=database;UID=DOMAIN\username;PWD=password;Encrypt=true


Connection String URI

mssql://username:password@localhost:1433/database?encrypt=true

mssql://username:password@localhost/INSTANCE/database?encrypt=true&domain=DOMAIN&driver=msnodesqlv8

photo
1

Its not working I tried all the way above mention connection string. Even though my NoSqlBooster is Licensed.

photo
1

Can you tell me the JDBC connection link or .net connect string you used?

The connectivity problem is difficult to solve because I can't reproduce it locally.

And, thanks for opening your first issue here! If you're reporting a 🐞 bug, please make sure you include steps to reproduce it.

  1. NoSQLBooster Version
  2. Operating System (Windows/Mac/Ubuntu):
  3. Your MSSQL version and server configuration
  4. Expected Behavior
  5. Actual Behavior
  6. How to Reproduce
  7. Screenshots

photo
photo
1

1. mssql://dbuser:Test@125@11.202.1.97:1433/somedb?encrypt=true ---> Connect button does not respond

2. mssql://dbuser@11.202.1.97:1433/somedb?encrypt=true ---> Without password Connect button responds tries to connect but obviously returns an error.


In any case will ask for a refund.

photo
1

One of the things I noticed, and this might be the problem... We generate our password very strong as per our policies. The current password contains the % character. And soon as I remove this character, then tries to connect. But the result is obvious... But never mind... NoSQL manager makes it easirer to provide credentials and works great.

photo
1

Thank you for your feedback. There is a bug, we should call "encodeURI" the connection URI to escape % character.

We have worked out a new build to resolve the issue, please download and give it a try.

Windows: https://nosqlbooster.com/s3/download/releasesv5/nosqlbooster4mongo-5.2.4-beta.1.exe

photo