Oddest error in Windows 10 Pro: windows 10 pro spotify error data area passed is too small caused by SQL 2017 enabled with filestream

https://answers.microsoft.com/en-us/windows/forum/all/windows-10-store-the-data-area-passed-to-a-system/0b727e53-d562-4145-b458-90c8bbe25047?auth=1


https://blogs.msdn.microsoft.com/sql_server_team/centennial-appsdesktop-bridge-sql-server-and-
error-the-data-area-passed-to-a-system-call-is-too-small/

I had tried to install Spotify and Skype on my new Windows 10 pro laptop and this error occurred:

  Data area passed is too small

From first article:

I suspect you may have a SQL database using filestream. It looks like a SQL bug is causing Windows Store apps using Centennial to crash with this error. For me this includes Ubuntu and WhatsApp. For more info check out the SQL Tiger blog where it is discussed. A fix is out for SQL 2017 but still waiting for older versions.

From second article:

Scenario:

1. Install Windows 10 1607 or later on the system.

2. Install SQL Server and enable the SQL Filestream feature (Ref: https://docs.microsoft.com/en-us/sql/relational-databases/blob/enable-and-configure-filestream )

3. Create a database with a filestream container. Ensure that container is hosted on the drive which also hosts the Centennial applications.

4. Install any Centennial application such as MS Office Preview apps or Ubuntu Linux from the Microsoft Store application

5. Launching any Centennial application fails with the following error

Fix: Install latest SQL 2017 update.

Windows 10 pro workstation missing OneDrive integrated folder in File Explorer

Found the solution on https://superuser.com

BTW, Love their URL format

https://superuser.com/questions/1147030/onedrive-not-integrated-with-windows-explorer-on-windows-10-enterprise-1607

Run OneDriveSetup.exe  as Administrator
or OneDrive.exe as Administrator