Question

C#连接SQL server2008 出现错误

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
using System;
using System.Data.SqlClient;
public class a
{
public static void Main(string[] args)
{
string source = "server = (loacal);" +
"integrated security = SSPI;" +
"database = nihao";
string select = "update buhao" +
"set age = 10" +
"where name= 'zhang'";
SqlConnection conn = new SqlConnection(source);
conn.Open();
SqlCommand cmd = new SqlCommand(select, conn);
int rowsReturned = cmd.ExecuteNonQuery();
Console.WriteLine("{0} rows affect!");
conn.Close();
Console.WriteLine();
}
}
这是我编写的代码，刚刚才接触C#有关数据的操作

Answer 1

1、ping下那个服务器是不是通确定网络ok
2、确定服务器上是否有防火墙，有的话检查对应端口是否被屏蔽
3、检查服务器本地连接是否可用，确定服务器可正常运作
4、sqlserver有个远程连接配置是否开启，可联网查下怎么配置
5、检查c#中的连接字符串是否正确，可在vs服务器资源管理器中连接数据库，然后用连接的属性作为c#的连接配置。

Answer 2

上面的代码有两处明显错误：
1. 不是(loacal)，应该是(local)，也可以简写为.
2. update语句buhao和set中应该有空格

请修改代码如下尝试：

using System;
using System.Data;
using System.Data.SqlClient;

public class a
{
public static void Main(string[] args)
{
string source = "server = .;integrated security = SSPI;database = nihao";
string select = "update buhao set age = 10 where name= 'zhang'";
SqlConnection conn = new SqlConnection(source);
SqlCommand cmd = new SqlCommand(select, conn);
conn.Open();
int rowsReturned = cmd.ExecuteNonQuery();
conn.Close();
Console.WriteLine("{0} rows affect!");
Console.ReadLine();
}
}

Answer 3

上面的代码有两处明显错误：
1. 不是(loacal)，应该是(local)，也可以简写为.
2. update语句buhao和set中应该有空格

请修改代码如下尝试：

using System;
using System.Data;
using System.Data.SqlClient;

public class a
{
public static void Main(string[] args)
{
string source = "server = .;integrated security = SSPI;database = nihao";
string select = "update buhao set age = 10 where name= 'zhang'";
SqlConnection conn = new SqlConnection(source);
SqlCommand cmd = new SqlCommand(select, conn);
conn.Open();
int rowsReturned = cmd.ExecuteNonQuery();
conn.Close();
Console.WriteLine("{0} rows affect!");
Console.ReadLine();
}
}

Answer 4

楼主，你要把你写的连接代码贴出来啊，不然怎么知道为什么是错的

Answer 5

请确认你的数据库名称是否正确，否则你的数据库是否支持远程连接。可能是数据库设置的问题。 自己百度下 数据库远程连接的设置。