sqlserver连接问题
请教:
用vb.net 连接sqlserver数据库,tcp/ip已启用,本机连接,一切正常 ,如下
Public connectionString As String = "Data Source=.;Initial Catalog=flaxdb;Integrated Security=True "
但数据源一改成ip,就连接不上,如下
Public connectionString As String = "Data Source=10.1.0.157:1433;Initial Catalog=flaxdb;Integrated Security=True "
防火墙都已经关闭,1433端口换成其它端口,也不行 .
不知该如何设置!
[解决办法]
Public connectionString As String = "Server=10.1.0.157; " & "Database=flaxdb;Integrated security=true; "