Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Security > ASP.NET IMPERSONATION AND ORACLE 8.1.7

Reply
Thread Tools

ASP.NET IMPERSONATION AND ORACLE 8.1.7

 
 
saleryan
Guest
Posts: n/a
 
      12-28-2005
i'm trying to connect to oracle 8.1.7 in asp.net using windows integrated
security
but i'm always getting a ora 01017 invalid username/password. logon denied
message. my web application is running on iis on windows xp professional.
this is my connection string
This is my connection string: data Source=bankiby;integrated security=yes"

The strange this is that it WORKS if I explicitly set
<identity impersonate="true" userName="IISGroup\userName"
password="password" /> in the web.config file. but it doesn' t work when I
just set impersonate=true.. I want it to work by just setting
impersonate=true.


ANY SUGGESTIONS?



 
Reply With Quote
 
 
 
 
Paul Clement
Guest
Posts: n/a
 
      12-28-2005
On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <> wrote:

¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows integrated
¤ security
¤ but i'm always getting a ora 01017 invalid username/password. logon denied
¤ message. my web application is running on iis on windows xp professional.
¤ this is my connection string
¤ This is my connection string: data Source=bankiby;integrated security=yes"
¤
¤ The strange this is that it WORKS if I explicitly set
¤ <identity impersonate="true" userName="IISGroup\userName"
¤ password="password" /> in the web.config file. but it doesn' t work when I
¤ just set impersonate=true.. I want it to work by just setting
¤ impersonate=true.
¤

Assuming Oracle is installed on a machine other than your web server you will need to enable
Kerberos to support the delegation of credentials to the Oracle database server.

http://support.microsoft.com/default...b;en-us;810572


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Reply With Quote
 
 
 
 
saleryan
Guest
Posts: n/a
 
      12-29-2005
How about if Oracle is installed on the same machine as the web server?

"Paul Clement" <> wrote in message
news:...
> On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <> wrote:
>
> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows
> integrated
> ¤ security
> ¤ but i'm always getting a ora 01017 invalid username/password. logon
> denied
> ¤ message. my web application is running on iis on windows xp
> professional.
> ¤ this is my connection string
> ¤ This is my connection string: data Source=bankiby;integrated
> security=yes"
> ¤
> ¤ The strange this is that it WORKS if I explicitly set
> ¤ <identity impersonate="true" userName="IISGroup\userName"
> ¤ password="password" /> in the web.config file. but it doesn' t work when
> I
> ¤ just set impersonate=true.. I want it to work by just setting
> ¤ impersonate=true.
> ¤
>
> Assuming Oracle is installed on a machine other than your web server you
> will need to enable
> Kerberos to support the delegation of credentials to the Oracle database
> server.
>
> http://support.microsoft.com/default...b;en-us;810572
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)



 
Reply With Quote
 
Dominick Baier [DevelopMentor]
Guest
Posts: n/a
 
      12-29-2005
Hi,

then there are no special steps necessary to enable your scenario - besides
installing oracle
---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

> How about if Oracle is installed on the same machine as the web
> server?
>
> "Paul Clement" <> wrote in
> message news:...
>
>> On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <>
>> wrote:
>>
>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows
>> integrated
>> ¤ security
>> ¤ but i'm always getting a ora 01017 invalid username/password. logon
>> denied
>> ¤ message. my web application is running on iis on windows xp
>> professional.
>> ¤ this is my connection string
>> ¤ This is my connection string: data Source=bankiby;integrated
>> security=yes"
>> ¤
>> ¤ The strange this is that it WORKS if I explicitly set
>> ¤ <identity impersonate="true" userName="IISGroup\userName"
>> ¤ password="password" /> in the web.config file. but it doesn' t work
>> when
>> I
>> ¤ just set impersonate=true.. I want it to work by just setting
>> ¤ impersonate=true.
>> ¤
>> Assuming Oracle is installed on a machine other than your web server
>> you
>> will need to enable
>> Kerberos to support the delegation of credentials to the Oracle
>> database
>> server.
>> http://support.microsoft.com/default...b;en-us;810572
>>
>> Paul
>> ~~~~
>> Microsoft MVP (Visual Basic)



 
Reply With Quote
 
