对于asp.net网站哪个更好

问题描述:

我正在为某人创建一个网站,我想问你们,当我连接到SQL Server数据库时,最好使用SQL身份验证或Windows身份验证.为什么?
非常感谢.

I''m doing a website for someone, I want to ask you guys, when I connect to sql server database which better to use SQL Authentication or windows Authentication. and why?
Thanks a lot.

如果Web服务器与用户不在LAN上,则应使用SQL authentican.否则,可以使用Windows身份验证.您不想对远程服务器使用Windows身份验证.
If the web server is not on the LAN with the user, you should use SQL authentican. Otherwise, it''s okay to use Windows authentication. You don''t want to use Windows authentication for remote servers.


^ ]


要添加到先前的答案中,使用SQL身份验证的原因之一是您拥有的用户不在您的域中.因此,如果您愿意,可以混合使用两种身份验证类型.
To add to previous answers, one reason to use SQL authentication is if you have users that are not in your domain. So if you want you can mix both authentication types.