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
Brad Chen's Developer Blog Azure Database Data science Machine Learning Cloud
訂閱:
張貼留言 (Atom)
SQL Server Database Mirroring 資料庫鏡像
SQL Server Database Mirroring 資料庫鏡像
-
1.安裝了Oracle Client,就可以用Oracle Net Manager工具來設定TNS連線設定(Tnsnames.ora) Oracle Client 18.3 Installation 安裝Oracle Client 18.3 2.啟動Oracle Ne...
-
1.下載 Oracle Database 18c (18.3) https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-windows-180000-5066774.ht...
-
ASP.NET MVC Web App啟用SSL (Https連線) 1.在Web專案屬性 (1)將SSL已啟用改為True (2)複製或記下SSL URL路徑 2.Web專案屬性視窗,將專案URL改成上一個步驟複製的SSL URL路徑 3.在需要使用Https的Contro...
沒有留言:
張貼留言