ADODB.Connection error '800a0046'

[Michael Ralph]

I am receiving the following error:

ADODB.Connection error '800a0046'
Permission Denied

Here is my connection string on my web page:
<%
Dim SurveyConnection

Set SurveyConnection=Server.CreateObject
("ADODB.Connection")
SurveyConnection.Open "Driver={SQL
Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"

%>

The funny thing is it works on one IIS but not the one I
need it on. Any suggestions?

[Bob Barrows]

Responses inline:

>-----Original Message-----
>I am receiving the following error:
>
>ADODB.Connection error '800a0046'
>Permission Denied
>
>Here is my connection string on my web page:
><%
>Dim SurveyConnection
>
>Set SurveyConnection=Server.CreateObject
>("ADODB.Connection")
>SurveyConnection.Open "Driver={SQL
>Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlS urvey"

Firstly:
It may not be the cause of this problem, but you will be
better off using the native OLEDB provider For SQL Server
(SQLOLEDB) rather than the ODBC driver you are using. See
[url]www.connectionstrings.com[/url].

Secondly, it's a bad idea not to assign a password to the
sa account. Hopefully you do have a password for sa and
you've simply removed it from your connection string so as
not to expose it on the web ...

>
>%>
>
>The funny thing is it works on one IIS but not the one I
>need it on. Any suggestions?
>.
>

This is strange. This does not seem to be a SQL Server
login issue given that the error source is given as the
Connection object. Which line causes the error? The
CreateObject line or the Open line?

Bob Barrows

[Michael Ralph]

I did not want to post the sa password. I changed the
connection string (thanks for the suggestion), but still
get the error. The error is on the .open line.

>-----Original Message-----
>Responses inline:

>>-----Original Message-----
>>I am receiving the following error:
>>
>>ADODB.Connection error '800a0046'
>>Permission Denied
>>
>>Here is my connection string on my web page:
>><%
>>Dim SurveyConnection
>>
>>Set SurveyConnection=Server.CreateObject
>>("ADODB.Connection")
>>SurveyConnection.Open "Driver={SQL
>>Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7Lvl Survey"

>
>Firstly:
>It may not be the cause of this problem, but you will be
>better off using the native OLEDB provider For SQL Server
>(SQLOLEDB) rather than the ODBC driver you are using. See
>[url]www.connectionstrings.com[/url].
>
>Secondly, it's a bad idea not to assign a password to the
>sa account. Hopefully you do have a password for sa and
>you've simply removed it from your connection string so

as

>not to expose it on the web ...
>

>>
>>%>
>>
>>The funny thing is it works on one IIS but not the one I
>>need it on. Any suggestions?
>>.
>>

>This is strange. This does not seem to be a SQL Server
>login issue given that the error source is given as the
>Connection object. Which line causes the error? The
>CreateObject line or the Open line?
>
>Bob Barrows
>.
>

[Bob Barrows]

Michael Ralph wrote:

> I did not want to post the sa password. I changed the
> connection string (thanks for the suggestion), but still
> get the error. The error is on the .open line.
>

>> -----Original Message-----
>> Responses inline:

>>> -----Original Message-----
>>> I am receiving the following error:
>>>
>>> ADODB.Connection error '800a0046'
>>> Permission Denied
>>>
>>> Here is my connection string on my web page:
>>> <%
>>> Dim SurveyConnection
>>>
>>> Set SurveyConnection=Server.CreateObject
>>> ("ADODB.Connection")
>>> SurveyConnection.Open "Driver={SQL
>>> Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"

>>

Frankly, I'm at a loss. If you were using Integrated Security, I would have
an answer. But with SQL Security, this connection string should work (show
us your revised connection string.). I really don't think this is a security
issue with SQL itself. If it was, you would be getting a "login rejected"
message coming from the SQL provider. This is more of a file permission
issue ...

Can you create a udl file on the non-working server that connects to this
database? Just create a text file and give it a .udl extension and save it.
When you double-click it, you should be given a chance to create a
connection. Just enter the requested information and test the connection
when you are finished.

I wonder if it's a network library issue: you may be connecting via named
pipes on the machine that fails. Try forcing a tcp/ip connection by adding
"Network Library = dbmssocn" to your connection string.

Bob Barrows

[Atrax]

let me take a stab in the dark.

