SQL server 数据库远程连接

最新推荐文章于 2024-11-07 09:39:50 发布

原创最新推荐文章于 2024-11-07 09:39:50 发布 · 592 阅读

0 ·

CC 4.0 BY-SA版权

SQL server 专栏收录该内容

6 篇文章

订阅专栏

本文提供了一步到位的指南，教你如何在SQL Server数据库中进行远程连接，包括防火墙设置、端口开启及连接字符串的正确配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL server 数据库远程连接：

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

防火墙关闭

或者开启相应的1433端口

开启方法：http://blog.youkuaiyun.com/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();