Hi Team,
I am login into machine using User Id and Password. Now I have to login to sql server inside machine using windows cred authentication with different user. Is that possible if yes How we can acheive ? what will be the connection string.
Hi Team,
I am login into machine using User Id and Password. Now I have to login to sql server inside machine using windows cred authentication with different user. Is that possible if yes How we can acheive ? what will be the connection string.
you can find the location of the file Ssms.exe
“C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe”
click and hold Shift key from the board
right click on the file Ssme.exe and run it as the user you need
**my option were in German, sorry
I hope its helpful
then select to connect using Windows Authentication Mode
@Palaniyappan @loginerror @Pablito @balupad14
Can you guys please help us on this if you have any suggestion please suggest the solution.
Thanks in Advance!
Thanks @wagner . Shirish wants this to be done programmatically via UiPath , is there a way to do it?
I think so but we would need more investigation.
You can refer the following documentation and then starting investigating how to start the process as a differente user
or you can focus how to simulate sending a hot key having Shift keys pressed.
Then your automation can right click and start the process as a different user, and so on .,.,
but everythings demands more investigation.
I hope my comments are helpful.
Thanks