SQL Server 2008密码以分号结尾

<add name="DbConn" connectionString="Data source=LOCALHOST;Database=MYDB;Trusted_Connection=no;User Id=myuser;password=password;" providerName="System.Data.sqlClient" />

用单引号封装密码.例如给出密码iloveachALLENge;您的连接字符串应包含password =’iloveachALLENge;’;.

我使用以下代码连接到sql Server 2008 R2.

var sqlConnection = new sqlConnection()
            {
                ConnectionString = "Server=DT2719MOD;Database=abs2;User Id=Testuserlogon;password='iloveachALLENge;';"

            };
        sqlConnection.open();
        Console.WriteLine(sqlConnection.StatE);
        sqlConnection.Close();

编辑：
还尝试使用您拥有的连接字符串,它可以在我的机器上运行.

ConnectionString="Data source=DT2719MOD;Database=abs2;Trusted_Connection=no;User Id=Testuserlogon;password='iloveachALLENge;';"