Connection from ASP to SQL server

[vichet]

Dear All;

I have two servers: Webserver(WebServer) and Database server(DBServer).

In Webserver, i asp to connect to sqlserver in dbserver. but i can not
connect it, it show error "No Trust Connection"

but the save connection string, when i used it in VB, it is ok. Also i can
connect from webserver to dbserver by using Analy Query, it is ok

please help "How to connect it". below is my asp code:
<%
set cnt=server.createobject("adodb.connection")
cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial
Catalog=MyDB;Uid=dbadmin;pwd=root"

[Bob Barrows [MVP]]

vichet wrote:

Dear All;

I have two servers: Webserver(WebServer) and Database
server(DBServer).

In Webserver, i asp to connect to sqlserver in dbserver. but i can not
connect it, it show error "No Trust Connection"

but the save connection string, when i used it in VB, it is ok. Also
i can connect from webserver to dbserver by using Analy Query, it is
ok

please help "How to connect it". below is my asp code:
<%
set cnt=server.createobject("adodb.connection")
cnt.open "Provider=SQLOLEDB.1;Data Source=Dbserver;Initial
Catalog=MyDB;Uid=dbadmin;pwd=root"

.
.
.
%>

Vichet

Your error is covered in this article:
http://www.aspfaq.com/show.asp?id=2009

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"