The below connection string gives me the error at Db.migrate().
"connectionString": "server=localhost\\SQLEXPRESS, 1444; Initial Catalog=Operational;Integrated Security=True;",
I tried changing localhost to my computer name, removed port, changed initial catalog to 'Database', tried server=.\\SQLEXPRESS, server=.\\, server=localhost and all other combinations I could think of, to no avail.
- I have allowed the port in firewall inbound/outbound rules.
- SQL Server is running and I'm able to login to SQL Server Management Studio.
The error:
Microsoft.Data.SqlClient.SqlException HResult=0x80131904 Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 40 - Could not open a connection to SQL Server) Source=Core Microsoft SqlClient Data Provider StackTrace: at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
