为什么在2005中总是报[SQL Native Client]Shared Memory Provider: Timeout error [258].的错误?

[ltg]

为什么在2005中总是报[SQL Native Client]Shared Memory Provider: Timeout error [258].的错误?

[gohst001]

2005还不熟悉
不过搜索了一下 这文章好象说的不错
http://blogs.msdn.com/sql_protocols/archive/2005/09/28/474698.aspx

[ltg]

这篇文章我早已经看过了，上面没有说明如何避免呀．

[athossmth]

后面不是说了吗

1) Were you trying to make local or remote connection?
2) What does your connection string looks like, please try removing "lpc:" prefix if you specified.
3) Run *cliconfg* in the command line, check off box "enable shared memory protocol".
4) Double check whether your SQL 2000 instance started successfully, and listen on shared memory / named pipe/ tcp from server errorlog.

[athossmth]

run "start->programs->microsoft sql server 2005->configuration tools->sql server configuration manager",
select "sql server configuration manager->sql serer 2005 network configuration->protocols for SQLEXPRESS", set "shared Memory" as "enabled",
select "sql server configuration manager->sql native client configuration->client protocols", set "shared Memory" as "enabled",

[liudianhalf]

有个设置是脚本超时时间,看看是不是这个的设置和你的查询脚本运行时间之间存在问题.另外程序的sql语句运行时间长也可能产生这样的问题.如果是以上原因那么你要优化你的查询语句了.