Unable to connect to SQL Server database using mssql and expressjs

Question

I am trying to connect to a SQL Server database from expressjs using mssql, but I keep getting this:

I am following the example from https://www.npmjs.com/package/mssql#connections-1

The code in my app.js is as follows

const config = {
    //user: '',
    //password: '',
    server: 'LAPTOP-A7INMDKJ',
    database: 'dbone'
}   

sql.on('error', (err)=> {
    // error handler
});
sql.connect(config).then(
    (pool) =>{
        return pool.request()
                    .query('select * from course');
    }).
    then(result=> {
        console.log('dasdasdsa');
        console.log(result);
    }).
    catch( (err)=>{
        console.log(err);
    });

I Component services I have this

and in computer management tcp/ip is enabled

What am I doing wrong? I am using Windows authentication for SQL Server.

Try localhost or 127.0.0.1 as host; make sure MSSQL is turned on and listens throughout firewalls. — user8555937
– user8555937, Commented Jan 19, 2020 at 18:53

David Browne - Microsoft · Accepted Answer · 2020-01-19 19:21:41Z

1

The normal troubleshooting process is to verify:

SQL Server has TCP/IP enabled and is configured to listen on port 1433 in Configuration Manager.
SQL Server is running and the SQL Server Error log has an entry like Server is listening on [ 'any' <ipv4> 1433].
The Windows Firewall is not blocking inbound TCP connections on port 1433
The client can resolve the SQL Server's hostname correctly
The client can connect over TCP/IP to port 1433 on the SQL Server, eg by powershell's Test-NetConnection -ComputerName [sqlserverhostname] -Port 1433

edited Jan 19, 2020 at 19:21

answered Jan 19, 2020 at 19:09

David Browne - Microsoft

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to connect to SQL Server database using mssql and expressjs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related