ASPNET SQL Server Log In

[kerry]

Hi all, I need some help with my first steps using Infopath.

1.XP Sql server 2000/MSDE
2.Using Visual Studio to create an Infopath Project
2.Using VB module(from samples) that logs on with code to log in to the
Small Business database.

Situation
Log in code works with VB.NEt web app
Copy module into Infopath project and log in fails with the user does
not have permission"
The code fails at the SQL log in, the form is fully trusted and the
code is able to create instances of the Small Business APP, so I dont
think its a trust problem.

When I look at the SQL trace;-

For the (sucessful) web app the NTusername = ASPNET and log in is
PcName\ASPNET

For the Infopath app the NTusername = pcusername and log in is
PcName\pcusername

Both use -.net sql data provider as the- 'application', of course the
user has permission for the database as admin

Help would be very welcome !!

Kerry

 

[kerry]

Still cannot find a solution, I have used a "log on " vb.net dll in a
..net web page and it works. In Infopath I get the "user does not have
permission" so obviously its IP related. The SQL trace shows that part
of the first stored procedure is running...
What can I do ??