MSSQL server on nextcloud

🚧 Installation
1

I am new to both Linux and Next Cloud. I have just installed MSSQL server 2017 on Linux Ubuntu and wish to install it on Next Cloud server. How can I do this?

Thanks,
totbatot

2

RTFM
Hello there.
You have a page where you will find everything you need to know to install nextcloud :
Documentation https://docs.nextcloud.com/server/13/admin_manual/installation/system_requirements.html

You will see that Microsoft Sql server isn’t listed here. You can use Postgresql or Mysql or MariaDB

3

I see, but is it theoretically possible for MSSQL server to be installed on a next cloud server?

4

Yes but you won’t get any support lf you have a question or a problem with it.

You need to create a database with utf-8 as charset and a user and password to manage it.

On the wizard page install of nextcloud you will have to enter the credentials and location of this database

5

can you please explain why I would need utf-8 as charset?

6

Because the backend use PHP and use UTF-8, if your database don’t use it you will have problem with files names.

When i created my first Owncloud Server it was on Windows Server and by default the database was in windows-iso charset, everytime that someone use an accent in the filename…boom get remplace by a strange charactere in the filename because of the mismatch between PHP-Charset and Database-Charset.

If you want to use Smileys in your files names you can use this charset : Because the backend use PHP and use UTF-8, if your database don’t use it you will have problem with files names.

When i created my first Owncloud Server it was on Windows Server and by default the database was in windows-iso charset, everytime that someone use an accent in the filename…boom get remplace by a strange charactere in the filename because of the mismatch between PHP-Charset and Database-Charset.

If you want to use Smileys in your files names you can use this charset : utf8mb4_general_ci
https://docs.nextcloud.com/server/11/admin_manual/maintenance/mysql_4byte_support.html
https://docs.nextcloud.com/server/11/admin_manual/maintenance/mysql_4byte_support.html