This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(28.799999999999997, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYE%3C/text%3E%3C/svg%3E)
When doing a SQL server upgrade from 2019 to 2025, im running into an issue when it is trying to finalize the Fulltext index part of the upgrade.
It seems like the upgrade locks itself out of the upgrade, by putting permissions on the Filterdatafolder, so it can no longer be accessed be the install process. When i try to check permissions on it with a local admin, i get access denied, ive even tried via psexec as SYSTEM but no luck.
The error im getting in the SQL Install is the following:
anyone experienced this, and how do i fix it?
Additional SQL Server features and topics not covered by specific categories
Do you actually have any data in that folder? That is, are you using fulltext filters?
In the upgrade process there are different options for full-text, which one did you take?
Am I right to assume that this is a named instance by the name MSSQLSERVER2?
Yes, i am using fulltext filters and there is some files inside folder. There is 3 options when doing implace upgrade. Import, Rebuild and Remove. I tried Import and Remove both of gave me same error.
In that host i have 3 instances and one of its name is MSSQLSERVER2, which is i am tring to upgrade. Other 2 instances successfully upgraded without any errors.
I always go with Rebuild, but I suspect that it does not matter. I suspect that you actually use filters plays in here. Do you have filters on the other two instances as well?
As Deepesh says, if you can share summary.txt and details.txt, we might find some clues there. But please don't paste any file into a query window, but attach them.
Answer recommended by moderator
![](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(9.6, 52%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
@Yunus Emre Coşkun sorry for the late response.
try with below link options to set new SID with instances and try to install.
https://serverfault.com/questions/767094/change-sql-server-user-sid
Thanks.
![](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(35.2, 63%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
The exact failure reason is written to the setup logs at "C:\Program Files\Microsoft SQL Server...\Setup Bootstrap\Log". You can open Summary.txt and search for the failed action. Are there any more details why it is failing?
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
In that host i have 3 instances and one of its name is MSSQLSERVER2, which is i am tring to upgrade. Other 2 instances successfully upgraded without any errors.
In Summary.txt file there is no error lines about MSSQLSERVER2. Ofc i'm searching solution with couple of AI and its all propose firstly check logs too :)
Do you see any error information in Details file?
C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\
While install or upgrade applications need a admin permission. and you provided permission to particular folder 'Filterdatafolder' I think. so please provide permission to 'SQL_DATA' folder might be chance to fix your issue.
Thanks.
Thanks for reply @Senthil kumar but its not exact solution, we tried it.
Even though we granted full permissions from the parent directory, the issue persists as the update process breaks the permission chain. Is it possible that the user account utilized during the initial installation was subsequently modified, leaving the permissions in an orphan state?
Thanks @Yunus Emre Coşkun , may be try to provide permission to full drive. then try to install the same. suppose its failed try to install any other drive like. most probably try to install in C drive.
Trying to grant permissions, attempting with local admin, or even trying to access the entire drive from the parent directory doesn't work because, as far as I understand, the SID information of the user used during the initial installation of the instance was later removed, and when attempting an implace upgrade, it tries to perform the operation with that removed SID. Since it can't find the user with that SID, it gives a permission error. So it seems like we have an orphaned account.
![](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(227.2, 35%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Hi @Yunus Emre Coşkun ,
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we'll assist further
Thanks,
Lakshmi
Hi @Yunus Emre Coşkun ,
Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we'll assist further
Thanks,
Lakshmi