W2k3 web server and SQL server

Hello,
With w2k3 web server on PC1 and w2k server and sql server
on PC2, my asp prog run s ok on PC1 but the attempt to
connect to sql server on PC2 failed with access denied.
I have no DNS.
Have you some ideas
Thank you for your answers

You probably should ask in the ASP Group for DB's. That is the area they
deal with. The full group name is:

microsoft.public.inetserver.asp.db


--

Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com


"Eric" <(E-Mail Removed)> wrote in message
news:1270501c41812$c751c7c0$(E-Mail Removed)...
> Hello,
> With w2k3 web server on PC1 and w2k server and sql server
> on PC2, my asp prog run s ok on PC1 but the attempt to
> connect to sql server on PC2 failed with access denied.
> I have no DNS.
> Have you some ideas
> Thank you for your answers

If you can't get to the other Group I mentioned in my other post,..reply and
include the section of ASP code you use to make the connection. It isn't my
specialty, but I can tell if anything jumps out at me as a possible cause.

If the code includes the SA account and password, do not include the
password, put x's or *'s where it is supposed to be and I will understand.
The section would be the piece that looks similar to:

Set objConn = Server.CreateObject("ADODB.Connection")

....and the other stuff that goes along with that.

This really isn't the group for this, but it is a "quicky" maybe I can help.

--

Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com


"Eric" <(E-Mail Removed)> wrote in message
news:1270501c41812$c751c7c0$(E-Mail Removed)...
> Hello,
> With w2k3 web server on PC1 and w2k server and sql server
> on PC2, my asp prog run s ok on PC1 but the attempt to
> connect to sql server on PC2 failed with access denied.
> I have no DNS.
> Have you some ideas
> Thank you for your answers