Well, this is a nice coincidence. We use the RPA software our self to automate SQL logins. So I recorded a quick screencast:
As @newuserkantu assumed correctly, it works with no problem 
=> If you still can not get it to work, please post a screencast of how it runs on your website.
What my macro does is it:
- double-clicks the SMSS icon
- use VisualAssert to wait for the SMSS to start
- XClick on the login dialog to make sure it has the focus <= This is missing in your macro.
- XType to send server name
- XClick (button image) to click connect. Login times out because I use a fake user name in this demo macro.
Macro with images (Import as ZIP): SQL-Login.zip (5.8 KB)
Macro:
{
"Name": "SQL-Login",
"CreationDate": "2020-6-7",
"Commands": [
{
"Command": "XClick",
"Target": "icon_dpi_96.png",
"Value": "#doubleclick"
},
{
"Command": "store",
"Target": "60",
"Value": "!TIMEOUT_WAIT"
},
{
"Command": "visualAssert",
"Target": "sql_dpi_96.png",
"Value": ""
},
{
"Command": "XClick",
"Target": "sql_dpi_96.png",
"Value": ""
},
{
"Command": "XType",
"Target": "Super SQL",
"Value": ""
},
{
"Command": "XClick",
"Target": "connect_dpi_96.png",
"Value": ""
}
]
}