Re: 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 11:13:47 -0600

Hi all,

as an update, what I did was I moved the asp application onto a different
server, and got this error messaage again, only to discover that the
application was running in the default application's context, and therefore
using its GLOBAL.ASA file. I fixed this by putting the application back
into its own application context, but now the problem I'm ahving is that
back on the original server, it's trying to get onto SQL using my domain
account rather than the one I specified in my GLOBAL.ASA file. I'm really
confused on this one, and don't know where to look to check this. I DO have
anonymous browsing enabled, and the SQL SErver's running in mixed mode.

Any thoughts anyone?

Stephajn
"Stephajn Craig" <s.craig@funsunvacations.com> wrote in message
news:#RvzE0vaCHA.1744@tkmsftngp11...
> 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: Adp to asp web page
    ... of drunk retards that dont understand web development ... when I went into the connection box, it listed my server but in the drop ... Access ADP is merely front end app and IDE for SQL Server, ... ASP is old technology and different from ASP.NET. ...
    (microsoft.public.access.adp.sqlserver)
  • Cluster questions
    ... I need to install a portal infrastructure that was developed with ASP ... and SQL Server. ... Virtual Server), like NLB. ... The developement of the ASP application is different that the ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to Set Datetime on SQL 2000 server
    ... the site on the new server still links to the same SQL ... The asp pages on this new server works fine with all date data. ... least pass language neutral datetime formats to SQL Server ... the desired format. ...
    (microsoft.public.sqlserver.setup)
  • Re: Locked out of my own SQL Server???
    ... >back on the original server, it's trying to get onto SQL ... within my ASP ... >> app to use an applicationwide Connectionstring Variable ... >> Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.inetserver.iis.security)
  • 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