saleryan
Guest
Posts: n/a
 
      12-30-2005
Hi..

But I have oracle installed on the same machine as the web server and I'm
getting the same error "Logon denied" it only works if i set <identity
impersonate="true" userName="IISGroup\userName" password="password" /> in
the web.config file. but it doesn' t work
when I just set impersonate=true.. Do I still need to enable kerberos ? If
not What could be the problem?

Thanks



"Dominick Baier [DevelopMentor]" <>
wrote in message news:. com...
> Hi,
> then there are no special steps necessary to enable your scenario -
> besides installing oracle
> ---------------------------------------
> Dominick Baier - DevelopMentor
> http://www.leastprivilege.com
>
>> How about if Oracle is installed on the same machine as the web
>> server?
>>
>> "Paul Clement" <> wrote in
>> message news:...
>>
>>> On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <>
>>> wrote:
>>>
>>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows
>>> integrated
>>> ¤ security
>>> ¤ but i'm always getting a ora 01017 invalid username/password. logon
>>> denied
>>> ¤ message. my web application is running on iis on windows xp
>>> professional.
>>> ¤ this is my connection string
>>> ¤ This is my connection string: data Source=bankiby;integrated
>>> security=yes"
>>> ¤
>>> ¤ The strange this is that it WORKS if I explicitly set
>>> ¤ <identity impersonate="true" userName="IISGroup\userName"
>>> ¤ password="password" /> in the web.config file. but it doesn' t work
>>> when
>>> I
>>> ¤ just set impersonate=true.. I want it to work by just setting
>>> ¤ impersonate=true.
>>> ¤
>>> Assuming Oracle is installed on a machine other than your web server
>>> you
>>> will need to enable
>>> Kerberos to support the delegation of credentials to the Oracle
>>> database
>>> server.
>>> http://support.microsoft.com/default...b;en-us;810572
>>>
>>> Paul
>>> ~~~~
>>> Microsoft MVP (Visual Basic)

>
>



 
Reply With Quote
 
Dominick Baier [DevelopMentor]
Guest
Posts: n/a
 
      12-30-2005
Hi,

can you check the oracle logs to see who exactly tries to logon?

---------------------------------------
Dominick Baier - DevelopMentor
http://www.leastprivilege.com

