MSSQL on Linux?

Question

[DailyDDose]

При попытке выполнения миграции
dotnet ef database update
Вываливается ошибка:
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: 35 - An internal exception was caught)

Сам SQL Server работает

alex@alex-ander ~ $ sqlcmd -S localhost -U SA
Password: 
1> use api_dev
2> go
Changed database context to 'api_dev'.

порт 1443 открыт

iptables

alex@alex-ander ~/Templates/WebApiServer/WebApiServer $ sudo iptables -L -n -v
Chain INPUT (policy ACCEPT 1389 packets, 1482K bytes)
pkts bytes target prot opt in out source destination
0 0 ACCEPT tcp -- * * 0.0.0.0/0 0.0.0.0/0 tcp dpt:1433

содержимое appsettings.json:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=sqlinux;User Id=SA;Password=UIHt782435Gnalzx;Database=api_dev;Trusted_Connection=false"
  }
}

Answer 1

[Константин Цветков]

SQL Server is configured to allow remote connections

Включить IP

Answer 2

[DailyDDose]

//closed.
вместо sqlinux нужно было писать localhost.

"DefaultConnection": "Server=localhost;User Id=SA;Password=UIHt782435Gnalzxatabase=api_dev;"

alex@alex-ander ~/Templates/WebApiServer/WebApiServer $ dotnet ef database update 
Applying migration '20180103044038_Initial'.
Done.
alex@alex-ander ~/Templates/WebApiServer/WebApiServer $