This object is in archive!
Import External Database (Sql Server)
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.
The same question
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
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
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.
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.
Replies have been locked on this page!