SQL Stretch DB - error Msg 40673, Level 16, State 1, Line 24
Arthur Moulding
0
Reputation points
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
173 questions
Sign in to answer