I have installed SQL Express 2005 on a Windows 2000 non-domain box, installed the Lansweeper DB and the web service here. Then we are going to install the Service on multiple Win2003/SBS 2003 servers, which are of other domains via IPSEC tunnels.
We got the first tunnel setup, went to install the service, and it kept saying failed to connect. Was able to ping the server "MONITORING" and "MONITORING\SQLEXPRESS" works to install the Service on the same machine as the DB, but I never completed the install as it isnt needed there, and it's Win2000. I put "MONITORING\SQLEXPRESS" in as well, and it says connection failed. We also tried to start the install on another machine in the same network, but these machines are not on a domain (on a workgroup), it also had the same issue to install.
So I got to wondering if this needs to be SQL auth as there are multiple domains involved. I dropped the DB and uninstalled Lansweeper, but when I tried to re-install as SQL auth, it kept failing to connect to database during install. I saw the other post about so I tried both "MONITORING" and "SQLEXPRESS" by themselves, but that didn't work for me. We also have SQL 2000 installed on this same server. When clicking the dropdown though it only sees MONITORING\SQLEXPRESS. I have no issues re-installing as Windows auth if I wanted.
What is the best way to install Lansweeper for multiple services on multiple domains?
Thanks!