Database connection issues

[Iryna Pazharytskaya]

Hello,

Currently we are trying to connect Jira to our sql server data base through the ScriptRunner "Database connecion" option.

Is there anything I am doing wrong or any furher configurations are needed in order to perform the connection? 

Thank you in advance.

Best,

Iryna

[Benjamin]

Hi @Iryna Pazharytskaya ,

The error message received is about the login. Might want to double check if the login that is configure is indeed correct.

Also, the JDBC URL does look like it is in the correct format for Microsoft SQL. It should be something like below:

jdbc:sqlserver://[serverName[\instanceName][:portNumber]]

Example - jdbc:sqlserver://localhost;encrypt=true;database=jiradb

-Ben

[Iryna Pazharytskaya]

Hi @Benjamin ,

I didnt use  the encrypt=true part. After adding it

[Iryna Pazharytskaya]

Above I described the error I get when I added encrypt=true part. 

Also the user  name has "\$" special carachter. Do you think  this  could be the poblem?

I confirmed with the database administrator the  password and the user name as correct.

Best,

Iryna

[Benjamin]

Hi @Iryna Pazharytskaya ,

The error message for the encrypt=true part is likely correct. Its giving that message because when you enable encryption, the certificates must be setup to establish a secure connection.

I'm thinking also likely to do with the special character since the username and password mentioned is correct. Are you able to try another user without any special characters?

-Ben

[Iryna Pazharytskaya]

Hi @Benjamin

Yes, indeed it was due to the special characters within the password and the user name. New credentials with

& | ! ( ) { } [ ] ^ ~ * ? \ : excluded let me connect.

Best,

Iryna