Thierry, If the DB can only accessed by this one account, and that account doesn't support interactive login, then I think it will be impossible to access the DB from TopBraid Composer.
It could be accessed from TopBraid Live by installing TBL into a Tomcat instance running under the service account, and using JDBC integrated security instead of username and password. This will however be rather difficult to achieve without being able to first create and test the D2RQ connector in an interactive environment. My recommendation would be to relax the access restriction on the database. Best, Richard > On 25 Mar 2016, at 10:18, Thierry VEBR <[email protected]> wrote: > > Hi Richard, > > Windows Services Account have usernames and passwords, but can not be used > interactively. > Typically you start a service under a specific Windows Service Account and > then its credentials are sent automatically to SQL server. > These accounts are machine-to-machine transactions. > > Le jeudi 24 mars 2016 13:31:56 UTC+1, Thierry VEBR a écrit : >> Hello, >> >> I would like to import an SQL database with D2RQ ; the specificity of this >> database is that it can be accessed only by a precise Windows Service >> Account ; so the usual way using a connection string with a Database >> username and password does not work. >> >> What would be the solution to make this import work (if any), both on TB >> Composer and TB Live ? >> >> Thierry Vebr >> OECD. > > -- > You received this message because you are subscribed to the Google Group > "TopBraid Suite Users", the topics of which include Enterprise Vocabulary > Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid > Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. > To post to this group, send email to [email protected] > --- > You received this message because you are subscribed to the Google Groups > "TopBraid Suite Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), Reference Data Manager (RDM), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected] --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
