I was wondering if someone could help me with this problem I have? I am not able to connect to my SQL server even though I correctly provided my IDE with the SQL server's port number and my IP address.
static SqlConnection connection = new SqlConnection(@"Data Source=192.168.1.198,49172;Initial Catalog=irradix_base;Integrated Security=False;User ID=sa;Password=pass;");
CodePudding user response:
Can you try this way Data Source=192.168.1.198,49172;Initial Catalog=EnVerifyDB;User ID=sa;Password=123456
CodePudding user response:
So as it turns out, I found an answer from this post which uses a powershell command to find the listening port, here is the code: ForEach ($SQL_Proc in Get-Process | Select-Object -Property ProcessName, Id | Where-Object {$.ProcessName -like "SQL"})
{
Get-NetTCPConnection | Where-Object {$_.OwningProcess -eq $SQL_Proc.id} |
Select-Object -Property @{Label ="Process_Name" e={$SQL_Proc.ProcessName}},
@{Label ="Local_Address";e={$.LocalAddress ":" $_.LocalPort }}, @{Label ="Remote_Address";e={$_.RemoteAddress ":" $_.RemotePort}}, State |
Format-Table
}