Hi Team,
Has anyone worked on onboarding sql developer application in Password safe? We are trying to onboard the SQL Developer application in password safe, However we are not able to click on connection which is already created in Sql Developer.
I need help in understanding using AutoIT , how can I click on connection which is created. Once we can click on existing instance we will inject password on it .
Need help here please .
Regards,
Imran
+3Have you created your own custom ini file for this? I’m currently testing SSMS_database.ini through ps_automate on our RDS farm. So far I've only been able to get Windows Authentication working, and that has been with a stripped back ini file using only a couple of task sequences with the right amount of SendKeys tabs to pass through the connection properties with selecting the Trust Server Certificate and then tabbing through again to connect and hitting enter.
[General]
EnableLogging=4
LogMethod=1
LogPath="C:\Program Files\BeyondTrust\pbpsmon\logs"
RunApp="C:\Program Files\Microsoft SQL Server Management Studio 22\Release\Common7\IDE\Ssms.exe"
AppWindowTitle="Connect to Server"
[TaskSequence1]
AppWindowTitle="Connect to Server"
AppWindowControlID="[NAME:serverInstance]"
SendKeys=%servername%
[TaskSequence2]
SendKeys={TAB}{TAB}{TAB}{TAB}{SPACE}{TAB}{TAB}{TAB}{TAB}{TAB}{TAB}{ENTER}
But what I'm also aiming for is to how we can use ps_automate on the RDS farm to launch SSMS and use managed SQL accounts for SQL Authentication. This I'm struggling with and searching for anything from the wider community.
Have you created your own custom ini file for this? I’m currently testing SSMS_database.ini through ps_automate on our RDS farm. So far I've only been able to get Windows Authentication working, and that has been with a stripped back ini file using only a couple of task sequences with the right amount of SendKeys tabs to pass through the connection properties with selecting the Trust Server Certificate and then tabbing through again to connect and hitting enter.
[General]
EnableLogging=4
LogMethod=1
LogPath="C:\Program Files\BeyondTrust\pbpsmon\logs"
RunApp="C:\Program Files\Microsoft SQL Server Management Studio 22\Release\Common7\IDE\Ssms.exe"
AppWindowTitle="Connect to Server"
[TaskSequence1]
AppWindowTitle="Connect to Server"
AppWindowControlID="[NAME:serverInstance]"
SendKeys=%servername%
[TaskSequence2]
SendKeys={TAB}{TAB}{TAB}{TAB}{SPACE}{TAB}{TAB}{TAB}{TAB}{TAB}{TAB}{ENTER}
But what I'm also aiming for is to how we can use ps_automate on the RDS farm to launch SSMS and use managed SQL accounts for SQL Authentication. This I'm struggling with and searching for anything from the wider community.
I am facing issue with sqldev and not with ssms application. with SSMS there is no issue . issue is with sqldeveloper app
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
