SQL connection string

  • Thread starter Thread starter Michael
  • Start date Start date
M

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
 
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.
Click to expand...

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! |
*******************************************
 
I wonder if there is a question hidden here....
All you stated here are correct facts..


George.
 
Back
Top