Integrate msnodesqlv8 with Typeorm

[annumsin]

I have to implement Window Authentication in Nestjs + mssql which uses TypeOrm so after lots of findings msnodesqlv8 driver was the most recommended but I don't find enough information to do so from the documentation so please advice

Expected behaviour:

Window Authentication should work with msnodesqlv8 + TypeOrm

Actual behaviour:

I tried this snippet -

@Module({ imports: [ ConfigModule.forRoot(), TypeOrmModule.forRoot({ type: 'mssql', url: 'Driver=msnodesqlv8;Server=W70100\SQLEXPRESS01;Database=Test;Trusted_Connection=Yes' }); });

I got this error - ConnectionError: Failed to lookup instance on river=msnodesqlv8;Server=W70100 - getaddrinfo ENOTFOUND river=msnodesqlv8;Server=W70100

so, please if you can correct or provide the right snippet or even example also helps also I have made sure following points are taken care -

• Enter wrong server details by mistake. Make sure to enter correct SQL Server instance name while making database connection.
• Try to connect using ip address and port number instead of putting server name in connection string.
• SQL Server Instance is not accessible due to firewall or any reason. Check firewall details. Your port 1433and UDP port (1434) - of SQL Server browser should be enabled. These ports might be blocked.
• SQL Server service is not running on SQL Server. You can try to start or restart SQL Server services
• Make sure to enable TCP/IP and Named Pipes, which you can check from SQL Server Configuration Manager.
• Remote connection must be enabled to connect to databases remotely. Right click on SQL Server instance name in SSMS and choose Properties. You will get Server properties window. Click on Connections from left side pane and tick the check box on Allow remote connections to this server option from right side pane.

• SQL browser service should not be stopped if your security policy allows it.

  Software versions

  • NodeJS: 14.17.3
  • mssql: 6.3.1
  • SQL Server: 18
  • Operating System: Window 10
  • TypeORM : 0.2.31

[dhensby]

I'm not knowledgeable in typeORM so I can't provide much guidance here.

When using msnodesqlv8 a different import is needed from the library as it is exposed via a separate file. I don't know how TypeORM deals with that, but it may mean you need to create a custom DB adapter.

Sorry I can't be of more help.