SQL Server

Posted on

Create Node.js apps using SQL Server on Windows

1 Setup SQL Server
Setup basic installation type, read and Accept the license terms, Select installation location, Install

2 Install Chocolately and Node.js on Windows 10 using command prompt (cmd)

@"%SystemRoot%\System32\WindowsPowerShell\v1.0\powershell.exe" -NoProfile -InputFormat None -ExecutionPolicy Bypass -Command "iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))" && SET "PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin"

3 Install nodejs using command prompt

choco install -y nodejs

4 Install the OBDC Driver Microsoft® ODBC Driver 17 for SQL Server

5 Install sqlcmd Microsoft® Command Line Utilities 14.0 for SQL Server

6 Install SSMS Microsoft® Download SQL Server Management Studio

7 Connect to SQL Server using the command prompt

sqlcmd -S localhost -U sa -P your_password