[BUG] Unable to connect to SQL Server.

cweijan / vscode-database-client

Database Client For Visual Studio Code

https://database-client.com

MIT License

2.4k stars 265 forks source link

[BUG] Unable to connect to SQL Server. #782

Open TimNoob opened 1 year ago

TimNoob commented 1 year ago

OS: Windows
DB: MSSQLSERVER 16

I have connection string on C# "Data Source=localhost;Initial Catalog=master;User id=user;Password=password;Integrated Security=True". On C# it's work but if i connect on extension not working.

I tried authorization through a windows account, I tried authorization with and without Encription. Result is unsuccessful. What am I doing wrong?

Sry my english bad.

cweijan commented 1 year ago

What does it mean here? I need to know what the error message is.

mirkadev commented 1 year ago

What does it mean here? I need to know what the error message is.

An error occurred when "user" user was trying to log in to the system

cweijan commented 1 year ago

Please check the link below, the sql server needs to open the tcp port to connect through this extension.

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver15#SSMSProcedure