[sims] Discover - Use different credentials for database connection?

[DCUK6]

Our SIMS and Discover server are on another domain,

to get the client installer to validate the databases we had to use

"runas /netonly /user:administrator "C:\program files..."

 

This then allowed us to validate the connection to the server.

 

When i then load up the program however it cant connect to transfer even if i use "runas /netonly ..."

 

Would contact capita but all communication has to go through the LEA and they gave up when it wouldnt validate the settings.

 

Many thanks

 

p.s. it needs to be using windows authentification as they wont give out the SQL sa password.

Edited November 19, 2014 by DCUK6