Sql server linked server credentials4/6/2024 In order to make Windows Authentication work in this situation the middle tier server need to impersonate the user when connecting to the backend machine. When users connect to a backend server through a middle server this is commonly called a double hop. What is Delegation?ĭelegation is when a middle tier server, impersonates the client login when connecting to a backend server. This article will discuss how to set up delegation on your SQL Server instances so you can use the impersonate options when setting up the security properties of linked server definitions. One of those challenges is setting up linked servers to impersonate the local login when connecting to a linked server. If your goal is to use Windows authentication for everything then under some situations it does present some challenges. Windows Authentication is the preferred and more secure method of connecting to SQL Server. If you are like most, you probably have looked into using Windows Authentication as a method to authenticate users to SQL Server 2005.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |