CODEWITHSUNDEEP
node.jssql-serverdesktop-applicationtedious
MrB
MrB

Reputation: 5

MSSQL connection from other device in nodejs

I'm new in nodejs and microsoft sql. I've created a simple project which uses mssql in my localhost. And I connected it in my app.js with 'tedious', and everything works perfect.

var Connection = require('tedious').Connection;
  var Request = require('tedious').Request;
 
   var config = {
     server: 'localhost',
     authentication: {
       type: 'default',
       options: {
         userName: 'sa',
         password: '123456789',
       },
     },
     options: {
       encrypt: false,
       database: 'mydb',
     },
   };
 
   const connection = new Connection(config);

However, I want to make this ViualStudio project to be deployed and make desktop application and can be used by another computer, but mssql connection should not be lochost anymore right ? What can I do, in terms of mssql connection ?
What things should I change ?

Thank you.

I haven't changed anything so far in my sql server management bcs im not sure.

Upvotes: 0

Views: 22

Answers (0)

Related Questions