新人求助 无法连接数据库

Question

{"在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: SQL 网络接口, error: 25 - 连接字符串无效)"}   public static bool findPerson(string userName)
    {
        SqlConnection con = personOperate.createCon();
        con.Open();
      
        SqlCommand cmd = new SqlCommand("select count(*) from yonghu where userName='" + userName + "'", con);
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        if (count > 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
我加添用户就会出现这个提示，谢谢大家了

Answer 1

http://www.google.com.hk/search?sourceid=chrome&ie=UTF-8&q=%E5%9C%A8%E5%BB%BA%E7%AB%8B%E4%B8%8E%E6%9C%8D%E5%8A%A1%E5%99%A8%E7%9A%84%E8%BF%9E%E6%8E%A5%E6%97%B6%E5%87%BA%E9%94%99%E3%80%82%E5%9C%A8%E8%BF%9E%E6%8E%A5%E5%88%B0+SQL+Server+2005+%E6%97%B6%EF%BC%8C%E5%9C%A8%E9%BB%98%E8%AE%A4%E7%9A%84%E8%AE%BE%E7%BD%AE%E4%B8%8B+SQL+Server+%E4%B8%8D%E5%85%81%E8%AE%B8%E8%BF%9B%E8%A1%8C%E8%BF%9C%E7%A8%8B%E8%BF%9E%E6%8E%A5%E5%8F%AF%E8%83%BD%E4%BC%9A%E5%AF%BC%E8%87%B4%E6%AD%A4%E5%A4%B1%E8%B4%A5%E3%80%82+(provider%3A+SQL+%E7%BD%91%E7%BB%9C%E6%8E%A5%E5%8F%A3%2C+error%3A+25+-+%E8%BF%9E%E6%8E%A5%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%97%A0%E6%95%88)

Answer 2

 personOperate.createCon();这个是什么，贴出来。

Answer 3

http://www.google.com.hk/search?sourceid=chrome&ie=UTF-8&q=%E5%9C%A8%E5%BB%BA%E7%AB%8B%E4%B8%8E%E6%9C%8D%E5%8A%A1%E5%99%A8%E7%9A%84%E8%BF%9E%E6%8E%A5%E6%97%B6%E5%87%BA%E9%94%99%E3%80%82%E5%9C%A8%E8%BF%9E%E6%8E%A5%E5%88%B0+SQL+Server+2005+%E6%97%B6%EF%BC%8C%E5%9C%A8%E9%BB%98%E8%AE%A4%E7%9A%84%E8%AE%BE%E7%BD%AE%E4%B8%8B+SQL+Server+%E4%B8%8D%E5%85%81%E8%AE%B8%E8%BF%9B%E8%A1%8C%E8%BF%9C%E7%A8%8B%E8%BF%9E%E6%8E%A5%E5%8F%AF%E8%83%BD%E4%BC%9A%E5%AF%BC%E8%87%B4%E6%AD%A4%E5%A4%B1%E8%B4%A5%E3%80%82+(provider%3A+SQL+%E7%BD%91%E7%BB%9C%E6%8E%A5%E5%8F%A3%2C+error%3A+25+-+%E8%BF%9E%E6%8E%A5%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%97%A0%E6%95%88)

Answer 4

error: 25 - 连接字符串无效链接字符串有问题。
写在web.config中后台获取的时候用configurationManager.connectionString["SYXTConnectionString"].ToString()Web.config中加入
<connectionStrings> <add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings>