sql server connect: Connection error - please help -- sql server connect

Connection error - please help

davin
8/23/2004 3:43:02 PM

sql server connect:

I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:

Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).

In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?

Any comments would be very very appreciated.

Thank you.

Connection error - please help

James
8/24/2004 5:05:20 AM

I encountered similar error before and I installed the
latest SQL SP and it works. Not sure whether it is
applicable for your case or not.

rgrds,
James Gan HJ

[quoted text, click to view]

RE: Connection error - please help

kevmc NO[at]SPAM online.microsoft.com
8/24/2004 10:25:15 PM

Try making a network trace from the IIS machine to SQL and review the
traffic.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

RE: Connection error - please help

Rob
8/25/2004 5:55:45 AM

Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

[quoted text, click to view]

RE: Connection error - please help

kevmc NO[at]SPAM online.microsoft.com
8/25/2004 4:59:02 PM

IIS is the client to SQL. I"m asuming that they are two different machines.

client -->IIS--->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Re: Connection error - please help

(eriphaz001 NO[at]SPAM yahoo.com)
9/17/2004 6:01:22 AM

I have the same problem. Help.

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.