skip to Main Content

DB connectivity with SQL Server having windows authentication

In order to establish DB connection with SQL Server having windows authentication firstly you need to select your project and navigate to Settings > Project Settings > DB Settings and provide the required details as shown in the below snapshot.

Now make sure sql server protocols are enabled in your computer management.

Go to Windows Search > Computer Management > Services and Applications > SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER

If the port is not configured in TCPIP follow the steps below

  • Choose SQL Server Network Configuration -> Protocols for -> Right click on TCP/IP -> select Enable (if already enabled then move to next step) -> Right click to TCP/IP again -> Properties -> Choose tab IP Address -> In IPAll group: Clear value of TCP Dynamic Ports and set 1433 to TCP Port -> Click OKNote: Copy one of the IPs in the Properties table to do config later
  • Double click to SQL Server Services – > Right click to SQL Server (USER) ** -> Choose **Restart

Now you need to download the sqljdbc dll using this link.

Once you open this link, click on click here to download manually

Download the exe as highlighted below

Double click on the downloaded file to unzip it and ,copy the dll present on below path C:\Users\Microsoft JDBC Driver 6.0 for SQL Server\sqljdbc_6.0\enu\auth\x64

Paste the copied dll file in BeatBlip folder in parallel to beatblip.exe

Restart the sql server services on your machine and try to connect SQL Server DB with BeatBlip using windows authentication.

Back To Top