SQL Server 2025 Azure open AI Vector Embedding for ai_generate_embeddings

Hi Team,

Currently I am trying to implement Vector Search using SQL Server 2025 and SSMS 21. For getting embeddings I am trying below code using ai_generate_embeddings, however i am getting empty embeddings.

Code :

Creating Credentials

CREATE DATABASE SCOPED CREDENTIAL [https://XXX.openai.azure.com]

WITH IDENTITY = 'HTTPEndpointHeaders',

SECRET = '{"api-key":"abcdefghi"}';

Create external model model1237

with (

location = 'https://XXX.openai.azure.com/openai/deployments/text-embedding-ada-002/embeddings?api-version=2023-05-15',

credential = [https://XXX.openai.azure.com],

api_format ='Azure OpenAI',

model_type =EMBEDDINGS,

model = 'text-embedding-ada-002'

);

declare @qv vector(1536) = ai_generate_embeddings('Hello World' use model model1237)

select @qv

but here I am getting empty embeddings. Could you please advise why i am getting empty embeddings. i tried different ways but still getting null embeddings from ai_generate_embeddings.

please advise.