From 0c48fce81f4fa6ed32668417e1af1805b84d31ff Mon Sep 17 00:00:00 2001 From: Koushik Dasgupta Date: Tue, 29 Sep 2015 13:11:03 +0530 Subject: SONAR-6863 Support Integrated Authentication for SQL Server with SonarQube installed in Windows Enabling Integrated Authentication for connecting to MS Sql Server. Default value for sonar.jdbc.username and sonar.jdbc.password have been removed. --- sonar-application/src/main/assembly/conf/sonar.properties | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'sonar-application/src') diff --git a/sonar-application/src/main/assembly/conf/sonar.properties b/sonar-application/src/main/assembly/conf/sonar.properties index e9626756fff..850fe3bd7d4 100644 --- a/sonar-application/src/main/assembly/conf/sonar.properties +++ b/sonar-application/src/main/assembly/conf/sonar.properties @@ -11,8 +11,8 @@ # User credentials. # Permissions to create tables, indices and triggers must be granted to JDBC user. # The schema must be created first. -#sonar.jdbc.username=sonar -#sonar.jdbc.password=sonar +#sonar.jdbc.username= +#sonar.jdbc.password= #----- Embedded Database (default) # It does not accept connections from remote hosts, so the @@ -44,6 +44,13 @@ #----- Microsoft SQLServer 2008/2012 # Collation must be case-sensitive (CS) and accent-sensitive (AS). +#Use the following connection string if you want to use integrated security with MS Sql Server. +#Do not set sonar.jdbc.username or sonar.jdbc.password property if you are using Integrated Auth +#For Integrated Security to work, you have to download the MS SQL JDBC driver package from http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 +#and copy sqljdbc_auth.dll to your path. If you have to copy the 32 bit or 64 bit version of the dll depending upon the architecture of your server machine +#sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar;integratedSecurity=true + +#Use the following connection string if you want to use SQL Auth while connecting to MS Sql Server. Set the sonar.jdbc.username and sonar.jdbc.password appropriately #sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar -- cgit v1.2.3