My machine, Madison, has IIS and .NET development environment.  I have a HR
[our domain]\IUSR_InternetMadison account that has anonymous access rights 
assigned on my machine's IIS Server's default web site (I have a virtual 
directory in there that maps to my application).  After all that, I made 
sure that this account (through a group membership) has execute permission 
to the particular test procedure in my sql Server (which is a member 
server in my domain...My machine is a client pc on the same domain.

I get the following error when I view the form in the browser (IE 6.0):
Login failed for user '(null)'. Reason: Not associated with a trusted SQL 
Server connection. 
=========================================================================
Description: An unhandled exception occurred during the execution of the 
current web request. Please review the stack trace for more information 
about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Login failed for 
user '(null)'. Reason: Not associated with a trusted SQL Server connection.

 =========================================================================

The connection string is defined as:

'Constants
    Public Const cnnString As String = _
    "Integrated Security=SSPI;Initial Catalog=SEMS3;Data 
Source=ROMONA\HUNTER"


I was wondering if you could shed some light on this?  What am I doing 
wrong?  

Thanks in advance.


Disha Kibria
Programmer Analyst, Human Resources
University of California, Riverside 1160 University Ave, Riverside, CA 
92521
Voice:909.787.3328  Fax:909.787.3089
disha.kibria@u...  http://humanresources.ucr.edu

I hate to ask the obvious, but are you passing in the User and password 
params?


> My machine, Madison, has IIS and .NET development environment.  I have a 
HR
[> our domain]\IUSR_InternetMadison account that has anonymous access 
rights 
a> ssigned on my machine's IIS Server's default web site (I have a virtual 
d> irectory in there that maps to my application).  After all that, I made 
s> ure that this account (through a group membership) has execute 
permission 
t> o the particular test procedure in my sql Server (which is a member 
s> erver in my domain...My machine is a client pc on the same domain.

> I get the following error when I view the form in the browser (IE 6.0):
L> ogin failed for user '(null)'. Reason: Not associated with a trusted 
SQL 
S> erver connection. 
=> ========================================================================
D> escription: An unhandled exception occurred during the execution of the 
c> urrent web request. Please review the stack trace for more information 
a> bout the error and where it originated in the code. 

> Exception Details: System.Data.SqlClient.SqlException: Login failed for 
u> ser '(null)'. Reason: Not associated with a trusted SQL Server 
connection.

>  
=========================================================================

> The connection string is defined as:

> 'Constants
 >    Public Const cnnString As String = _
 >    "Integrated Security=SSPI;Initial Catalog=SEMS3;Data 
S> ource=ROMONA\HUNTER"

> 
I>  was wondering if you could shed some light on this?  What am I doing 
w> rong?  

> Thanks in advance.

> 
D> isha Kibria
P> rogrammer Analyst, Human Resources
U> niversity of California, Riverside 1160 University Ave, Riverside, CA 
9> 2521
V> oice:909.787.3328  Fax:909.787.3089
d> isha.kibria@u...  http://humanresources.ucr.edu

Greg,

I got it to work.  Thanks to someone from Microsoft!!  I added the 
<identity impersonate="tru"> and it worked!!

Thank you,
Disha 


I hate to ask the obvious, but are you passing in the User and password 
p> arams?

> 
>>  My machine, Madison, has IIS and .NET development environment.  I have 
a 
H> R
[> > our domain]\IUSR_InternetMadison account that has anonymous access 
r> ights 
a> > ssigned on my machine's IIS Server's default web site (I have a 
virtual 
d> > irectory in there that maps to my application).  After all that, I 
made 
s> > ure that this account (through a group membership) has execute 
p> ermission 
t> > o the particular test procedure in my sql Server (which is a member 
s> > erver in my domain...My machine is a client pc on the same domain.

> > I get the following error when I view the form in the browser (IE 6.0):
L> > ogin failed for user '(null)'. Reason: Not associated with a trusted 
S> QL 
S> > erver connection. 
=> > 
========================================================================
D> > escription: An unhandled exception occurred during the execution of 
the 
c> > urrent web request. Please review the stack trace for more 
information 
a> > bout the error and where it originated in the code. 

> > Exception Details: System.Data.SqlClient.SqlException: Login failed 
for 
u> > ser '(null)'. Reason: Not associated with a trusted SQL Server 
c> onnection.

> >  
=> ========================================================================

> > The connection string is defined as:

> > 'Constants
 > >    Public Const cnnString As String = _
 > >    "Integrated Security=SSPI;Initial Catalog=SEMS3;Data 
S> > ource=ROMONA\HUNTER"

> > 
I> >  was wondering if you could shed some light on this?  What am I doing 
w> > rong?  

> > Thanks in advance.

> > 
D> > isha Kibria
P> > rogrammer Analyst, Human Resources
U> > niversity of California, Riverside 1160 University Ave, Riverside, CA 
9> > 2521
V> > oice:909.787.3328  Fax:909.787.3089
d> > isha.kibria@u...  http://humanresources.ucr.edu