none
Error creating audit in SSMS 18.1 for an Azure Managed Instance. RRS feed

  • Question

  • Hello,

    I'm using SSMS version V 18.1. I'm connecting to my Azure SQL Managed Instance. On the Create Audit screen, I successfully connect to my Azure account and select my storage account and blob container. When I click ok, I get the following error:

    ===================================
    The UTC time represented when the offset is applied must be between year 0 and 10,000.
    Parameter name: offset (mscorlib)

    Program Location:
    at System.DateTimeOffset.ValidateDate(DateTime dateTime, TimeSpan offset)
    at System.DateTimeOffset..ctor(DateTime dateTime)
    at Microsoft.SqlServer.Management.SqlMgmt.UrlUtils.CreateSharedAccessPolicyOnContainer(CloudBlobContainer container, String policyName, DateTime selectedSaredAccessExpiryTime)
    at Microsoft.SqlServer.Management.SqlMgmt.AzureStorageContainerAccessBase.CreateSASCredential(Credential& createdCredential)
    at Microsoft.SqlServer.Management.SqlMgmt.AzureStorageContainerController.CreateCredential()
    at Microsoft.SqlServer.Management.SqlMgmt.AzureStorageContainerDialog.btOK_Click(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
    at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
    at System.Windows.Forms.Application.RunDialog(Form form)
    at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
    at Microsoft.SqlServer.Management.RelationalEngineTasks.ManageUrlAuditView.buttonBrowsePath_Click(Object sender, EventArgs e)
    at System.Windows.Forms.Control.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnClick(EventArgs e)
    at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
    at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
    at System.Windows.Forms.Control.WndProc(Message& m)
    at System.Windows.Forms.ButtonBase.WndProc(Message& m)
    at System.Windows.Forms.Button.WndProc(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
    at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
    at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
    at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
    at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
    at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
    at Microsoft.SqlServer.Management.ActionHandlers.DialogBasedActionHandler.RunTaskFormThread(Object contextObject)

    I don't have any issues creating a credential for backing up my databases to azure storage.

    Any information you can provide will be greatly appreciated.


    Friday, June 14, 2019 1:27 PM

All replies