用ASP连接SQL SERVER连结时出现未与信任SQL SERVER连接相关联(200分)

我的ASP连接SQL SERVER代码为"Driver={SQL Server};Server=cp125;Database=Asp;uid=SA;pwd="
我的SQL SERVER装在本地机子上,当我把测试文件也放在本地机子上时,一切正常!
但当我把测试文件放在远程测试服务器上时,也就是另一台电脑上时,SQL SERVER还是同一个,就会出现未与信任SQL SERVER连接相关联!
也就是测试文件与SQL 数据库不在同一机子上时就会出现这种状况!
希望各位大虾指教!

sqlserver身份验证改为sqlserver+windows

确实用的是sqlserver+windows是呀,但就是会出现上述状况

我用的是asp+ado
连接字串
"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Asp;Data Source=cp125"

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim MM_connWap_STRING
MM_connWap_STRING = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=wap;Data Source=XINYANG"
Dim rsLottery
Dim rsLottery_numRows
Set rsLottery = Server.CreateObject("ADODB.Recordset")
rsLottery.ActiveConnection = MM_connWap_STRING
rsLottery.Source = "SELECT LOTTERY_ID, LOTTERY_NAME, LOTTERY_CONTENT, LOTTERY_TIME FROM dbo.LOTTERY"
rsLottery.CursorType = 0
rsLottery.CursorLocation = 2
rsLottery.LockType = 1
rsLottery.Open()
rsLottery_numRows = 0
Response.ContentType="text/vnd.wap.wml"
Response.Write("<?xml version=""1.0"" encoding=""gb2312""?><!DOCTYPE wml PUBLIC ""-//WAPFORUM//DTD WML 1.1//EN"" ""http://www.wapforum.org/DTD/wml_1.1.xml"" >")

Response.Write("<wml><card><p>")

Response.Write("</p>")


Response.Write("<p>")

While (Not rsLottery.EOF)
Num=Num+1
Response.Write(Num)
Response.Write("<a href=""lottery.asp?lottery_id="&amp;rsLottery.Fields.Item("LOTTERY_ID").Value&amp;""">"&amp;rsLottery.Fields.Item("LOTTERY_NAME").Value&amp;"</a>")
Response.Write("<br>")
rsLottery.MoveNext
Wend
Response.Write("</p>")

Response.Write("<p><a href=""index.asp"">返回上级</a></p>")
Response.Write("</card></wml>")
%>
<%
rsLottery.Close()
Set rsLottery = Nothing
%>

在客户端　“运行”中输入cliconfg，注册要连接服务器的TCP/IP连接别名

你们的方法我试过了还是不行呀,请教各位大虾,你们的网页文件和数据库都在同一服务器上吗?有没试过在不同电脑上如何处理呀?你们是如何处理的!

你确认在网页文件的电脑上注册了要连接服务器的TCP/IP连接别名？
再连接不上的话，先用别的工具在有网页的电脑上连接要连接的服务器试试能不能连接上