March 31, 2020 at 2:14 pm
Hi,
I've created a new Work Environment using VMWare Workstation Player 15 VM running Windows Server 2012. I've installed SQL Server 2016 with SSMS 18.4. This environment appears to be running just fine with one exception.
When trying to attach a database with File Table turned on the database will not attach. I've attached two other databases without File Table and they attached fine. It seems that the system cannot read from the document folder for the File Table. See attached error file.
To make this more perplexing, I have the same database attached in a Windows 10 environment with SQL Server 2014 on the host machine and it works properly.
I have full control permissions on the folder and the database as does the database instance. And I am running SSMS as administrator.
I've searched forums, including this one and cannot find a solution. Perhaps an expert in this group can help me to solve this problem.
I'd appreciate any input that will lead to a solution.
gmangrant
March 31, 2020 at 2:18 pm
Have you enabled FileStream on the SQL instance in the VM?
March 31, 2020 at 2:20 pm
This error is interesting: "Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL12.ADISDB\MSSQL\DATA\ADIS_GREEN_WEB_DOCS"
Why does the file name not have any extension?
March 31, 2020 at 8:06 pm
Hello Phil,
Thanks for looking into this problem but I have found the solution. It seems that the filestream folder existed in a slightly different path. On our server at work the server instance and hence the filestream is stored on D:\... while I was attempting to attach on C:\...
This is the article that helped.
Thanks again,
gmangrant
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply