Automatically submit an "OK" button press to SQL Server when brought up

74 Views Asked by At

I'm opening an instance of MS SQL Server 2016 with a small C# program.


  • When it comes up for the first time, there is a login box where essentially it asks for your username and password.
  • This information is retained in the box because I clicked the "Remember Password" checkbox that is located on the box.
  • Then to move on there is a "Connect" button you have to click to enter the application.

My question is this:
Is there any way possible using C# to "click" the connect button automatically so it goes into the application without me having to manually intervene and click the connect button?


Any help given will be much appreciated.

1

There are 1 best solutions below

0
On

Ssms command line argument should work here, but you need to specify the login credential in the argument.

Ssms -U [USERNAME] -P [PASSWORD] -S [SERVERNAME] -d [DBNAME] -nosplash