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.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply