Has anyone successfully connected to a local default SQL Server installation using “Database Connection”? I’ve tried different combinations of criteria; none has worked.
–I can connect to the local db using the “Direct Database Connection” with no problems.
–I can connect to a production db with no issues.
–I’m using default install of SQL Server 2016, IIS, Windows 10.
–Default port is 1433.
–Dynamic Ports are disabled.
–It is not a “Named Instance” installation of sql server; the default name is MSSQLSERVER.
–Visual Studio connects with no issues.
