-
Notifications
You must be signed in to change notification settings - Fork 443
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unsupported Protocol Error #1251
Comments
@kagedevelopment what version of |
$ npm tedious -v |
I changed the server based on what I saw on Microsofts website and I'm now getting the error failed to login as user 'redacted'
|
Are you able to login using the latest version of tedious? |
I tried the commands npm install tedious@11.0.8 and npm install tedious@latest and neither of them updated the version when i run the command npm tedious -v I still get 6.14.8 |
the latest version is 11.0.7. Try running the commands: |
I am using version 11.0.7 now and I am still seeing the same error. I have verified that TCP/IP is enabled for MSSQLSERVER, SQL Server Browser is running and SQL Server agent is running. I am able to log into SSMS just fine using the credentials I am using in my code. Any idea what the issue is? I have seen people use just localhost or the IP Address for their connection. Why does mine only get to login failed when using localhost.database.windows.net as the server? When I don't use that as the server it throws the original error that I posted. |
What sql server version are you using? |
SQL Server Management Studio 15.0.18206.0 |
I mean what version of the database are you using? You can follow these steps to get the exact version |
12.0.2269.0 |
In regards to your first error and according to Microsoft's docs: Try to install 2014 SP2 and see if that helps. (If you scroll down, they also claimed to have |
I'm not going to be able to dig into this until Monday. I will let you know the results then. Thank you! |
I have a ticket open with Internal IT to update this on our server. I will let you know the results once this is updated. |
They are set to do the update on Wednesday of this coming week. I will test Thursday and follow-up. |
Updating SQL server fixed the issue. Thank you for your assistance! |
Hi, i have a similar problem, i can't connect to my database althrought the protocol TCP/IP is enabled in my computer, also make sure all the sql services are running, i got this error ConnectionError: Failed to connect to localhost:1433 - self signed certificate my code: const config = { const Connection = require('tedious').Connection; const connection = new Connection(config); connection.on('connect', function(err) { im using the version of database 15.0.2000.5 SQL Server Management Studio 15.0.18330.0 |
Try adding this options: options: { } |
@kagedevelopment can you open a new issue for this? (so we can better track it) |
@Estefania-Pichardo-Montes If you are still having this issue, can you please create a separate issue for this? |
Hey, i already resolve the issue, adding the suggested option i get another error but i realize that the error was that i was using the user of windows authentication instead of an sql server user, thank you |
I had the same issue and this solution worked for me. Tks |
Where exactly do I have to add this? |
Hi @kazzi58, this goes in your config object.
You can find more information here: http://tediousjs.github.io/tedious/api-connection.html |
a mi me sale este error: ConnectionError: Failed to connect to localhost:1433 - 12864:error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol:c:\ws\deps\openssl\openssl\ssl\statem\statem_lib.c:1994: |
I am seeing the below error when trying to connect to a local sql server database using tedious. I have tried both using the IP address and localhost and it won't connect. TCP/IP is enabled for MSSQLSERVER in sql server configuration manager. I also verified that sql server browser is also running.
Error:
ConnectionError: Failed to connect to 127.0.0.1:1433 - 22996:error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol:c:\ws\deps\openssl\openssl\ssl\statem\statem_lib.c:1942:
code: 'ESOCKET'
}
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! kagetruckroutingappserver@0.0.0 start:
node ./bin/www
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the kagetruckroutingappserver@0.0.0 start script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! Redacted
Code:
The text was updated successfully, but these errors were encountered: