nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

error de inicio de sesion DB SQL SERVER 2014

roberto_bonilla

Buenos días,

estoy instalando por primera vez JIRA software. Durante la instalación indico que quiero usar mi propia base de datos e indico los siguientes parámetros en el asistente:

- Tipo de BD: Microsoft SQL Server

- Nombre de Servidor: X\Y

- Puerto: 1433 (por defecto)

- BD: BDx

- Nombre de usuario: jiradbuser

- Clave: X

- Esquema: dbo

Al realizar la prueba de conexión siempre recibo el mismo error: "Error de inicio de sesión del usuario jiradbuser. clientconnectionId: .......

He probado a iniciar sesión con éste usuario en la base de datos y sin problemas. He descargado el driver de Microsoft "sqljdbc_6.2" tal como indica la documentación y no consigo superar la prueba de conexión.

¿Podríais indicarme que hacer o que procedimiento seguir? No consigo dar con el error.

Un saludo, gracias de antemano.

Roberto.

Accepted answers

All comments

Shannon S

Hello Roberto,

I want to verify that your MS SQL database has been set up properly:

Pay close attention to each step, especially this:

Create a database user which JIRA will connect as (e.g. <strong>jiradbuser</strong>). This user should not be the database owner, but should be in the db_owner role.
Create an empty 'schema' in the database for the JIRA tables (e.g. <strong>jiraschema</strong>).

Let me know if you have any trouble.

Regards,

Shannon

roberto_bonilla

Hello Shannon,

thanks for the quick reply. I follow your instructions, I have problems on point 2:

Configure JIRA to connect to the database

There are two ways to configure your JIRA server to connect to your SQL Server database.

Using the JIRA setup wizard — Use this method, if you have just installed JIRA and are setting it up for the first time. Your settings will be saved to the dbconfig.xml file in your JIRA application home directory.

Collapse

The JIRA setup wizard will display when you access JIRA for the first time in your browser.

In the first screen, 'Configure Language and Database', set Database Connection to My own database.

Set Database Type to SQL Server.

Fill out the fields, as described in the Database connection fields section below.

Test your connection and save.

I'm using the setup wizard, when I test my connection always have the same error:

"JIRA - Configuración de JIRA

Error de conexión con la base de datos

Error de inicio de sesión del usuario 'jiradbuser'. ClientConnectionId:e7f52d92-b6f9-44ce-bf3b-f59db61bc613"

Thanks in advance, regards.

Roberto.

Shannon S

Robert,

It seems that there is something wrong with the way you setup your database.

Can you please confirm what version of MS SQL you're running? Please also completely setup the database and user again but using the article step-by-step.

Regards,

Shannon

roberto_bonilla

Hello Shannon,

I'm running MS SQL 2014. It works for other software without problems. I follow several times the step-by-step and always appears the same error.

Is it possible to obtain technical support by remote control with you? I would really appreciate it.

Thanks in advance, regards.

Roberto.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software

database

connection

ms-sql

error