P
Paul M
Hi,
I've just implemented my first application onto a test web server.
When the code comes to creating a connection object it throws an error
saying the "Login failed for user '(null)'. Reason : Not associated with a
trusted connection".
I'm using integrated security and it works from the IIS server I have set up
on my local machine. The connection string I'm using is
strCN = "data source='DIVCS-SQL2\SQL2K';Trusted_Connection=true;initial
catalog=HelpdeskDevelopment;User Id='" & objCurrentUser.Name & "'"
Where objCurrentUser is a WindowsIdentity object. This object is returning
the correct username.
I've done everything according to the book (ASP.NET unleashed) and I've
checked the knowledge base.
Thanks in advance....Paul
I've just implemented my first application onto a test web server.
When the code comes to creating a connection object it throws an error
saying the "Login failed for user '(null)'. Reason : Not associated with a
trusted connection".
I'm using integrated security and it works from the IIS server I have set up
on my local machine. The connection string I'm using is
strCN = "data source='DIVCS-SQL2\SQL2K';Trusted_Connection=true;initial
catalog=HelpdeskDevelopment;User Id='" & objCurrentUser.Name & "'"
Where objCurrentUser is a WindowsIdentity object. This object is returning
the correct username.
I've done everything according to the book (ASP.NET unleashed) and I've
checked the knowledge base.
Thanks in advance....Paul