Unable to connect to new Azure Fabric SQL Database Error: Invalid object name 'sys.database_filestream_options'
I have just created our first Azure Fabric SQL Database, however when I attempt to connect to the database I get the error: "Invalid object name 'sys.database_filestream_options'."
Any thoughts on why I might be getting the error?
The details that I'm using to connect to the Fabric Database is as follows:
The server is:
hst37dg5zi3ubnnbowh254jpyy-exnwgcizvwnurfcoqllpyaj3q4.database.fabric.microsoft.com,1433
and the database is:
fbr_configDB-900814cf-bd9f-4b6c-8dcb-92d898c2deb5
Can someone let me know how to determine the 'System view'?
I should mention that I don't get this problem when I connect to the Database with SSMS
The sys.database_filestream_options system catalog view provides details about the level of non-transactional access to FILESTREAM data that is enabled for FileTables within a database.
To enable FILESTREAM in SQL Server Management Studio (SSMS), follow these steps:
- In SSMS, right-click on the server name and choose Properties.
- Navigate to the Advanced page and ensure that the FILESTREAM Access Level is set to a value other than Disabled.
- How do I persist logs from a Dockerized .NET Core app in Azure DevOps and save them as artifacts?
- Azure won't show roleDefinition for directory roles
- How do we change the TLS version of Azure IoT Hub which is already created and deployed?
- Microsoft Graph API ADB2C signInActivity update lag
- How does Azure App Service manage port binding with docker container? Does it recognize Expose?
- Has there been a recent change to Invoke-Sqlcmd that break it, and if so what's the fix?
- Is using AddAzureClients and a clientFactory for Azure ServiceBus DI preferred over a singleton implementation?
- Redeploy .NET Aspire project after resource cleanup
- SocketException permission denied when trying to bind port 80 or 443 to Kestrel in Azure Container Instance with .NET 8
- Azure Functions with docker: How change port?
- Azure - How to update the password profile of a user in Azure AD B2C using the Microsoft Graph API?
- Unable to filter the service principals by appOwnerOrganizationId property
- How can I upload an image to Azure from an Azure Function with a BlobTrigger
- How can I see which mechanism granted the user the ability to activate roles via Azure Privileged Identity Management (PIM)
- How to resolve an "Invalid operands found for operator -eq" error in Microsoft Entra ID PowerShell code
- You don’t appear to have an active Azure subscription when creating new Kubernetes service connection in Azure DevOps
- Azure Application Insights JavaScript SDK loader script security
- How to fix 'Unable to Obtain Authentication Token' in Active Directory Authentication to Azure Analysis Server
- Python script to join 2 csv files with an existing excel file in Azure blob storage
- Can one use DPO (direct preference optimization) of GPT via CLI or Python on Azure?
- azure function via terraform: how to connect to service bus
- Azure WebJob is failing after some period of time on Linux plan
- Retry policy on blob leasing
- Azure auth for Outlook Graph API
- Copying storage data from one Azure account to another
- Windows Azure SDK for Node.js SQL Azure Provider
- Pipeline for stored procedure dedicated sql pool
- Webpack @azure/storage-blob node-fetch AbortSignal issue
- What is the Azure equivalent of GCP's Cloud Run?
- How stop execution of a stored procedure if the client closes the connection in SQL Azure database?