the SQL Server isn't actually set up for SQL Server auth - it's using
Windows auth, therefore ignoring the info in your connection string and
using the Windows IUSR account of the machine in question? or whichever
account IIS is using...

maybe?


________________________________________
Atrax. MVP, IIS
[url]http://rtfm.atrax.co.uk/[/url]

newsflash : Atrax.Richedit 1.0 now released.
[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.RichEdit/[/url]

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Michael Ralph]

Here is my new connection string:
<%
Dim SurveyConnection

Set SurveyConnection=Server.CreateObject
("ADODB.Connection")
SurveyConnection.Open "Provider=sqloledb;Data
Source=KAFB43B;Network Library=dbmssocn; Initial
Catalog=7LvlSurvey;User Id=sa;Password=;"

%>

Adding the Network Library had no effect. I crreated the
UDL on the server but I do not have direct access to the
machine. I ran the UDL on my machine with no problems.
It seems other machines do not have a problem connecting
to the database just the IIS which happens to be on the
same machine as the SQL server.

Interesting side note. I tried to connect to an Access
database just to test and had the same result. Is there
something that could be set on a server preventing all
connections to databases?

>-----Original Message-----
>Michael Ralph wrote:

>> I did not want to post the sa password. I changed the
>> connection string (thanks for the suggestion), but still
>> get the error. The error is on the .open line.
>>

>>> -----Original Message-----
>>> Responses inline:
>>>> -----Original Message-----
>>>> I am receiving the following error:
>>>>
>>>> ADODB.Connection error '800a0046'
>>>> Permission Denied
>>>>
>>>> Here is my connection string on my web page:
>>>> <%
>>>> Dim SurveyConnection
>>>>
>>>> Set SurveyConnection=Server.CreateObject
>>>> ("ADODB.Connection")
>>>> SurveyConnection.Open "Driver={SQL
>>>>

Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"

>>>

>Frankly, I'm at a loss. If you were using Integrated

Security, I would have

>an answer. But with SQL Security, this connection string

should work (show

>us your revised connection string.). I really don't think

this is a security

>issue with SQL itself. If it was, you would be getting

a "login rejected"

>message coming from the SQL provider. This is more of a

file permission

>issue ...
>
>Can you create a udl file on the non-working server that

connects to this

>database? Just create a text file and give it a .udl

extension and save it.

>When you double-click it, you should be given a chance to

create a

>connection. Just enter the requested information and test

the connection

>when you are finished.
>
>I wonder if it's a network library issue: you may be

connecting via named

>pipes on the machine that fails. Try forcing a tcp/ip

connection by adding

>"Network Library = dbmssocn" to your connection string.
>
>Bob Barrows
>
>
>
>.
>

[Michael Ralph]

If that was the case then I shouldn't be able to connect
to it using the same connection string on another IIS
right? Addtionally, I am using the sa account to connect
via Enterprise Manager.

>-----Original Message-----
>let me take a stab in the dark.
>
>the SQL Server isn't actually set up for SQL Server auth -

it's using

>Windows auth, therefore ignoring the info in your

connection string and

>using the Windows IUSR account of the machine in

question? or whichever

>account IIS is using...
>
>maybe?
>
>
>________________________________________
>Atrax. MVP, IIS
>[url]http://rtfm.atrax.co.uk/[/url]
>
>newsflash : Atrax.Richedit 1.0 now released.
>[url]http://rtfm.atrax.co.uk/infinitemonkeys/components/Atrax.R[/url]

ichEdit/

>
>*** Sent via Developersdex [url]http://www.developersdex.com[/url]

***

>Don't just participate in USENET...get rewarded for it!
>.
>

[Bob Barrows]

Michael Ralph wrote:

> Here is my new connection string:
> <%
> Dim SurveyConnection
>
> Set SurveyConnection=Server.CreateObject
> ("ADODB.Connection")
> SurveyConnection.Open "Provider=sqloledb;Data
> Source=KAFB43B;Network Library=dbmssocn; Initial
> Catalog=7LvlSurvey;User Id=sa;Password=;"
>
> %>
>
> Adding the Network Library had no effect. I crreated the
> UDL on the server but I do not have direct access to the
> machine.

You have no hope of troubleshooting this problem without it.

>I ran the UDL on my machine with no problems.
> It seems other machines do not have a problem connecting
> to the database just the IIS which happens to be on the
> same machine as the SQL server.

