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.

https://stackoverflow.com/questions/65649984/how-to-use-dbeaver-to-connect-to-sql-server-the-server-sqlexpress-is-not-config

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

http://softwaresalariman.blogspot.com/2007/04/jdbc-to-sql-server-express.html

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).