sqlserver连接远程数据库

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        string connectionString = "Server=远程服务器地址,端口号;Database=数据库名称;User Id=用户名;Password=密码;";
        
        try
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("成功连接到远程数据库！");
                
                // 执行查询操作
                string query = "SELECT * FROM 表名";
                using (SqlCommand command = new SqlCommand(query, connection))
                {
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            // 处理查询结果
                            Console.WriteLine(reader["列名"].ToString());
                        }
                    }
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("连接远程数据库时出错：" + ex.Message);
        }
    }
}