Connecting to local Windows MSSQL DBs with DBeaver

I can connect to the database in Microsift SQL Server Management Studio, but had no joy hooking up DBeaver to the db. I was however able to connect DBeaver to my Docker MSSQL db instances so I was a bit flumoxed.

The answer as ever was provided in Stack Overflow, and a link to the following posts.

And from all the way back in 2007 – but still relevant :

MSSQL doesnt enable TCP/IP connections by default so you have to set that up and manually give it a defined port number (unless you want it to dynamically change on each startup).

Dave Walker
Dave Walker is a middle aged programmer living in North Yorkshire, who loves music and used to enjoy constantly restarting fitness regimes with a bit of football, cycling, swimming & jogging. Now I just eat biscuits.

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.