2009年9月24日 星期四

ASP connect to SQL Server using Windows Authentication(ASP使用Windows認證連線到SQL Server)

ASP connect to SQL Server using Windows Authentication(ASP使用Windows認證連線到SQL Server)

1.Using Computer Management,Create a new Local Windows Account name myAppUser

2.Internet Service Manager, open the Properties Sheet of the virtual directory for the Web application,
select the Directory Security tab,
click on the Edit button for Anonymous Access and Authentication Control to display the Authentication Methods.
Click the Edit button for Allow Anonymous Access to edit the NT account used for anonymous access (MyAppUser)

3.select the Basic authentication (password is sent in clear text) option(基本驗證).

[Reference]
PRB: "Client Unable to Establish Connection" Error Message When Connecting from ASP to SQL Server
http://support.microsoft.com/?scid=kb%3Ben-us%3B253500&x=6&y=10

Authentication methods for connections to SQL Server in Active Server Pages
http://support.microsoft.com/?scid=kb%3Ben-us%3B247931&x=7&y=11

How to use Kerberos authentication in SQL Server
http://support.microsoft.com/kb/319723/en-us

沒有留言: