I am currently developing an ASP.NET app using Visual Studio Code on mac. I am trying to use "mssql extension" to get connection with a SQL Server database.
I followed https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-develop-use-vscode step by step. However, I always get an error message like below:
mssql: Failed to connect: System.Data.SqlClient.SqlException: 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)
Thanks for your help in advance.