Project

General

Profile

Actions

Feature #18122

open

problems with ms sql database - permissions solved

Added by jerko cus over 9 years ago. Updated about 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Documentation
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

On installation tutorial in step regarding to creating database on MS SQL Server, after the database and user with specific permission are created please do also the following actions.

Go to Microsoft management studio . Open the REDMINE database and then open the security folder and find REDMINE user in it.

Give the selected permission to REDMINE user in section role_members (like You can see in attach).

Also please NOTE : Use IP adresess for host in database configuration files. (database.yml)

*DOWN BELOW YOU CAN FIND THE SECTION FROM REDMINE INSTALLATION TUTORIAL for which the problem is manifested **************************************

SQL Server
The database, login and user can be created within SQL Server Management Studio with a few clicks.

If you prefer the command line option with SQLCMD, here's some basic example:

Hide SQL

USE [master]
GO

-- Very basic DB creation
CREATE DATABASE [REDMINE]
GO

-- Creation of a login with SQL Server login/password authentication and no password expiration policy
CREATE LOGIN [REDMINE] WITH PASSWORD=N'redminepassword', DEFAULT_DATABASE=[REDMINE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

-- User creation using previously created login authentication
USE [REDMINE]
GO
CREATE USER [REDMINE] FOR LOGIN [REDMINE]
GO
-- User permissions set via roles
EXEC sp_addrolemember N'db_datareader', N'REDMINE'
GO
EXEC sp_addrolemember N'db_datawriter', N'REDMINE'
GO


Files

REDMINE_role_members.JPG (77.1 KB) REDMINE_role_members.JPG jerko cus, 2014-10-17 10:53
Actions #1

Updated by Toshi MARUYAMA over 9 years ago

I don't know what tutorial you said.
You can edit or create wiki on redmine.org.

Actions

Also available in: Atom PDF