i have the problem
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : TCP Provider: Error code 0x2726.
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..
I have written a code in node.js code that is connected to MS-SQL server. It's working perfectly fine. Now i want to deploy it on my LIVE IIS server .
Need a guidance in this regard
I have "https://github.com/tjanczuk/iisnode" but its not working and i am not in intention to do any more experiments on live server.
Anybody plesae help me. i am bady stuck ...
need help ---> muhammadikhan@live.com
@David-Engel thanks for your help and response. No doubt this is a unique task and i have leant a new thing which is not common.
I did my task from the help of below-mentioned link.
https://dev.to/massivebrains/deploying-node-express-app-on-a-windows-server-2l5c
If anyone need help regarding IIS or any .net framework, node.js integration with .net. please do me a query.
many thanks
have peace and stay blessed.
:smiley:
Hello! I need some help, first time with docker and I made a little console program with docker for MAC. And everything is working on my Mac, but when I try to open my program on another Mac I get error A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 35 - An internal exception was caught).
What have I missed or what do I Need to do?
@naughtong The ODBC standard has been around for a long time and is likely the most popular for C++ apps. I'm not familiar with sqlapi.
@gittewebmus_twitter You get those values from the database you configured for use with your application.
@isabelpebaque That depends on where your program is trying to connect to the database. Both Macs will need a database installed if you have specified "localhost" for your server. If you have a separate database server, you can point your program to that specific server name and the program can work from either machine (assuming they have appropriate network access to each other).
@intclassproject Ensure SQL Server is installed and configured correctly for network access. If you are running SQL Server in a docker image on Windows, either the docker image is not running, or you did not map the network port Windows to the docker image. Here's a reference doc for a Linux docker container:
https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&preserve-view=true&pivots=cs1-powershell
I recommend these forums over this one for quicker community responses:
SQL Server on Microsoft Q&A
DBA Stack Exchange
@Mixage51 It sounds like your PHP configuration is incorrect. Assuming you have followed the instructions on the docs site, the test script at the end (https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15#testing-your-installation) should help identify problems. If you can't figure it out, try PHP-specific forums (https://www.php-forum.com/phpforum/, https://forums.phpfreaks.com/), or, if you can't get help there, file an issue in the PHP drivers for SQL Server repo: https://github.com/microsoft/msphpsql/issues.