[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或访问被拒绝

[fushao]

Microsoft OLE DB Provider for SQL Server 错误 '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或访问被拒绝

/admin/conn.asp，行6

conn.asp文件如下：

<%
dim conn,connstr
set conn=Server.CreateObject("ADODB.Connection")
connstr="driver={SQL Server};server=LIANG;uid=sa;pwd=;database=polystar;"
'connstr="PROVIDER=SQLOLEDB;DATA SOURCE=LIANG;uid=sa;pwd=;database=polystar;"
conn.Open connstr
%>
请问这是什么原因？该如何解决？：）

[rexsp]

可能是SQL sever服务器没有启动服务或者拒绝服务

[lsrzm]

<%dim dbconn
set dbconn=server.CreateObject("adodb.connection")
'ole db for SQL Server Provider
ConnectionString ="Provider=SQLOLEDB;"
'database server name
ConnectionString =ConnectionString & "Data Source=HTehome;"
'database name
ConnectionString =ConnectionString & "Initial Catalog=HTehome;"
'user name
ConnectionString =ConnectionString & "User ID=htehome;"
'password
ConnectionString =ConnectionString & "Password=Hiteker"

on error resume next
dbconn.Open ConnectionString',"htehome","hiteker"
if err.number <>0 then
Response.Write ConnectionString
Response.Write err.Description
Response.End
end if
function closedatabase
dbconn.Close
set dbconn=nothing
end function
%>

[阿妖]

constr="Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;PWD=;Initial Catalog=One_card;Data Source=polystar"

[Reker熊]

connstr="PROVIDER=SQLOLEDB.1;DATA SOURCE=LIANG;uid=sa;pwd=;database=polystar;"

如果有問題應該是你sql server沒有啟動一類的原因

[gshope]

connstr="driver={SQL Server};server=LIANG;uid=sa;pwd=;database=polystar;"

把server=换成IP地址试试