Browser Error : Calling REST API from Sql Server

Question

Exec sp_OAMethod @Token,'Send' is throwing an error "We're sorry your current browser version is not supported".

I have setup Chrome as the default browser in the server but SQL SERVER still trying to access the API through IE.

How can I change the default browser for the sql server to go to Chrome and not IE.

Answer 1

Hi @Mukesh Gupta ，

Welcome to Microsoft Q&A!

It is recommended to provide more details about your API and how to call this API.

Please check whether Chrome is set as default browser successfully.

You could try to upgrade your Chrome to latest version or download one version which is compatible.

If it is still not working, you have to use IE instead.

In addition, you could also try to use CLR Stored procedure SQL-APIConsumer which may be easier.

Best regards,
Melissa

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

You might have set up Chrome as the default browser for some users on the server, but not for the service account for SQL Server. That is, default application is a per-user setting, not a machine-wide seting.

And in the end it may not help, because the COM objects may be hard-wired to Internet Explorer. You are not exactly using modern software.

I would recommend you that you first give it thought whether you should make REST calls from SQL Server at all. It is after all, something which is quite outside the core business of SQL Server.

Then again, I will need to confess that in the system I mainly work with, we do all REST calls through SQL Server, because that way we could have one single place for REST calls. However, we are not using sp_OAxxxx and old and dusty COM methods, but instead we have a CLR stored proedure, which is a little more reliable.

Answer 3

Thanks guys. None of the answers posted helped me with the solution but thanks for your time.
Looks like there is no solution to change the default browser that Sql Server connects to.