This message was deleted.

Yes, that should be possible. You can try using host.docker.internal as the db host, which points to your local computer.

Thanks Jeremy for the speedy response! do you mean in the connection string changing the server name from "Localhost" to "host.docker.internal"? i'm currently in the Add Data Source window and I'm seeing this:

I believe for server, you just need to put

host.docker.internal

and nothing else. It's expecting a URL

Thanks, that seems to do something now but I have a new error: 'Failed to connect to host.docker.internal:1433 - Could not connect (sequence)' I'm going to check the tcp/ip config of the local database but any other ideas?