Unable to Connect to SQL Server 2019 Instance

[chrcapone]

I am writing to seek assistance with an issue I am encountering while trying to connect to a specific instance of SQL Server 2019 using the iOS version of SQL Pro.

The connection works seamlessly when I do not have to specify an instance name. However, when attempting to connect to a specific instance, the connection fails. Below are the details of my setup:

• SQL Server Version: SQL Server 2019
• SQL Pro Version: V2024.53.93
• Device: iPad Pro 12.9” 6th Generation
• iOS Version: 17.5.1
• Instance Name: MSSQLSERVER2019

I have verified that the instance name is correct and that it is accessible through other SQL client applications.

Could you please guide me on how to resolve this issue?

Thank you for your assistance.

[hankinsoft]

Hi. Two questions:

1. Whats the error you receive when connecting?
2. Could you attach the log file after a failed connection? You can find it by opening settings (the gear on the connection screen) and join to Support -> View logs.

[chrcapone]

Thank you for your email. Please find below the error As extra information, I can tell you that the application is still trying to connect to the default instance even if I have specified a different instance. Indeed if I am using a user of the default instance, I am able to login even if I have specified a different instance, like it is ignoring it. Please find below the connection settings End below the lot

[hankinsoft]

Hi,

10.0.2.246\MSSQLSERVER2019:1433

it looks like you are specifying a port here, which would supersede the instance name. Instances work by using different ports, but here the default port is specified. Can you try removing that portion?

[chrcapone]

Perfect, thank you so much, removing the port it works!

[hankinsoft]

Glad to hear it. I’ll be taking a look into the keyboard issue over the next couple of days.

[chrcapone]

Thank you so much, if you need a video let me know!