M
M
Magnus Keef2018-12-07 16:50:56
Node.js
Magnus Keef, 2018-12-07 16:50:56

How to spell the server name correctly?

Hello!
There is a virtualka with windows xp, on it the SQL server 2008 DBMS is installed
There the DB is already created.
I want to connect to this database in a node js project.
I found a manual here
. And the problem is that I don’t know how to write the server address correctly.
5c0a7914a5754927593607.png
If the project and the DBMS were on the same machine, then the server would be "localhost"

var config = {
    database: "TestDb",
    server: "localhost",
    userName: 'TestUser',
    password: '12345678aA',
    //driver: "msnodesqlv14",
    options: {
        encrypt: false
    }
};

And how in my case it is necessary to write the address??
Here I found almost the entire connection procedure, but here Oracle is used as a VM, and I use VMware and I don’t know how to complete the last point
5c0a7a50acbb3644518466.png
, and how the address was written here is also not clear
"jdbc: sqlserver://127.0.0.1;databaseName=testdatabase"
jdbc - What is it?
sqlserver - server name?
127.0.0.1 - server address
and database name at the end

Answer the question

In order to leave comments, you need to log in

2 answer(s)
K
Konstantin Tsvetkov, 2018-12-07
@tsklab

Name of a computer on the network or its IP.
To configure the connection, create an empty file test.udland click on it with the mouse.

Setting
5c0a7d1c4d1fb238837747.png

M
Magnus Keef, 2018-12-15
@SecurityYourFingers

As a result, it is still unknown to mankind how to connect to the database on the VM .... spat and installed the DBMS locally

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question