How to connect to a local named instance

[margusbirk]

I have a local SQLServer instance named SQLSRV. I usually connect to it using the following connectionstring:
data source=.\SQLSRV;initial catalog=mayflowertests;persist security info=True;MultipleActiveResultSets=True;integrated security=SSPI

When I try to deploy migrations using mayflower I get a connection error, I've tried these commands but they result in errors:

1. mayflower -d .\migrations\ --connection "Server=(local)\SQLSRV;initial catalog=mayflowertests;persist security info=True;UID=sa;PWD=mypw;MultipleActiveResultSets=True"

2. mayflower -d .\migrations\ --connection "Server=.\SQLSRV;initial catalog=mayflowertests;persist security info=True;UID=sa;PWD=mypw;MultipleActiveResultSets=True"

3. mayflower -d .\migrations\ --connection "Server=.\\SQLSRV;initial catalog=mayflowertests;persist security info=True;UID=sa;PWD=mypw;MultipleActiveResultSets=True"

results in - message: 'Failed to lookup instance on (local) - getaddrinfo ENOTFOUND (local)'

does mayflower support local named instances?

[margusbirk]

As a temporary solution I was able to bind the local instance to an IP and configure mayflower to connect to that ip, but it would be nice to have a way to connect to named instances.

[bretcope]

I've never done anything with named instances, so I'm honestly not sure.