> Hi..
>
> But I have oracle installed on the same machine as the web server and
> I'm
> getting the same error "Logon denied" it only works if i set <identity
> impersonate="true" userName="IISGroup\userName" password="password"
> /> in
> the web.config file. but it doesn' t work
> when I just set impersonate=true.. Do I still need to enable kerberos
> ? If
> not What could be the problem?
> Thanks
>
> "Dominick Baier [DevelopMentor]"
> <> wrote in message
> news:. com...
>
>> Hi,
>> then there are no special steps necessary to enable your scenario -
>> besides installing oracle
>> ---------------------------------------
>> Dominick Baier - DevelopMentor
>> http://www.leastprivilege.com
>>> How about if Oracle is installed on the same machine as the web
>>> server?
>>>
>>> "Paul Clement" <> wrote in
>>> message news:...
>>>
>>>> On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <>
>>>> wrote:
>>>>
>>>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows
>>>> integrated
>>>> ¤ security
>>>> ¤ but i'm always getting a ora 01017 invalid username/password.
>>>> logon
>>>> denied
>>>> ¤ message. my web application is running on iis on windows xp
>>>> professional.
>>>> ¤ this is my connection string
>>>> ¤ This is my connection string: data Source=bankiby;integrated
>>>> security=yes"
>>>> ¤
>>>> ¤ The strange this is that it WORKS if I explicitly set
>>>> ¤ <identity impersonate="true" userName="IISGroup\userName"
>>>> ¤ password="password" /> in the web.config file. but it doesn' t
>>>> work
>>>> when
>>>> I
>>>> ¤ just set impersonate=true.. I want it to work by just setting
>>>> ¤ impersonate=true.
>>>> ¤
>>>> Assuming Oracle is installed on a machine other than your web
>>>> server
>>>> you
>>>> will need to enable
>>>> Kerberos to support the delegation of credentials to the Oracle
>>>> database
>>>> server.
>>>> http://support.microsoft.com/default...b;en-us;810572
>>>> Paul
>>>> ~~~~
>>>> Microsoft MVP (Visual Basic



 
Reply With Quote
 
saleryan
Guest
Posts: n/a
 
      01-03-2006
Hi,

I looked at the oracle logs and I found that the username being passed to
oracle is "Username" instead of "Domain\Username" so somehow its not
passing
the domain name but just the username. How can I fix this problem?

Thanks


"Dominick Baier [DevelopMentor]" <>
wrote in message news:. com...
> Hi,
> can you check the oracle logs to see who exactly tries to logon?
>
> ---------------------------------------
> Dominick Baier - DevelopMentor
> http://www.leastprivilege.com
>
>> Hi..
>>
>> But I have oracle installed on the same machine as the web server and
>> I'm
>> getting the same error "Logon denied" it only works if i set <identity
>> impersonate="true" userName="IISGroup\userName" password="password"
>> /> in
>> the web.config file. but it doesn' t work
>> when I just set impersonate=true.. Do I still need to enable kerberos
>> ? If
>> not What could be the problem?
>> Thanks
>>
>> "Dominick Baier [DevelopMentor]"
>> <> wrote in message
>> news:. com...
>>
>>> Hi,
>>> then there are no special steps necessary to enable your scenario -
>>> besides installing oracle
>>> ---------------------------------------
>>> Dominick Baier - DevelopMentor
>>> http://www.leastprivilege.com
>>>> How about if Oracle is installed on the same machine as the web
>>>> server?
>>>>
>>>> "Paul Clement" <> wrote in
>>>> message news:...
>>>>
>>>>> On Wed, 28 Dec 2005 17:43:22 +0300, "saleryan" <>
>>>>> wrote:
>>>>>
>>>>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using windows
>>>>> integrated
>>>>> ¤ security
>>>>> ¤ but i'm always getting a ora 01017 invalid username/password.
>>>>> logon
>>>>> denied
>>>>> ¤ message. my web application is running on iis on windows xp
>>>>> professional.
>>>>> ¤ this is my connection string
>>>>> ¤ This is my connection string: data Source=bankiby;integrated
>>>>> security=yes"
>>>>> ¤
>>>>> ¤ The strange this is that it WORKS if I explicitly set
>>>>> ¤ <identity impersonate="true" userName="IISGroup\userName"
>>>>> ¤ password="password" /> in the web.config file. but it doesn' t
>>>>> work
>>>>> when
>>>>> I
>>>>> ¤ just set impersonate=true.. I want it to work by just setting
>>>>> ¤ impersonate=true.
>>>>> ¤
>>>>> Assuming Oracle is installed on a machine other than your web
>>>>> server
>>>>> you
>>>>> will need to enable
>>>>> Kerberos to support the delegation of credentials to the Oracle
>>>>> database
>>>>> server.
>>>>> http://support.microsoft.com/default...b;en-us;810572
>>>>> Paul
>>>>> ~~~~
>>>>> Microsoft MVP (Visual Basic)

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cloakware and Oracle Work to Integrate Cloakware Password Authoritywith Oracle Identity and Access Management bilawal samoon Python 0 08-23-2009 01:57 PM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
ASP.NET Impersonation to access Oracle database... Top Poster ASP .Net 1 07-06-2005 03:34 PM
Common pro*c code for both Oracle and non-Oracle environments Golan C Programming 1 04-05-2005 06:34 PM
Oracle adapter don't work with Oracle 10.1.0.2 v. Client vaidas gudas ASP .Net 1 10-11-2004 01:11 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57