SQL server 数据库远程连接

来源：互联网发布：java解析excel文件编辑：程序博客网时间：2024/05/09 23:00

SQL server 数据库远程连接：

http://www.cnblogs.com/laov/archive/2012/07/19/2578088.html

防火墙关闭

或者开启相应的1433端口

开启方法：http://blog.csdn.net/burgess_liu/article/details/11897265

            SqlConnection sqlConnection = new SqlConnection();            // sqlConnection.ConnectionString = @"data source=PANLEE-PC\MSSQLSERVER_2;initial catalog=DBImage;User Id=sa;password=lipan";            //sqlConnection.ConnectionString = @"data source=(local);initial catalog=DBImage;integrated security=true";            //sqlConnection.ConnectionString = @"data source=PANLEE-PC\MSSQLSERVER_2;initial catalog=DBImage;integrated security=true";            //sqlConnection.ConnectionString = @"data source=218.196.24.5,1443;initial catalog=DBImage;integrated security=true";            //sqlConnection.ConnectionString = @"Data Source = 127.0.0.1,1433;Initial Catalog =DBImage;integrated security=true";            //sqlConnection.ConnectionString = @"Data Source = 218.196.24.5,1433;Initial Catalog =DBImage;integrated security=true";            sqlConnection.ConnectionString = @"Data Source = 218.196.24.5,1433;Initial Catalog =DBImage;integrated security=true";            //sqlConnection.ConnectionString = @"Data Source = 127.0.0.1,1433;Initial Catalog =DBImage;User Id=sa;password=lipan";            sqlConnection.Open();            sqlConnection.Close();

0 0