SQL无法通过IP地址C＃连接

发布于 2025-01-25 07:26:52 字数 276 浏览 3 评论 0原文

我想知道是否有人可以帮助我解决这个问题？即使我正确地为SQL Server的端口号和IP地址提供了我的IDE，我也无法连接到SQL Server。

 static SqlConnection connection = new SqlConnection(@"Data Source=192.168.1.198,49172;Initial Catalog=irradix_base;Integrated Security=False;User ID=sa;Password=pass;");

原文

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;");

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

月隐月明月朦胧 2025-02-01 07:26:52

你能这样尝试吗
数据源= 192.168.1.198,49172;初始目录= EnverifyDB;用户ID = SA;密码= 123456

回复收藏 0 原文

春花秋月 2025-02-01 07:26:52

因此，事实证明，我从使用PowerShell命令查找听力端口，这是代码：

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
}

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
}

回复收藏 0 原文

~没有更多了~