SQL Stretch DB - error Msg 40673, Level 16, State 1, Line 24

Arthur Moulding 0 Reputation points
2025-05-07T17:36:13.0966667+00:00

Hi

when setting up StrechDB from an on prem server i get the error below

Msg 40673, Level 16, State 1, Line 24 The service objective assignment for the database has failed

This happens when i run the following script

ALTER DATABASE XXXXXXX

SET REMOTE_DATA_ARCHIVE = ON

(

    SERVER = 'xxxxxx.database.windows.net',

    CREDENTIAL = AzureStretchCredential

);

GO

I can connect to the Azure database from the on prem server using SSMS without any issues

Any ideas?

Arthur

SQL Server Database Engine
{count} votes