![]() ![]() See WindowsIdentity.Impersonate() and/or Client Impersonation. There are many ways you can impersonate, refer to MSDN for details. Once this is done, open Task Manager to services and restart the service. Your process, or at least your thread, must actually impersonate the desired user before establishing the connection. In SSMS Connection to the server, with Object Explorer open, right-click the top node, select Security node and set as shown below. You cannot use Windows credentials from a connection string. If you want the application to use another account that is not the current Windows login account to connect to SQL Server using Windows authentication, you may should consider using impersonation.Ĭheck the following similar posts for more details. That is the way of SQL Server Authentication. Select the name of the server you’d like to connect to, and enter the login and password for it. After the installation, the SQL Server Management Studio is ready to launch: First, you’ll see the Connect to Server window. You do not need and cannot explicitly specify a Windows account(name and password) in the connection string to log in to SQL Server. Simply run through the steps and click the Install button at the end. Usually we only need to specify something like "Integrated Security=SSPI" in the connection string to indicate the use of windows authentication. ![]() The windows account currently logged in system on the client always will be used by default when the client uses windows authentication to connect to SQL Server. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |