Connection Error - please help

From: davin (davin_at_discussions.microsoft.com)
Date: 08/23/04 

Date: Mon, 23 Aug 2004 15:31:02 -0700

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.

Relevant Pages

  • Re: Heres a rather broad question...
    ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ... IIS user doesn't have the proper permissions to access the database, ...
    (microsoft.public.data.ado)
  • Re: Are Frontpage passwords secure?
    ... These access a sql server ... > database which has credit cards. ... How does your asp get the credentials for presentation to SQL?? ... If you are using the DB for credit card info, ...
    (microsoft.public.security)
  • RE: ASP Help Needed
    ... Derive the difference, again, using datediff() ... dont touch the database (best practice - if you did a PORPER analisys ... > I need some help with the ASP. ... > I am using MS SQL server 2000 as database ...
    (microsoft.public.inetserver.asp.components)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)