CQ5_5 datasource connection failure for mssql express

[toby444]

What is the connect string for mssql express supposed to be?  there are a lot of conversations around the topic!

Also tried this:

http://docs.day.com/en/home/communique_4/cq42/setup/configuration/dtd_reference/database_connections...
<datasource
    name = "systemDataSource"
  driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"
  url = "jdbc:microsoft:sqlserver://pasadena:1433"
  user="cqdbo"
  password="cqpwd">
</datasource>

It finds the datasource but cannot connect in thr jdbc DriveManager.class.

The mysql datasource is working fine!

I generated the OSGI plugin for mssql jdbc4 from Eclipse luna, installed it in the console datasources and bundles. I also opened  up tcp/ip for mssql  and connect from eclipse.

Thanks

[smacdonald2008 · Accepted solution]

Please refer to this Adobe Community article to learn how to inject a DataSourcePool to connect to a database :

https://helpx.adobe.com/experience-manager/using/datasourcepool.html

Now to connect to another database - replace the configuration shown in this article with required configuraton. To connect to MS SQL Server- see:

https://www.connectionstrings.com/sql-server/

Also - make sure that you package up the Driver file too.