Curiouser and curiouser. Hmm, on the same server ... Try "Data
Source=(local)"

>
> Interesting side note. I tried to connect to an Access
> database

Was the Access database on the same box as IIS? Was it in the website from
which you were attempting to access it? Did you grant Change permissions for
the folder containing the database to the IUSR_machinename account?

>just to test and had the same result. Is there
> something that could be set on a server preventing all
> connections to databases?
>

No. That's what's so perplexing. You could have a defective ADO installation
on the server. Maybe have the administrator reinstall MDAC, or better,
install a newer version of MDAC.

Bob Barrows

[Bob Barrows]

Michael Ralph wrote:

> I am receiving the following error:
>
> ADODB.Connection error '800a0046'
> Permission Denied
>
> Here is my connection string on my web page:
> <%
> Dim SurveyConnection
>
> Set SurveyConnection=Server.CreateObject
> ("ADODB.Connection")
> SurveyConnection.Open "Driver={SQL
> Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"
>
> %>
>
> The funny thing is it works on one IIS but not the one I
> need it on. Any suggestions?

You may want to see if this KB article helps:
support.microsoft.com/?kbid=189408

[Michael Ralph]

Access database on the same web with IUSR write, read,
modify, execute... I tried changing the Data Source to
local in my connection string (back to the SQL server
database), no change. I have asked the network
administrator to run the Microsoft Component Checker
Utililty for MDAC and to make sure that password
synchronization is disabled. Will post back with
results. Thanks.

>-----Original Message-----
>Michael Ralph wrote:

>> Here is my new connection string:
>> <%
>> Dim SurveyConnection
>>
>> Set SurveyConnection=Server.CreateObject
>> ("ADODB.Connection")
>> SurveyConnection.Open "Provider=sqloledb;Data
>> Source=KAFB43B;Network Library=dbmssocn; Initial
>> Catalog=7LvlSurvey;User Id=sa;Password=;"
>>
>> %>
>>
>> Adding the Network Library had no effect. I crreated

the

>> UDL on the server but I do not have direct access to the
>> machine.

>
>You have no hope of troubleshooting this problem without

it.

>

>>I ran the UDL on my machine with no problems.
>> It seems other machines do not have a problem connecting
>> to the database just the IIS which happens to be on the
>> same machine as the SQL server.

>
>Curiouser and curiouser. Hmm, on the same server ...

Try "Data

>Source=(local)"
>

>>
>> Interesting side note. I tried to connect to an Access
>> database

>
>Was the Access database on the same box as IIS? Was it in

the website from

>which you were attempting to access it? Did you grant

Change permissions for

>the folder containing the database to the

IUSR_machinename account?

>

>>just to test and had the same result. Is there
>> something that could be set on a server preventing all
>> connections to databases?
>>

>No. That's what's so perplexing. You could have a

defective ADO installation

>on the server. Maybe have the administrator reinstall

MDAC, or better,

>install a newer version of MDAC.
>
>Bob Barrows
>
>
>.
>

[Michael Ralph]

By the way the server it works on has a security
certificate [url]https://.[/url].. and the one it doesn't work on
does not [url]http://.[/url].. Would this have any affect?

>-----Original Message-----
>Michael Ralph wrote:

>> I am receiving the following error:
>>
>> ADODB.Connection error '800a0046'
>> Permission Denied
>>
>> Here is my connection string on my web page:
>> <%
>> Dim SurveyConnection
>>
>> Set SurveyConnection=Server.CreateObject
>> ("ADODB.Connection")
>> SurveyConnection.Open "Driver={SQL
>> Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"
>>
>> %>
>>
>> The funny thing is it works on one IIS but not the one I
>> need it on. Any suggestions?

>
>You may want to see if this KB article helps:
>support.microsoft.com/?kbid=189408
>
>
>.
>

[Bob Barrows]

Michael Ralph wrote:

> By the way the server it works on has a security
> certificate [url]https://.[/url].. and the one it doesn't work on
> does not [url]http://.[/url].. Would this have any affect?

Perhaps. I've only dealt with intranet apps so I haven't had a need to look
into SSL. Hopefully somebody else can jump in here.

Have you tried searching the MS KB?

Bob Barrows

[Ray at]

I'll grasp at a straw here.

