May 12, 2015 at 4:24 am
Hi,
Is it possible to make window authentication using Connection String.
Like
Data Source="Remote Host"; User ID="user1"; Password="Password"
Integrated Security=SSPI'
user1 have rights on SQL server.
Is it possible user2 logged in on different machine can access SQL server.
user2 does not have rights on SQL Server.
Plz help?
Thanks.......
-----------------------------------
My Blog[/url] | Articles
May 12, 2015 at 5:01 am
Not possible. Run the client application in the security context of the windows user using runas or any other impersonation mechanism.
-- Gianluca Sartori
May 12, 2015 at 5:02 am
Windows authentication is just that, the application is verified when connecting to the SQL server under the security context of the windows login that executes the application.
If the application is executed and the machine logged into as User 2 then no it cannot run as User 1.
The only exception is that when launching the application providing its on a windows machine you use the method of right clicking on the application and selecting "Run As" and specify User1's login and password.
MCITP SQL 2005, MCSA SQL 2012
May 12, 2015 at 5:27 am
RTaylor2208 (5/12/2015)
--The only exception is that when launching the application providing its on a windows machine you use the method of right clicking on the application and selecting "Run As" and specify User1's login and password.
Windows Credentials can also be used to avoid having to use Run As.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply