Locked out of my own SQL Server???

From: Stephajn Craig (s.craig@funsunvacations.com)
Date: 10/03/02 

From: "Stephajn Craig" <s.craig@funsunvacations.com>
Date: Thu, 3 Oct 2002 10:51:53 -0600

Hi all,

    I can't seem to gain access to my SQL server from within my ASP
Application.

It's the OLE-DB provider throwing back the error. I've configured my ASP
app to use an applicationwide Connectionstring Variable that uses the sa
account (for the moment) to interface with the database. What I get back
is:

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

Strange part is that I can create a UDL file, and that will work just fine,
but the ASP app won't work.

I can ping the server, use Query Analyzer to log onto the server using the
same credentials I supply in the ASP application, but for some reason, I'm
getting back that error. Does anyone have any thoughts?

Here's my connectionstring:

Application("ConnectionString") = "user id=sa;password=funtest;data
source=funwebtest;initial catalog=FSIntranet2;"

Thanks for any help,
Stephajn

Relevant Pages

  • Re: Question with
    ... server at least...). ... you want to process a file using ASP you will have to have the user upload ... I am trying to develop an ASP app to take some information from a CSV ... MsgBox("The path did not contain a CSV File. ...
    (microsoft.public.scripting.vbscript)
  • Re: Windows 2003 Problem? IIS Problem ?
    ... As a person who ran a blog engine on an underpowered server with a leaky app we moved it to it's own server and not a shared system and we're now cycling the app pool every 90 minutes. ... server included, and i install crystal report version 10, and crystal enterprise version 10 for the reports purpose. ... to run an ASP based ERP, and 40 users using this ASP based ERP ...
    (microsoft.public.windows.server.sbs)
  • Problem with App path
    ... I have a simple asp app on a W2K server and am having trouble creating the ... The problem is the asp code still sees the application root as wwroot ...
    (microsoft.public.inetserver.iis)
  • Re: ASP server performance
    ... on different platforms. ... Let's say I have an app that serves about 40page/sec with a load ... I have some old test and would like to know before I buy new server what the ... doesn't that depend on what the ASP page does? ...
    (microsoft.public.inetserver.asp.general)
  • Re: ASP page will not load
    ... >>> using ASP. ... Why do I get a 500 Internal Server error for all ... >>Internet Services Manager. ... >>Properties, and on the Home Directory tab, click the ...
    (microsoft.public.inetserver.asp.general)
Quantcast