ASP.NET/SQL Server Integrated Security Problem

From: Eric (eric.h@netcourrier.com)
Date: 04/10/03 

From: "Eric" <eric.h@netcourrier.com>
Date: Thu, 10 Apr 2003 14:07:03 +0200

Hi all,

On our domain we have a Win2k Server machine that runs SQL Server 2000 and
another one running IIS5.
On IIS5 we have an ASP.NET web site that connects to the SQL Server on a
"DB" database.
I have configured SQL in mixt mode and I have created a SQL login that is
dbo of the "DB" database.
In the web.config I have put the UID and Pwd of this user and everything is
working fine....

Now I'd like to change my SQL Server settings to be in integrated security
only.
Before doing that (just to be sure it will work...) I created a domain
account, added this account as dbo of "DB" and changed the connection string
with this user.....
When the web site connects to SQL I have an error saying that this user
cannot be found...(I also tried in the connection string to put Domain\user
but still the same)

Is it possible to use a domain user to connect to my DB instead of using a
SQL user and how can I do that?

Thanks

Eric

Relevant Pages
Quantcast