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

Please follow and like us:
Pin Share
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.

Follow by Email
YouTube
LinkedIn
Share