hi..
i'm trying to connect to oracle 8.1.7 in asp.net using 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: data Source=bankiby;integrated security=yes"
i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
identified externally and i set the remote_os_authent=TRUE..

I am able to login through the server with no problems but when i try to
login through a client computer to my web application i get the message ora
01017.



Any suggestions?

On Sat, 17 Dec 2005 00:47:06 +0300, "saleryan" <(E-Mail Removed)> wrote:

¤ hi..
¤ i'm trying to connect to oracle 8.1.7 in asp.net using 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: data Source=bankiby;integrated security=yes"
¤ i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
¤ identified externally and i set the remote_os_authent=TRUE..
¤
¤ I am able to login through the server with no problems but when i try to
¤ login through a client computer to my web application i get the message ora
¤ 01017.
¤

Is Oracle installed on your web server or on a remote machine?


Paul
~~~~
Microsoft MVP (Visual Basic)

Oracle is installed on my web server. I'm using oracle administration
assistant for windows NT to define external OS users and I set the
impersonate tag in the web.config file to true. I also noticed that if I
change the impersonate tag in web.config file to False and I added the
aspNET user to oracle as an external user then it works fine. But that
doesn't work when I set the impersonate to true and define my own users.

Seems to me something wrong is happening while passing the username or
password from asp.net to oracle. I checked several times that the user
being passed to oracle is the same user that is defined as an external user
in oracle. I used the following code:
Dim user1 As WindowsPrincipal = HttpContext.Current.User
LblWelcome.Text = "Welcome " + user1.Identity.Name()
The user thats printed everytime is the same as the oracle user defined
externally..
I'm using windows xp professional on both my webserver and client do you
think that could be the problem? That maybe I should use windows NT on my
webserver? If anyone has experience using windows integrated security with
oracle 8.1.7. Please help me here.. Microsoft recommends it but I don't see
any help files explaining the exact configurations on oracle and asp.net..

Thanks




"Paul Clement" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Sat, 17 Dec 2005 00:47:06 +0300, "saleryan" <(E-Mail Removed)> wrote:
>
> ¤ hi..
> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using 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: data Source=bankiby;integrated
> security=yes"
> ¤ i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
> ¤ identified externally and i set the remote_os_authent=TRUE..
> ¤
> ¤ I am able to login through the server with no problems but when i try
> to
> ¤ login through a client computer to my web application i get the message
> ora
> ¤ 01017.
> ¤
>
> Is Oracle installed on your web server or on a remote machine?
>
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)

I would like to add 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 if i
just justa set impersonate=true..


Any suggestions!!




"saleryan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Oracle is installed on my web server. I'm using oracle administration
> assistant for windows NT to define external OS users and I set the
> impersonate tag in the web.config file to true. I also noticed that if I
> change the impersonate tag in web.config file to False and I added the
> aspNET user to oracle as an external user then it works fine. But that
> doesn't work when I set the impersonate to true and define my own users.
>
> Seems to me something wrong is happening while passing the username or
> password from asp.net to oracle. I checked several times that the user
> being passed to oracle is the same user that is defined as an external
> user in oracle. I used the following code:
> Dim user1 As WindowsPrincipal = HttpContext.Current.User
> LblWelcome.Text = "Welcome " + user1.Identity.Name()
> The user thats printed everytime is the same as the oracle user defined
> externally..
> I'm using windows xp professional on both my webserver and client do you
> think that could be the problem? That maybe I should use windows NT on my
> webserver? If anyone has experience using windows integrated security
> with oracle 8.1.7. Please help me here.. Microsoft recommends it but I
> don't see any help files explaining the exact configurations on oracle and
> asp.net..
>
> Thanks
>
>
>
>
> "Paul Clement" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On Sat, 17 Dec 2005 00:47:06 +0300, "saleryan" <(E-Mail Removed)>
>> wrote:
>>
>> ¤ hi..
>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using 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: data Source=bankiby;integrated
>> security=yes"
>> ¤ i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
>> ¤ identified externally and i set the remote_os_authent=TRUE..
>> ¤
>> ¤ I am able to login through the server with no problems but when i try
>> to
>> ¤ login through a client computer to my web application i get the message
>> ora
>> ¤ 01017.
>> ¤
>>
>> Is Oracle installed on your web server or on a remote machine?
>>
>>
>> Paul
>> ~~~~
>> Microsoft MVP (Visual Basic)
>
>

I would like to add 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 if i
just justa set impersonate=true..


Any suggestions!!




"saleryan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Oracle is installed on my web server. I'm using oracle administration
> assistant for windows NT to define external OS users and I set the
> impersonate tag in the web.config file to true. I also noticed that if I
> change the impersonate tag in web.config file to False and I added the
> aspNET user to oracle as an external user then it works fine. But that
> doesn't work when I set the impersonate to true and define my own users.
>
> Seems to me something wrong is happening while passing the username or
> password from asp.net to oracle. I checked several times that the user
> being passed to oracle is the same user that is defined as an external
> user in oracle. I used the following code:
> Dim user1 As WindowsPrincipal = HttpContext.Current.User
> LblWelcome.Text = "Welcome " + user1.Identity.Name()
> The user thats printed everytime is the same as the oracle user defined
> externally..
> I'm using windows xp professional on both my webserver and client do you
> think that could be the problem? That maybe I should use windows NT on my
> webserver? If anyone has experience using windows integrated security
> with oracle 8.1.7. Please help me here.. Microsoft recommends it but I
> don't see any help files explaining the exact configurations on oracle and
> asp.net..
>
> Thanks
>
>
>
>
> "Paul Clement" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On Sat, 17 Dec 2005 00:47:06 +0300, "saleryan" <(E-Mail Removed)>
>> wrote:
>>
>> ¤ hi..
>> ¤ i'm trying to connect to oracle 8.1.7 in asp.net using 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: data Source=bankiby;integrated
>> security=yes"
>> ¤ i set SQLNET.AUTHENTICATION_SERVICES= (NTS,NONE) and added users to be
>> ¤ identified externally and i set the remote_os_authent=TRUE..
>> ¤
>> ¤ I am able to login through the server with no problems but when i try
>> to
>> ¤ login through a client computer to my web application i get the message
>> ora
>> ¤ 01017.
>> ¤
>>
>> Is Oracle installed on your web server or on a remote machine?
>>
>>
>> Paul
>> ~~~~
>> Microsoft MVP (Visual Basic)
>
>