Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)

Question

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)

Patrick LEONARD 0

Microsoft SQL Server Enterprise Developer (64-bit) / Windows 11 Home /

We hebben de volgende procedure gevolgd

https://devblogs.microsoft.com/azure-sql/getting-started-with-ai-in-sql-server-2025-on-windows/

DECLARE @ret AS INT, @response AS NVARCHAR (MAX) ;

EXECUTE @ret = sp_invoke_external_rest_endpoint @url = N'https://localhost',

@method = 'GET',

@response = @response OUTPUT;

SELECT @ret AS ReturnCode,

   @response AS Response;

Geeft volgende Fout

Msg 31608, Level 16, State 29, Procedure sys.sp_invoke_external_rest_endpoint_internal, Line 1 [Batch Start Line 0]

An error occurred, failed to communicate with the external rest endpoint. HRESULT: 0x80070008.

2 answers

Your answer

Answer 1

Erland Sommarskog 132.4K MVP Volunteer Moderator

Using the very old utility Error Lookup, I find that error 0x80070008 is Not enough memory resources are available to process this command.

How much RAM do you have on your machine?

Patrick LEONARD 0 Reputation points

2026-01-30T08:02:05.4033333+00:00

Ram is 32 GB (running only sql 2025 with advetureworks database) and ollama with a small model , also i did the same installation on an other machine and have the same problem So RAM is definitely not the cause .
Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator

2026-01-30T22:19:35.51+00:00

I note that in the blog post you referred to, there is no direct reference to sp_invoke_external_rest_endpoint, but there is an example how to use AI_generate_embeddings, which indeed uses sp_invoke_external_rest_endpoint internally. But I also note that in the example, the URL is given as https://localhost:11435/api/embed and not simply https://localhost.

Did you try to contact Ollama from outside SQL Server? There is seems to be a PowerShell example in the blog post for how to do that. That can be a good step in troubleshooting.
Shruti Dhruv 875 Reputation points Microsoft External Staff Moderator

2026-02-03T08:55:50.3566667+00:00

Hi Patrick,

Just wanted to check if you were able to resolve the issue.
If you still have any questions, let us know so that we can assist you.

Thank you

Answer 2

The error message HRESULT: 0x80070008 indicates a failure to communicate with the external REST endpoint, which could be due to several reasons. Here are some steps to troubleshoot the issue:

Service Availability: Ensure that the service you are trying to access at https://localhost is running and reachable. You can verify this by accessing the URL directly in a web browser on the same machine.
Firewall Configuration: Check your firewall settings to ensure that they allow traffic to the port your local service is using. Firewalls can sometimes block requests to localhost.
Use IP Address Instead: Try replacing localhost with 127.0.0.1 in your sp_invoke_external_rest_endpoint call. This can help avoid any issues related to name resolution.
SQL Server Permissions: Make sure that SQL Server is configured to allow external calls. You may need to review the SQL Server settings related to external access.
SSL/TLS Configuration: Since you are using HTTPS, ensure that your local service is properly set up for SSL/TLS. Issues with the SSL certificate can prevent successful communication.
SQL Server Logs: Review the SQL Server error logs for any additional details that might provide insight into the issue. Look for entries related to external REST endpoint calls.

If these steps do not resolve the issue, further investigation into the SQL Server logs or additional documentation may be necessary for more specific troubleshooting guidance.

Share via

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)

2 answers

Your answer