This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
just tested SQL Server 2022 RC1 Express Edition and I am getting an undocumented error when I am adding a file to a filegroup containing filestreams.
This only fails in the Express Edition adding the file/filegroup to an existing database.
Does not fail in Evaluation Edition or Developer Edition.
Does not fail when creating the file/filegroup with CREATE DATABASE.
Steps to reproduce:
Msg 35221, Level 16, State 1, Line 13
Could not process the operation. Always On Availability Groups replica manager is disabled on this instance of SQL Server. Enable Always On Availability Groups, by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online.
The error is not listed database-engine-events-and-errors documentation.
The SQL Server installation ConfigurationFile.ini
----------
System Info:
Microsoft SQL Server 2022 (RC1) - 16.0.950.9 (X64) Sep 13 2022 13:09:32 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)
I have run into the same error. But in my case I tried to add a second log file to a database.
And this was on Evaluation Edition. What I noticed was that it works on my default instance, but on a named instance on the same machine.
I tried your script on my instances, and result was the same: works on the default instance, fails on the named instance.
Good hint. It actually only fails on named instances. Doesn't matter which edition you install.
If I install the Express Edition as the default instance, the script also works.
For what it's worth, I have reported this on
https://feedback.azure.com/d365community/idea/212a7e0e-bc50-ed11-a81b-000d3adfeb99.
I checked your sharing advice thanks so much for your contribution to the Microsoft !
Installer ou ajouter une table ou unficher
Hi @David Wimmer ,
I think it might be the version problem, cuz the express version does not support some funtions like the following picture shows:
You can check this official link, I hope this can be helpful.
https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2022?view=sql-server-ver16
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"
This issue should have nothing to do with Always On Availability Groups. In my opinion the error message is misleading.
As @Erland Sommarskog mentioned the error occurs on named instances in all editions (Developer, Evaluation and Express).
If I install the Express Edition as default instance (unnamed) this script also works.
Hi @David Wimmer
Then I think the next soultion is clear that you just need to use SSCM to change the TCP/IP port into 1433.
I changed the port from dynamic to 1433 in SSCM and the same error occurs.
Hi @David Wimmer ,
May I ask did you also change the set of firewall. Pls try this code in CMD: telnet 127.0.0.1 XXXX(port number). So far that's the soultion I can come up with.........If it still doesn't work, I will continue trying other soultions.
The telnet command works. The error in SQL Server still occurs.
Panda, before you come with all sorts of funny suggestions, why don't you test the ideas on your own first?
This is a plain bug in SQL Server 2022, which preferably should be fixed before RTM.
My dear Er @Erland Sommarskog my test tool is a VM, and there are also many limitaions about downloading the software. Besides some kind of problems I can't reproduce on my environment. My job is to provide possbile ideas and advice to help SQL Server user. And I don't know why you define the suggestion as funnny ？ I feel confused that try helping others with the definition of funny or not funny. :)
I can't speak for David, but if I go to a forum and ask about a problem, and I get a reply from someone who appears to represent the vendor in question, I expect a reply that is at least somewhat on the mark. I don't expect wild guesses or suggestions that have no relevance to the problem. Such replies only serve to give the vendor a bad reputation.
(To be fair: this has occurred to me with other vendors than Microsoft as well. But this is still not how you give support.)
What I would expect of you in this particular case is that you reproduce the problem yourself, and then alert the Product Group about this issue, as this is a potential blocker for the release of SQL 2022.
I already posted it there yesterday in the hope that someone there would take care of it.
https://feedback.azure.com/d365community/idea/b35e9417-5e50-ed11-a81b-000d3a7c50ce
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
The problem still persists for the recently released SQL Server 2022 Express edition (RTM version).
Don't know whether this is because this GA version is built on Oct 8, 2022.
Hope that this can be fixed in next cumulative update.
select @@VERSION
Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows Server 2022 Standard 10.0 <X64> (Build 20348: ) (Hypervisor)