Unable to connect serverless sql from Arcgis Pro client (SQL Server Authentication)

Question

Unable to connect serverless sql from Arcgis Pro client (SQL Server Authentication)

Yap Chun Hing 5

It was stated in https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms,

SSMS is partially supported starting from version 18.5, you can use it to connect and query only.

I able to use SSMS to connect to serverless sql. But, it fail when using the Arcgis Pro SQL Server connector. I presume both are using the same ODBC version. 17/18

Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-07-11T13:29:21.44+00:00

What is the error you are getting ?
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-11T13:30:58.73+00:00

Hi @Yap Chun Hing
Welcome to Microsoft Q&A platform and thanks for posting your question here.

The reason why you are able to connect to serverless SQL using SSMS is that SSMS is partially supported starting from version 18.5, which allows you to connect and query only. This means that SSMS has the necessary capabilities to establish a connection to serverless SQL and execute queries.

On the other hand, the ArcGIS Pro SQL Server connector is unable to connect to serverless SQL because it may not have the same level of support for serverless SQL as SSMS does. Although both SSMS and the ArcGIS Pro SQL Server connector may be using the same ODBC version (17/18), the connector may not be able to handle the specific requirements of serverless SQL, such as authentication or connection parameters.

The fact that you are using SQL Server Authentication with the ArcGIS Pro client may also be a contributing factor to the connection failure. Serverless SQL may have specific authentication requirements that are not compatible with the authentication method used by the ArcGIS Pro client.

I hope this information helps you. Let me know if you have any further questions or concerns.
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-15T11:01:15+00:00

@Yap Chun Hing
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Yap Chun Hing 5 Reputation points

2024-07-16T00:17:28.53+00:00

There is no direct workarounds. Probably, the best is to dump the table from Synapse serverless SQL to external SQL database then using ArcGIS pro to connect the SQL database instead.
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-16T05:30:40.3066667+00:00

Hi @Yap Chun Hing
Glad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2024-07-18T03:45:59.2566667+00:00

@Yap Chun Hing Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Amira Bedhiafi 33,071 Reputation points Volunteer Moderator

2024-07-11T13:29:21.44+00:00

What is the error you are getting ?
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-11T13:30:58.73+00:00

Hi @Yap Chun Hing
Welcome to Microsoft Q&A platform and thanks for posting your question here.

The reason why you are able to connect to serverless SQL using SSMS is that SSMS is partially supported starting from version 18.5, which allows you to connect and query only. This means that SSMS has the necessary capabilities to establish a connection to serverless SQL and execute queries.

On the other hand, the ArcGIS Pro SQL Server connector is unable to connect to serverless SQL because it may not have the same level of support for serverless SQL as SSMS does. Although both SSMS and the ArcGIS Pro SQL Server connector may be using the same ODBC version (17/18), the connector may not be able to handle the specific requirements of serverless SQL, such as authentication or connection parameters.

The fact that you are using SQL Server Authentication with the ArcGIS Pro client may also be a contributing factor to the connection failure. Serverless SQL may have specific authentication requirements that are not compatible with the authentication method used by the ArcGIS Pro client.

I hope this information helps you. Let me know if you have any further questions or concerns.
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-15T11:01:15+00:00

@Yap Chun Hing
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Yap Chun Hing 5 Reputation points

2024-07-16T00:17:28.53+00:00

There is no direct workarounds. Probably, the best is to dump the table from Synapse serverless SQL to external SQL database then using ArcGIS pro to connect the SQL database instead.
Harishga 6,000 Reputation points Microsoft External Staff

2024-07-16T05:30:40.3066667+00:00

Hi @Yap Chun Hing
Glad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.
Smaran Thoomu 24,110 Reputation points Microsoft External Staff Moderator

2024-07-18T03:45:59.2566667+00:00

@Yap Chun Hing Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi @Yap Chun Hing
I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer .

ASK
It was stated in https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-ssms,

SSMS is partially supported starting from version 18.5, you can use it to connect and query only.

I able to use SSMS to connect to serverless sql. But, it fail when using the Arcgis Pro SQL Server connector. I presume both are using the same ODBC version. 17/18

solution
There is no direct workarounds. Probably, the best is to dump the table from Synapse serverless SQL to external SQL database then using ArcGIS pro to connect the SQL database instead.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

I hope this helps!

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.****

Share via

Unable to connect serverless sql from Arcgis Pro client (SQL Server Authentication)

1 answer

Your answer