vscode-database-client icon indicating copy to clipboard operation
vscode-database-client copied to clipboard

Published 20 hours ago • verified publisher icon cweijan

[BUG] Unable to connect to SQL Server.

Open TimNoob opened this issue 2 years ago • 4 comments
trafficstars

  • 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.

image

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.

TimNoob avatar Mar 03 '23 21:03 TimNoob

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

image

cweijan avatar Mar 04 '23 04:03 cweijan

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

mirkadev avatar Mar 06 '23 17:03 mirkadev

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

cweijan avatar Mar 10 '23 07:03 cweijan