发信人: LifeAsWater (烟水寒), 信区: DotNet
标 题: Re: ASPNET 访问SQL Server 2005 被拒
发信站: BBS 未名空间站 (Thu Jun 28 11:43:36 2007)
There are a lot of ways to connect ASP.net to SQL server. It is depend on
your use case to pick up the suitable approach.
Impersonate: This approach has problem if the client is not in the same
Window domain. But it has the advantage that different client has different
permission to access SQL server.
Built SQL Server user name/pwd into connection string: This approach is not
safe in view of security. All clients have the same permission to access SQL
Change the identity of ASP.net worker process: It is safe to connect to SQL
server using SSPI. All clients have the same permission to access SQL server
※ 来源:·WWW 未名空间站 海外: mitbbs.com 中国: mitbbs.cn·[FROM: 65.223.]