Home Forums Administration Connecring to MSSQL Local DB

Viewing 1 reply thread
  • Author
    Posts
    • #7281
      Neha SharmaNeha Sharma
      Participant

      Hi,

      1. Is it possible to connect NexJ studio to MSSQL Local DB (As certain sites suggest it is not supported)
      We tried Local DB and facing below error on TestConnection
      ****************************
      “Error: Unable to create a new resource. (err.pool.resource.create)
      Network error IOException: Connection refused: connect”
      *************************************
      2. Instead can we use
      “Microsoft SQL Server Management Studio Express”, how it is different from “Microsoft® SQL Server® 2012 Express”

      Kindly guide us through exact package name that can be used for database connectivity

      Neha

      0
    • #7304
      Ed ShawEd Shaw
      Keymaster

      Neha,

      It is definitely possible to connect to a local MSSQL database. Instructions on how to do it, including a few important MSSQL specific configuration steps, can be found at the Community Training Page in the Introduction and Setup course. Look at the NexJ Studio Installation Instructions for information on how to configure MSSQL. The exact version of MSSQL doesn’t really matter, but the instructions are written for Express 2014 I believe.

      If you are getting a “Connection refused: connect” error, your MSSQL instance isn’t configured correctly, or you aren’t connecting with the correct credentials. See the following post for information on how to quickly test your connection in the “Test Connection” button on your Relational Database Connection environment editor in Studio. See this answer.

      0
Viewing 1 reply thread
  • You must be logged in to reply to this topic.