If it works fine on one server, but not another, is there an IPSec policy on
the SQL server only allowing communication through port 1433 from the other
server's IP?

Ray at work

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:O24YKe2hDHA.2212@TK2MSFTNGP09.phx.gbl...

> Michael Ralph wrote:

> > By the way the server it works on has a security
> > certificate [url]https://.[/url].. and the one it doesn't work on
> > does not [url]http://.[/url].. Would this have any affect?

>
> Perhaps. I've only dealt with intranet apps so I haven't had a need to

look

> into SSL. Hopefully somebody else can jump in here.
>
> Have you tried searching the MS KB?
>
> Bob Barrows
>
>

[Mark Schupp]

Sounds like an NTFS permission problem on the web server. Is the error
occurring on the Server.CreateObject call or the Open call?

Try changing the anonymous user account for the web site to the local
Administrator account (may need to restart web services). Does that correct
the problem? If so, your anon account is missing access rights to something
it needs. You should be able to track it down by enabling file auditing and
looking for access failures.

About the SA account. You should never use that account for production
applications. It has far too many privileges. Create a SQLServer login for
the application and give it only the access rights and privileges required
by the application.

--
Mark Schupp
Head of Development
Integrity eLearning
[url]www.ielearning.com[/url]


"Michael Ralph" <ralph@141.com> wrote in message
news:1b4401c3874c$79d8a010$a101280a@phx.gbl...

> Here is my new connection string:
> <%
> Dim SurveyConnection
>
> Set SurveyConnection=Server.CreateObject
> ("ADODB.Connection")
> SurveyConnection.Open "Provider=sqloledb;Data
> Source=KAFB43B;Network Library=dbmssocn; Initial
> Catalog=7LvlSurvey;User Id=sa;Password=;"
>
> %>
>
> Adding the Network Library had no effect. I crreated the
> UDL on the server but I do not have direct access to the
> machine. I ran the UDL on my machine with no problems.
> It seems other machines do not have a problem connecting
> to the database just the IIS which happens to be on the
> same machine as the SQL server.
>
> Interesting side note. I tried to connect to an Access
> database just to test and had the same result. Is there
> something that could be set on a server preventing all
> connections to databases?
>

> >-----Original Message-----
> >Michael Ralph wrote:

> >> I did not want to post the sa password. I changed the
> >> connection string (thanks for the suggestion), but still
> >> get the error. The error is on the .open line.
> >>
> >>> -----Original Message-----
> >>> Responses inline:
> >>>> -----Original Message-----
> >>>> I am receiving the following error:
> >>>>
> >>>> ADODB.Connection error '800a0046'
> >>>> Permission Denied
> >>>>
> >>>> Here is my connection string on my web page:
> >>>> <%
> >>>> Dim SurveyConnection
> >>>>
> >>>> Set SurveyConnection=Server.CreateObject
> >>>> ("ADODB.Connection")
> >>>> SurveyConnection.Open "Driver={SQL
> >>>>

> Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"

> >>>

> >Frankly, I'm at a loss. If you were using Integrated

> Security, I would have

> >an answer. But with SQL Security, this connection string

> should work (show

> >us your revised connection string.). I really don't think

> this is a security

> >issue with SQL itself. If it was, you would be getting

> a "login rejected"

> >message coming from the SQL provider. This is more of a

> file permission

> >issue ...
> >
> >Can you create a udl file on the non-working server that

> connects to this

> >database? Just create a text file and give it a .udl

> extension and save it.

> >When you double-click it, you should be given a chance to

> create a

> >connection. Just enter the requested information and test

> the connection

> >when you are finished.
> >
> >I wonder if it's a network library issue: you may be

> connecting via named

> >pipes on the machine that fails. Try forcing a tcp/ip

> connection by adding

> >"Network Library = dbmssocn" to your connection string.
> >
> >Bob Barrows
> >
> >
> >
> >.
> >

[Michael Ralph]

Turns out the IIS administrator had both Windows
Integrated Security and Anonymous Logins enabled.

>-----Original Message-----
>Sounds like an NTFS permission problem on the web server.

Is the error

>occurring on the Server.CreateObject call or the Open

call?

>
>Try changing the anonymous user account for the web site

to the local

>Administrator account (may need to restart web services).

Does that correct

>the problem? If so, your anon account is missing access

