关于连接其他计算机上的sql服务器
那台服务器是sql server 和windows身份验证模式,我的连接代码: Dim cn As New SqlClient.SqlConnection("Data Source=10.111.124.116\生产管理;Initial Catalog=线路身份证;Uid=sa;Password=yjyb123"),总是连接不上,望各位老师指点,感激涕零 --------------------编程问答-------------------- 报什么错,tcp ip/name 开了吗 --------------------编程问答-------------------- 开了,请各位老师指点 --------------------编程问答-------------------- Public Class ConnectSampleDim cn As System.Data.SqlClient.SqlConnection
Public Shared Sub Main()
Try
'要连接的服务器名
Dim ServerName As String = "localhost"
'数据库名称
Dim DBName As String = "Sample"
'用户名
Dim UserID As String = "TestUser"
'密码
Dim Password As String = "Password"
cn = New System.Data.SqlClient.SqlConnection()
'用SQL Server认证连接
cn.ConnectionString = _
"Data Source = " & ServerName & _
";Initial Catalog = " & DBName & _
";User ID = " & UserID & _
";Password = " & Password
'用Windows认证连接
'cn.ConnectionString = _
' "Data Source = " & ServerName & _
' ";Initial Catalog = " & DBName & _
' ";Integrated Security = SSPI"
cn.Open()
Console.WriteLine("{0}的{1}连接", ServerName, DBName)
Catch ex As Exception
Console.WriteLine("Error! {0}", ex.Message)
Finally
'关闭并释放
If cn.State <> ConnectionState.Closed Then
cn.Close()
End If
cn.Dispose()
End Try
End Sub
End Class
--------------------编程问答-------------------- Dim cn As New SqlClient.SqlConnection("Data Source=10.111.124.116\生产管理;Initial Catalog=线路身份证;Uid=sa;Password=yjyb123")
我把sql server装在我自己的机子上,然后运行,可以连接上,可是当在其他机子上运行以上代码时,总是提示:在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: SQL Network Interfaces, error: 26 - 定位指定的服务器/实例时出错)请各位老师指点。 --------------------编程问答-------------------- 我用的是sql server 2008 --------------------编程问答-------------------- 不应用windows身份验证模式 --------------------编程问答-------------------- 需要设置sql server
参考
配置SQL Server 2008(2005)允许远程连接
http://blog.csdn.net/sage425/article/details/6279474
补充:.NET技术 , VB.NET