c# Winform 连接 sql server 2005 的问题

hphubei

现在在其他客户端访问的错误就是这个：

用 sql server 2000 的时候是没有问题的

hphubei

有人能帮帮我么，急啊

hphubei

I am waiting for suggestions and it is urgent.

hphubei

Errors connecting to SQL Server Express 2005
Are you getting errors connecting to SQL Server Express 2005 via remote client software and yet have no problem connecting to it on the local machine?
Some of the errors you might be seeing are:
•        sql server does not allow remote connections
•        SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified
•        An error has occured while establishing a connection to the server. When connecting to SQL Server 2005,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(provider:Named Pipes Provider,error:40-Could not open connection to SQL Server))
•        Server does not exist or access denied
If yes, then read on because SQL Server Express 2005 is not automatically configured for remote access during installation. It can be enabled however, so the problems you are having are more of a "feature" than a bug.
Why this page?Well, we too ran into this problem - just as you have now. In recognition of all of the kind help we received from the Internet newsgroups we thought it might be useful to collect the information here so as to provide assistance to others in the same position. If you have any suggestions for updates to this page please let us know

hphubei

Here's a quick summary of the actions you need to take. The first three actions have a separate page which provides more details and some screen shots of the procedure.
1.        [Link] Enable the TCP/IP protocol using the Surface Area Configuration Utility
2.        [Link] Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility
3.        [Link] Make sure the SQL Server browser is started. Note this step is optional. It is possible to set the SQL Server instance to use a fixed IP address - but this is non-standard for named instances. See sqlexpress's WebLog for details.
4.        Make sure SQL Server and SQL Server Browser are exempted by the firewall on the server machine. This is done by putting sqlservr.exe and sqlbrowser.exe as an exception in the windows firewall.
5.        Note: In order to get things to work. You might need to completely reboot the server machine after making the changes. There have been reports (thanks P.C.) that starting and stopping the SQL Server and Browser software is not enough.

hphubei

网上看到有人遇到同样的问题，解决办法是：

1: 启用数据库CLR支持
--***********************************************
EXEC sp_configure 'show advanced options','1';
go
reconfigure;
go
EXEC sp_configure 'clr enabled','1'
go
--***********************************************
2: 更改数据库信任模式(为正确添加到程序集)
TRUSTWORTHY { ON | OFF }
ON
使用模拟上下文的数据库模块（例如，用户定义函数或存储过程）可以访问数据库以外的资源。

OFF
模拟上下文中的数据库模块不能访问数据库以外的资源。
--***********************************************
Alter Database 数据库名称
SET TRUSTWORTHY ON
--***********************************************


可是这个办法对我的问题没有作用

hphubei

烦恼啊，网上找了一天的资料了，依然没有解决方案

hphubei

http://www.sql-server-performanc ... p;method=TopicQuote

做了，好像还是没有作用，我要疯了

hphubei

奇怪，在家里的另外一台电脑上面又是另外一个错误了：

hphubei

server=WCS-MARK\SQLEXPRESS;initial catalog=xxx;user id=sa;password=xxx;Integrated Security=SSPI; Trusted_Connection=true;Connect Timeout=30;


这是我的连接字符串，问题出现在哪里那？