Lansweeper - multi domain issues

[gdavid]

I read a thread that lansweeper would be able to install in a multidomain enviornment.
I currently manage two different domains and i have a management network that is just a workgroup. I have lansweeper installed web/db/service all on a single non domain machine. i read that you can install the service in each domain and point back to a central sql server. however whenever i try to install the service in either domain, it cant connect to the sql server.

i've enabled remote connections / sql broswer.

l also see these errors in eventvwr on my lansweeper machine.
- SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed.

and

- Login failed for user ''. The user is not associated with a trusted SQL Server connection

how can i specify a user during install? or is there another way?

[gdavid]

<?xml version="1.0" encoding="UTF-8"?>
<configuration><appSettings><add key="ConnectionString" value="Persist Security Info=False;Data Source=WRKGRPSERVER\SQLEXPRESS;Initial Catalog=Lansweeper32;User ID=lssqluser32;Password=mysecretpassword0*"/><add key="ConcurrentThreads" value="20"/><add key="ListenPort" value="9524"/><add key="Activescanning" value="0"/></appSettings></configuration>

[Hemoco]

Could you post your lansweeperservice.exe.config file please.

[gdavid]

Thanks for the reply.
Mixed authentication is already enabled.

from either domain. i am able to create a system DSN to my lansweeper database using the SA account.
however 'of course i get an error when trying to use windows authentication'.

note that when i do use windows authentication in the system DSN, i get the same error that i get when trying to install lansweeper service. it seems the service is using windows authentication only. I read somewhere that sql authentication is for the www. is there some way to force installation using sql authentication? or can i set the lansweeper service to use an ODBC connection?

is there a better way to get to my end goal of monitoring my two domains from a workgroup?

thanks

GD

[Hemoco]

You need to configure your SQL server for mixed authentication.

http://www.hostmysite.com/support/vps/windows/mixedmode/