Re: Locked out of my own SQL Server???
From: MSH (harlan@globalaspirations.com)
Date: 10/04/02
- Next message: yap: "Restrict Access to web sites from certain IP addresses"
- Previous message: MSH: "SSL and Images"
- In reply to: Stephajn Craig: "Re: Locked out of my own SQL Server???"
- Next in thread: Atrax _: "Re: Locked out of my own SQL Server???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "MSH" <harlan@globalaspirations.com> Date: Thu, 3 Oct 2002 17:37:22 -0700
The connection string needs to specify the driver to use.
Try this instead...
Application("ConnectionString") = "Provider=SQLOLEDB;user
id=sa;password=funtest;data source=funwebtest;initial
catalog=FSIntranet2;"
>-----Original Message-----
>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
>>
>>
>
>
>.
>
- Next message: yap: "Restrict Access to web sites from certain IP addresses"
- Previous message: MSH: "SSL and Images"
- In reply to: Stephajn Craig: "Re: Locked out of my own SQL Server???"
- Next in thread: Atrax _: "Re: Locked out of my own SQL Server???"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
