Topic on Project:Support desk

Tried multiple times to follow SQL server install instructions, have created the schema by hand and it works for same credentials so don't know why this is failing! Also would be great to add to existing DB given one can specific schema/prefix.

Setting up database...

A database query error has occurred. This may indicate a bug in the software.

• Query: CREATE SCHEMA [Wiki]
• Function: MssqlInstaller::setupDatabase
• Error: 15247 [SQLSTATE 42000][Error Code 15247][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]User does not have permission to perform this action. [SQLSTATE 42000][Error Code 2759][Microsoft][ODBC Driver 11 for SQL Server][SQL Server]CREATE SCHEMA failed due to previous errors.

Backtrace:

#0 D:\home\site\wwwroot\includes\db\Database.php(1076): DatabaseBase->reportQueryError('[SQLSTATE 42000...', 15247, 'CREATE SCHEMA [...', 'MssqlInstaller:...', false) #1 D:\home\site\wwwroot\includes\installer\MssqlInstaller.php(508): DatabaseBase->query('CREATE SCHEMA [...', 'MssqlInstaller:...') #2 [internal function]: MssqlInstaller->setupDatabase(Object(MssqlInstaller)) #3 D:\home\site\wwwroot\includes\installer\Installer.php(1592): call_user_func(Array, Object(MssqlInstaller)) #4 D:\home\site\wwwroot\includes\installer\WebInstallerPage.php(1419): Installer->performInstallation(Array, Array) #5 D:\home\site\wwwroot\includes\installer\WebInstaller.php(280): WebInstallerInstall->execute() #6 D:\home\site\wwwroot\mw-config\index.php(77): WebInstaller->execute(Array) #7 D:\home\site\wwwroot\mw-config\index.php(36): wfInstallerMain() #8 {main}

I'm actually installing against AzureSQL but this should look exactly like any SQL Server.

Instead of trying to solve the permission problem, I want to tell you this: While MediaWiki in fact should work with MSSQL, its MSSQL support is way less mature than the MySQL support. So if you are setting up a new database system now anyway, I recommend using MySQL (or MariaDB if you like). MediaWiki will run with less trouble and - should you have questions - it will be way easier to get support from the MediaWiki community as basically everyone uses MySQL (or MariaDB), while nearly no one uses MSSQL.

See also task T113831

As you can see in the task, Skizzerz, who implemented MSSQL support, is talking, but I have not seen a single patch. So at least currently this seems to me like he has no definite plans to make it working in versions other than 1.23. Based on the reading in this phabricator task, I tend to change my "MSSQL should work" to a "MSSQL might work, partly maybe only by accident and you absolutely cannot expect it to continue working in current and even less in future versions".

And to make this very clear: There has not been a single patch up to now, but even if there would be patches to make MediaWiki work better with MSSQL, there are absolutely no plans to make 1.26 compatible as well. I strongly discourage using MediaWiki 1.26 with MSSQL.

Thanks for insights. I had planned to use MySQL. The Installer though gave the option for MSSQL so I thought I'd give it a go. Perhaps the installer should present options based on version/db-engine compatibility and not provide unsupported install options - that confuse novices ?

I guess one could regress to 1.23, for now (it's for experimental use anyway) and look for future supported compatibility when it arrives. Based on the experiment we can redeploy as MySQL. Once assumes any setup and data can be migrated from MSSQL to MySQL as the schemas are logically similar?

If you plan to use MediaWiki once MediaWiki 1.23 will be no longer supported (May 2017), don't use MSSQL.

Support for MSSQL in LTS version is for supporting those that created their wiki while it was supported, to provide at least an LTS version instead of running an old and insecure wiki.

1.23.14 did not work anyway...still errors out trying to create tables in the wrong DB (Master), so will revert to MySQL

Thanks All!

Looks like we need to grant permission before creating schema,

https://social.technet.microsoft.com/Forums/en-US/88e809e5-f610-4200-9e46-1e022a1854f3/how-to-create-a-schema-in-sql-azure?forum=ssdsgetstarted

Unless you are using root, you should grant rights after created a new database account.

How to get root password on Azure?

Is the share host? Perhaps you should find the relevant documents or ask your host provider