rights to something

>it needs. You should be able to track it down by enabling

file auditing and

>looking for access failures.
>
>About the SA account. You should never use that account

for production

>applications. It has far too many privileges. Create a

SQLServer login for

>the application and give it only the access rights and

privileges required

>by the application.
>
>--
>Mark Schupp
>Head of Development
>Integrity eLearning
>[url]www.ielearning.com[/url]
>
>
>"Michael Ralph" <ralph@141.com> wrote in message
>news:1b4401c3874c$79d8a010$a101280a@phx.gbl...

>> Here is my new connection string:
>> <%
>> Dim SurveyConnection
>>
>> Set SurveyConnection=Server.CreateObject
>> ("ADODB.Connection")
>> SurveyConnection.Open "Provider=sqloledb;Data
>> Source=KAFB43B;Network Library=dbmssocn; Initial
>> Catalog=7LvlSurvey;User Id=sa;Password=;"
>>
>> %>
>>
>> Adding the Network Library had no effect. I crreated

the

>> UDL on the server but I do not have direct access to the
>> machine. I ran the UDL on my machine with no problems.
>> It seems other machines do not have a problem connecting
>> to the database just the IIS which happens to be on the
>> same machine as the SQL server.
>>
>> Interesting side note. I tried to connect to an Access
>> database just to test and had the same result. Is there
>> something that could be set on a server preventing all
>> connections to databases?
>>

>> >-----Original Message-----
>> >Michael Ralph wrote:
>> >> I did not want to post the sa password. I changed

the

>> >> connection string (thanks for the suggestion), but

still

>> >> get the error. The error is on the .open line.
>> >>
>> >>> -----Original Message-----
>> >>> Responses inline:
>> >>>> -----Original Message-----
>> >>>> I am receiving the following error:
>> >>>>
>> >>>> ADODB.Connection error '800a0046'
>> >>>> Permission Denied
>> >>>>
>> >>>> Here is my connection string on my web page:
>> >>>> <%
>> >>>> Dim SurveyConnection
>> >>>>
>> >>>> Set SurveyConnection=Server.CreateObject
>> >>>> ("ADODB.Connection")
>> >>>> SurveyConnection.Open "Driver={SQL
>> >>>>

>> Server};SERVER=KAFB43b;UID=sa;PWD=;Database=7LvlSu rvey"

>> >>>
>> >Frankly, I'm at a loss. If you were using Integrated

>> Security, I would have

>> >an answer. But with SQL Security, this connection

string

>> should work (show

>> >us your revised connection string.). I really don't

think

>> this is a security

>> >issue with SQL itself. If it was, you would be getting

>> a "login rejected"

>> >message coming from the SQL provider. This is more of a

>> file permission

>> >issue ...
>> >
>> >Can you create a udl file on the non-working server

that

>> connects to this

>> >database? Just create a text file and give it a .udl

>> extension and save it.

>> >When you double-click it, you should be given a chance

to

>> create a

>> >connection. Just enter the requested information and

test

>> the connection

>> >when you are finished.
>> >
>> >I wonder if it's a network library issue: you may be

>> connecting via named

>> >pipes on the machine that fails. Try forcing a tcp/ip

>> connection by adding

>> >"Network Library = dbmssocn" to your connection string.
>> >
>> >Bob Barrows
>> >
>> >
>> >
>> >.
>> >

>
>
>.
>

[Michael Ralph]

Turns out the IIS administrator had both Windows
Integrated Security and Anonymous logins enabled.

>-----Original Message-----
>I'll grasp at a straw here.
>
>If it works fine on one server, but not another, is there

an IPSec policy on

>the SQL server only allowing communication through port

1433 from the other

>server's IP?
>
>Ray at work
>
>"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
>news:O24YKe2hDHA.2212@TK2MSFTNGP09.phx.gbl...

>> Michael Ralph wrote:

>> > By the way the server it works on has a security
>> > certificate [url]https://.[/url].. and the one it doesn't work on
>> > does not [url]http://.[/url].. Would this have any affect?

>>
>> Perhaps. I've only dealt with intranet apps so I

haven't had a need to

>look

>> into SSL. Hopefully somebody else can jump in here.
>>
>> Have you tried searching the MS KB?
>>
>> Bob Barrows
>>
>>

>
>
>.
>