issue in SQL server database configuration in Rational Team concert 6.0.2 on windows 2012 R2

Hi GUys,

I am trying to configure SQL Server 2012 for Rational Team Concert 6.0.2 as a database on windows 2012 R2 environement.

and after entering the database details and its password it shows me create table process and when I click on create table it triggers following error after a minute or so.

SQL server is set for windows and SQL server authentication, TCP/IP is enabled and Named Pipeline is also enabled. SQL port is on 1433, can somebody help here at what stage I am missing something :(

your help is much appreciated.

Magi

error:

The "com.ibm.team.repository.service.internal.DatabaseCreationRestService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.rdb.IDatabaseStateService", failed to be activated.ID CRJAZ1972E

com.ibm.team.repository.common.transport.TeamServiceRegistryException

com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:384)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:753)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:292)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:301)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getServiceForRemoteAccess(OsgiServicesManager.java:696)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest2(AbstractTeamServerServlet.java:2433)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.handleRequest(AbstractTeamServerServlet.java:2315)
com.ibm.team.repository.servlet.AbstractTeamServerServlet.service(AbstractTeamServerServlet.java:1794)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)
org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:138)
com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1287)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778)
com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:475)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:150)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:93)
com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:165)
com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:198)
com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:207)
com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:1020)
com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1142)
com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:4867)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.handleRequest(DynamicVirtualHost.java:297)
com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:997)
com.ibm.ws.webcontainer.osgi.DynamicVirtualHost$2.run(DynamicVirtualHost.java:262)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink$TaskWrapper.run(HttpDispatcherLink.java:955)
com.ibm.ws.http.dispatcher.internal.channel.HttpDispatcherLink.ready(HttpDispatcherLink.java:341)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:470)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.handleNewRequest(HttpInboundLink.java:404)
com.ibm.ws.http.channel.internal.inbound.HttpInboundLink.processRequest(HttpInboundLink.java:284)
com.ibm.ws.http.channel.internal.inbound.HttpICLReadCallback.complete(HttpICLReadCallback.java:66)
com.ibm.ws.channel.ssl.internal.SSLReadServiceContext$SSLReadCompletedCallback.complete(SSLReadServiceContext.java:1766)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.requestComplete(WorkQueueManager.java:504)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.attemptIO(WorkQueueManager.java:574)
com.ibm.ws.tcpchannel.internal.WorkQueueManager.workerRun(WorkQueueManager.java:929)
com.ibm.ws.tcpchannel.internal.WorkQueueManager$Worker.run(WorkQueueManager.java:1018)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1157)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:627)
java.lang.Thread.run(Thread.java:809)

Caused by:

The "com.ibm.team.repository.service.internal.rdb.DatabaseStateService" service failed to activate because a service that it depends on, "com.ibm.team.repository.service.internal.schemagen.IPersistentMappingService", failed to be activated. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1972E

com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.buildServicesMap(AbstractActivationManagerOwner.java:384)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:753)
com.ibm.team.repository.common.transport.internal.registry.ServiceProviderActivationManagerOwner.getService(ServiceProviderActivationManagerOwner.java:133)
com.ibm.team.repository.common.transport.internal.registry.OsgiServicesManager.getService(OsgiServicesManager.java:292)
 ... 48 more.

Caused by:

The "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" feature could not start. (com.ibm.team.repository.common.transport.TeamServiceRegistryException)ID CRJAZ1092E

com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:303)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.performActivation(AbstractActivationManagerOwner.java:704)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.doActivate(AbstractActivationManagerOwner.java:766)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.activate(AbstractActivationManagerOwner.java:212)
 ... 104 more.

Caused by:

The system schema could not be created. (java.lang.RuntimeException)ID CRJAZ0820E

com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:128)
com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:92)
com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:195)
com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:297)
 ... 107 more.

Caused by:

!SqlServerProvider.SqlServerVersionNotValid! (com.ibm.team.repository.common.TeamRepositoryException)

com.ibm.team.repository.jdbcdriver.internal.sqlserver.SqlServerProvider.assertRequiredVersion(SqlServerProvider.java:601)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.assertRequiredVersion(AbstractDbProvider.java:1608)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1667)
com.ibm.team.repository.service.db.provider.AbstractDbProvider.checkDbVersion(AbstractDbProvider.java:1660)
 ... 126 more.

Restore to Saved Test Connection