"ConnectionError" when trying to run a SELECT statement…
0 reactions
"ConnectionError" when trying to run a SELECT statement from an Express typescript app using mssql package
The error is: "ConnectionError: Failed to connect to localhost\\SQLEXPRESS01 in 30000ms at connectListener (C:\\...\\mssql\\lib\\tedious\\connection-pool.js86:17)"
I made sure that the SQL Server instance is set to allow both Windows auth and SQL Server auth. I also configured SQL Server to listen on a specific IP address and port 1433, which I added into my config options in my Express app
#technology #dev #programming
source
The error is: "ConnectionError: Failed to connect to localhost\\SQLEXPRESS01 in 30000ms at connectListener (C:\\...\\mssql\\lib\\tedious\\connection-pool.js86:17)"
I made sure that the SQL Server instance is set to allow both Windows auth and SQL Server auth. I also configured SQL Server to listen on a specific IP address and port 1433, which I added into my config options in my Express app
#technology #dev #programming
source
| 2,000 mlx | |
| 2 | |
| 0 |