带实例参数的SQL连接字符串 [英] SQL Connection String with Instance Parameter

问题描述

我正在尝试（在.net c＃中）检查是否可以连接到SQL Server。但是，每当我在连接字符串中指定实例时，我都将无法连接。 ：

I'm trying to check (in .net c#) if I'm able to connect to SQL server. However whenever I specify instance in my connection string I'm no longer able to connect. :

这有效：

builder.ConnectionString = "Server=DLS-534;user id=sa;password=Mypassword;initial catalog=master";

这不起作用：

builder.ConnectionString = "Server=DLS-534\\SQL_2008_R2_DEV;user id=sa;password=Mypassword;initial catalog=master";

为什么不行？？。我确实需要能够连接到特定实例，因为用户可能有多个数据库。

Why doesn't this work???. I do need to be able to connect to a specific instance because a user may have several dbs.

我的完整代码：

            SqlConnectionStringBuilder builder =
                new SqlConnectionStringBuilder();

builder.ConnectionString = "Server=DLS-534\\SQL_2008_R2_DEV;user id=sa;password=Mypassword;initial catalog=master";

            using (var connection = new SqlConnection(builder.ConnectionString))
            {
                try
                {
                    connection.Open();
                    return true;
                }
                catch (SqlException)
                {
                    return false;
                }
            }

推荐答案

我具有实例的工作代码：

my working code with instance:

const string connStringWork = "Data Source=server\\instance;Initial Catalog=db;Integrated Security=True;Application Name=ЦС";

using (SqlConnection conn = new SqlConnection(connStringWork))
{

}

这篇关于带实例参数的SQL连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！