https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292013-03-07T09:17:08ZRedmineRedmine - Feature #13091: Task: Document MSSQL Supporthttps://www.redmine.org/issues/13091?journal_id=463952013-03-07T09:17:08ZDaniel Felix
<ul><li><strong>Target version</strong> set to <i>2.3.0</i></li></ul> Redmine - Feature #13091: Task: Document MSSQL Supporthttps://www.redmine.org/issues/13091?journal_id=470962013-03-19T21:11:53ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Target version</strong> deleted (<del><i>2.3.0</i></del>)</li></ul><p>Any SQLServer expert who could add a note in <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/RedmineInstall#Step-2-Create-an-empty-database-and-accompanying-user">RedmineInstall#Step-2-Create-an-empty-database-and-accompanying-user</a>?</p> Redmine - Feature #13091: Task: Document MSSQL Supporthttps://www.redmine.org/issues/13091?journal_id=471342013-03-20T08:58:42ZEtienne Massip
<ul></ul><p>Jean-Philippe Lang wrote:</p>
<blockquote>
<p>Any SQLServer expert who could add a note in <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/RedmineInstall#Step-2-Create-an-empty-database-and-accompanying-user">RedmineInstall#Step-2-Create-an-empty-database-and-accompanying-user</a>?</p>
</blockquote>
<p>Not an expert but that's the point with SQL Server: you don't need to be an expert =)<br />I've added a few lines.</p> Redmine - Feature #13091: Task: Document MSSQL Supporthttps://www.redmine.org/issues/13091?journal_id=471372013-03-20T09:11:14ZPierre Renaudet
<ul></ul><p>Etienne Massip wrote:</p>
<blockquote>
<p>I've added a few lines.</p>
</blockquote>
<p>Faster than me...</p>
<p><a href="#" onclick="$('#collapse-1d652055-show, #collapse-1d652055-hide').toggle(); $('#collapse-1d652055').fadeToggle(150);; return false;" id="collapse-1d652055-show" class="icon icon-collapsed collapsible">Show Comment</a><a href="#" onclick="$('#collapse-1d652055-show, #collapse-1d652055-hide').toggle(); $('#collapse-1d652055').fadeToggle(150);; return false;" id="collapse-1d652055-hide" class="icon icon-expended collapsible" style="display:none;">Hide Comment</a><div id="collapse-1d652055" class="collapsed-text" style="display:none;"><p>Something like that :<br />Step 2 :<br /><code>SQL Server</code><br /><pre>
USE master;
GO
CREATE DATABASE redmine;
GO
CREATE LOGIN redmine WITH PASSWORD = 'my_password', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF, DEFAULT_DATABASE = redmine;
GO
USE redmine;
GO
CREATE USER redmine FOR LOGIN redmine;
GO
EXEC sp_addrolemember 'db_owner', 'redmine';
GO
</pre><br />--<br />Step 3 :<br /><code>SQL Server (Default Port) </code><br /><pre>
production:
adapter: sqlserver
database: redmine
host: localhost
username: redmine
password: my_password
</pre></p></div></p> Redmine - Feature #13091: Task: Document MSSQL Supporthttps://www.redmine.org/issues/13091?journal_id=892342019-01-05T05:37:54ZGo MAEDA
<ul><li><strong>Category</strong> changed from <i>Website (redmine.org)</i> to <i>Documentation</i></li><li><strong>Status</strong> changed from <i>New</i> to <i>Closed</i></li><li><strong>Assignee</strong> deleted (<del><i>Jean-Philippe Lang</i></del>)</li><li><strong>Resolution</strong> set to <i>Fixed</i></li></ul><p>Instructions for SQL Server has already been added to <a class="wiki-page" href="https://www.redmine.org/projects/redmine/wiki/RedmineInstall">RedmineInstall</a>.</p>