Database Connectivity Problem in ASP.Net using ADO.Net Is it security issue

From: Dhiren (MDhiren@pun.cognizant.com)
Date: 02/14/03 

From: "Dhiren" <MDhiren@pun.cognizant.com>
Date: Fri, 14 Feb 2003 17:06:22 +0530

Hi All

I have existing website in ASP/SQL Sever 2000. My IIS is configured for
Basic Auth. My ISS Server and Database server are on different machine.
Both IIS And DB box has window group to which set of user are member
Let say,
IIs Box has Window Group A
                    Users are 1,2,3
Then DB box also has Window group A
                    Users are 1,2,3
My SQL Server Login has Windows GRoup A as login id

This scheme works for my current site where user is asked for user id and
passowrd if he/she enters 1/2/3 then person allowed to loging to the site
and can acceess the database.

Query:
I have posted ASP.Net web app page in the same site but the same scheme does
not work it gives me error like

System.Data.OleDb.OleDbException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.

My connection string is
ConnectionString = "Provider=SQLOLEDB;Server=NameofDBMachine;Database=Nameof
DB;Trusted_Connection=yes";

Please Help

Thanks & REgards,

Dhiren

Relevant Pages