SQL connection string

[Michael]

Hi,

The MS SQL database I want to connect to uses Windows Authentication.
It seems that the username and password in the connection string are
ignored. The ASPNET user has no rights to access the database.

Thank you,
Michael

 

[Gregory A. Beamer]

Hi,

The MS SQL database I want to connect to uses Windows Authentication.
It seems that the username and password in the connection string are
ignored. The ASPNET user has no rights to access the database.

Two things to use windows accounts in this manner:

1) The user actually has to be logged in as self (ie, you have to set
authentication to check who they are)

2) Impersonation has to be set up so the user's identity is forwarded

Peace and Grace,

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

My vacation and childhood cancer awareness site:
http://www.crazycancertour.com

*******************************************
| Think outside the box! |
*******************************************

 

[George]

I wonder if there is a question hidden here....
All you stated here are correct facts..


George.