A
A
antihrust2020-05-19 02:35:00
SQL Server
antihrust, 2020-05-19 02:35:00

Did an error occur while logging in user "sa"?

spoiler
Debugger listening on ws://127.0.0.1:5858/44a2fa50-f4d4-4fdd-818e-2b14946f5103
For help, see: https://nodejs.org/en/docs/inspector
Debugger attached.
ASOM API running
Database connection failed! Bad congig:  ConnectionError: При входе в систему пользователя "sa" произошла ошибка.
    at Connection.<anonymous> (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\lib\tedious\connection-pool.js:68:17)
    at Object.onceWrapper (events.js:300:26)
    at Connection.emit (events.js:210:5)
    at Connection.message (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\connection.js:2148:18)
    at Connection.dispatchEvent (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\connection.js:1279:15)
    at MessageIO.<anonymous> (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\connection.js:1139:14)
    at MessageIO.emit (events.js:210:5)
    at Message.<anonymous> (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\message-io.js:46:14)
    at Message.emit (events.js:215:7)
    at endReadableNT (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\readable-stream\lib\_stream_readable.js:1094:12) {
  code: 'ELOGIN',
  originalError: ConnectionError: При входе в систему пользователя "sa" произошла ошибка.
      at ConnectionError (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\errors.js:13:12)
      at Parser.<anonymous> (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\connection.js:850:51)
      at Parser.emit (events.js:210:5)
      at Parser.<anonymous> (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\token\token-stream-parser.js:37:14)
      at Parser.emit (events.js:210:5)
      at addChunk (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\readable-stream\lib\_stream_readable.js:298:12)
      at readableAddChunk (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\readable-stream\lib\_stream_readable.js:280:11)
      at Parser.Readable.push (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\readable-stream\lib\_stream_readable.js:241:10)
      at Parser.Transform.push (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\readable-stream\lib\_stream_transform.js:139:32)
      at doneParsing (C:\Users\pavlo\source\repos\ASOMMSSQLAPI\ASOMMSSQLAPI\node_modules\mssql\node_modules\tedious\lib\token\stream-parser.js:122:14) {
    message: 'При входе в систему пользователя "sa" произошла ошибка.',
    code: 'ELOGIN'
  },
  name: 'ConnectionError'
}


I can't figure out why it doesn't work. TCP is enabled.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
K
Konstantin Tsvetkov, 2020-05-19
@tsklab

MS SQL has port 1433 by default.

TCP enabled
So it's set up like this?
5ec3736ac0ac5643810250.png
And security is it?
5ec3751ddadd9616627717.png

D
d-stream, 2020-05-19
@d-stream

SSMS from the same computer is connected? If yes - then pick the library, if not - then SQL

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question