Shulou(Shulou.com)06/02 Report--

This article will explain in detail how VScode can not connect to the native MSSQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

What if VScode cannot connect to the native MSSQL?

Install the mssql extension

The mssql extension for Visual Studio Code allows you to connect to SQL Server, use Transact-SQL (T-SQL) to query, and view the results.

In Visual Studio Code, select View > Command Panel, or press Ctrl + Shift + P, or press F1 to open the Command Panel.

In the command panel, select extend: install extension from the drop-down list.

In the extension pane, type mssql.

Select the SQL Server (mssql) extension, and then select install.

After the installation is complete, select Reload to enable the extension.

Create or open a SQL file

When the language mode is set to SQL, the mssql extension enables the mssql command and T-SQL IntelliSense in the code editor.

Select File > New File or press Ctrl + N. By default, Visual Studio Code opens a new "plain text" file.

Select plain text on the status bar below, or press "Ctrl" + "K" > "M", and then select "SQL" from the language drop-down list.

Remarks

If this is the first time you have used the extension, the extension will install a supported SQL Server tool.

If you open an existing file with a .sql file extension, the language mode is automatically set to SQL.

Connect to SQL Server

Follow these steps to create a connection profile and connect to SQL Server.

Press "Ctrl" + "Shift" + "P" or "F1" to open the Command Panel.

Type sql to display the mssql command, or type sqlcon and select MS SQL: connection from the drop-down list.

Remarks

The focus in the code editor must be on the SQL file, such as the empty SQL file you created, before you can execute the mssql command.

Select the MS SQL: manage connection profile command.

Then select create to create a new connection profile for SQL Server.

Follow the prompts to specify properties for the new connection profile. After you specify each value, press "Enter" to continue.

If the connection fails, try diagnosing the problem with an error message in the Visual Studio Code output panel. To open the output panel, select View > output. In addition, review the recommendations for troubleshooting connections.

Verify the connection in the status bar below.

Connection statu

As an alternative to the previous steps, you can also create and edit connection profiles in the user Settings file (settings.json). To open the settings file, select File > preferences > Settings.

This is the end of the article on "how to deal with the native MSSQL that VScode cannot connect to". I hope the above content can be helpful to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.