
For example, for a server listening on port 1401, enter ,1401.īy default, the connection string uses port 1433. If you need to specify a port, use a comma to separate it from the name. To connect to a SQL Server container, specify the IP address of the container's host machine. To connect to a remote SQL Server, enter the name of the target SQL Server, or its IP address. Use localhost to connect to a SQL Server instance on your local machine. After specifying each value, press Enter to continue.

Then select Create to create a new connection profile for your SQL Server.įollow the prompts to specify the properties for the new connection profile. Select the MS SQL: Manage Connection Profiles command. A SQL file, such as the empty SQL file you created, must have focus in the code editor before you can execute the mssql commands.
