The database URL in the example below assumes a UTF-8 database — i.e. at net.sourceforge.jtds.jdbc.MSSqlServerInfo.
Read the Microsoft documentation for information on how to enable a network protocol (TCP/IP) and how to configure SQL server to listen on a specific port. Installation Notes Configuring IIS with Tomcat Database Notes Database limitations on number of projects JIRA and HSQL Running SQL commands in a HSQL database JIRA and MS SQL Server 2005 Connecting Changing database server to 127.0.0.1 didn't do it, but I'll double-check that the server is configured to listen to post 1433 of 127.0.0.1.Ben SDec 07, 2011Thanks again Dieter! Ensure that the database user has permission to connect to the database, and create and populate tables in the newly-created schema.
Database connection fields Setup Wizard / Configuration Tool dbconfig.xml Description Hostname Located in the
Verify connectivity to your database with help of the JIRA Configuration Tool provided in JIRA versions 4.1 and above. Create an empty 'schema' in the database (e.g. jiraschema ) for the JIRA tables. Before you begin Check whether your version of SQL Server is supported. You should have created this in Step 1 above.
Known issues and troubleshooting Hostnames in permissions are compared as strings- If you grant permission in MySQL to a hostname such aslocalhost, then you must use thesamestring for the connecting to It appears that this UDP request is not being responded to in time (if at all). Set Database Type to MySQL. https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-sql-server-2008-802592183.html The following error appears in the log file: 2010-09-20 15:11:18,678 main ERROR [jira.appconsistency.db.DatabaseConsistencyCheck] There was a SQL exception checking for database driver correctness.
Hide Permalink Bryan Rosander (Inactive) added a comment - 03/Apr/13 12:48 PM - edited 18236 - Making MS SQL SERVER disable port field when instance name specified on 4.4.1 Show Bryan Schema Located in the
Cause When using a named instance, jTDS (the driver used by Java applications to communicate with SQL Server) sends a UDP packet to the server over port 1434 to the SQL This is documented in Sourceforge's jTDS documentation: On SQL Server 2005[and up] the SQL Browser service must be running on the server host as the instance name lookup port UDP 1434 Jira Database Configuration File If you want, a specific port can be assigned to an instance of SQL Server. Jira Supported Platforms XML format for import & export files How to Enable the FishEye Plugin from the Plugin Administration Screen How to Change the Number of Rows Allowed in the Text Type Custom
You will then be able to transfer data from your old database to your new database, as described in Switching databases. http://ascadys.net/jira-error/jira-500-error-after-upgrade.html The default install does not configure the SQL Browser service to start automatically so you must do it manually. Depending on the order how these jars are created and found in the directory it could lead to these problems (most likely). Congratulations, you now have JIRA connected to your SQL Server database. Restart Jira
Instructions for each configuration method JIRA setup wizard The JIRA setup wizardwill display when you access JIRA for the first time in your browser. You should have created this in Step 1 above. It has helped us!CommentAdd your comment...543DieterDec 02, 2011Connection refused definitely means there is no database server listening on localhost:1433 Is your mssql server really configured to listen on port 1433 of Check This Out Was this helpful?
Username Located in the
Collation type must be case-insensitive, accent-insensitive, and language neutralfor example, 'SQL_Latin1_General_CP437_CI_AI' is a case-insensitive, accent-insensitive, and language neutral collation type.
Was this helpful? Test your connection and save. Symptoms The JIRA application is unable to start. Yes No Thanks for your feedback!
Access theQuery Consoleby right clicking on the newly created database and selecting 'New Query'. Congratulations, you now have JIRA connected to your SQL Server database. Read the Microsoft documentation for information on how to enable a network protocol (TCP/IP) and how to configure SQL server to listen on a specific port. this contact form Shut down JIRA before you begin, unless you are running the Setup Wizard.
See Supported platforms. Port Located in the
Restart JIRA. Remember this database user name, as it will be used to configure JIRA's connection to this database in subsequent steps. Please readSurviving connection closuresfor information on how to address this. Shut down JIRA before you begin, unless you are running the setup wizard.
Start JIRA You should now have JIRA configured to connect to your SQL Server database. Maybe it's just listening on the ethernet interface so maybe using the ip address instead of localhost helps please also be aware that specifying localhost as host means that Mssql must Alternatively, you can connect directly to the port used by the named instance. Skip to content Skip to breadcrumbs Skip to header menu Skip to action menu Skip to quick search Linked ApplicationsLoading… Quick Search Help About Confluence Log in Sign up QuestionsTopicsLeaderboardRewardsJIRA
Remember your database name, as it will be used to configure JIRA's connection to this database in subsequent steps. Ensure that the SET NOCOUNT option is not selected: You will also need to access the Server > Properties > Connections > Default Connections properties box and clear the no count Note, the
It wasn't accurate It wasn't clear It wasn't relevant Submit feedback Cancel Have a question about this article? Report a bug Atlassian News Atlassian Atlassian Documentation Log in Documentation Administering JIRA Server Applications 7.1 Installing JIRA applications Connecting JIRA applications to a database Connecting JIRA applications to MySQL Skipping. If you are using a 'recommended' distribution of JIRA, start it up and watch the logs for any errors.