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?

[Geno]

Happy it worked out. Info provided by Lansweeper sure comes handy with workgroups.

And the gpo logon script, is correct aswell. I have it set exactly the same way. I think it was because with initial testing it showed me errors, and when I did 'echo %logonserver%', I switched to \\fqdn\netlogon aswell.

[gdavid]

Lansweeper,

Thanks for support! this worked perfectly. I really like this application, its very quick and easy to deploy to clients.

Also a note for your GPO logon script. if you have a mix of domain and non domain machines or you login in locally. you may want to change the \\%LOGONSEVER% to \\domain.name ex: \\company.local\netlogon\

\\%LOGONSEVER% gives you the local machine name if you login locally.

--------------------------

Geno, i found your post in google about multi domains under a single forest. thats what prompted me to try this application to begin with. very few apps are friendly to mixed credentials.

--------------------------

Thanks for all the help. this is all working perfectly for me now.

[Geno]

I posted it a while back, but deleted. I figured it was a known problem as I didn't get a reply on my solution nor my suggestion to provide credentials during installation.
The way I did it was Way simple because I have all domains in a forest.
I simply logged in with the domain admin user where my sql server is and installed it without trouble.
This will not work if you have totally different domains.

[Hemoco]

Download http://www.lansweeper.com/debug/srvinstw.zip

Copy your service folder from the working server (with config file) to the domains.
Install the service with srvinstw.exe and choose the correct domain credentials.

[gdavid]

i'm dont completely understand the workaround.

copy/paste the database from where?

this is my goal.
WKRGRPSERVER - www/db/service (already working)
DOMAIN1SERVER - (needs service installed)
DOMAIN2SERVER - (needs service installed)

i'm kind of new to this application as a whole. the only reason i want to do it this way is because i assume after i get this part working. DOMAIN1 machines can use lsclient to send back to DOMAIN1SERVER and the same for DOMAIN2.
which will then send all data back to a central database. and be pretty.

unless of course i can specify the login credentials for each subnet in the application somewhere 🙂

[Hemoco]

I see, this is an installer issue.
The installer tries to connect to the SQL server with NT authentication (I need to fix this)
As a workaround you can copy/paste your database to the sqlserver.
Restore as database Lansweeper32
Create a sql user lssqluser32, password the same as in the config file.
Make the user owner of the Lansweeper32 database.

[gdavid]

my standalone installation of lansweeper on the workgroup machine works fine.

that error is created on the workgroup server when i run the installer on a domain machine to install the lansweeper service.

that error is SOURCE=MSSQL$SQLEXPRESS ID=18452

[Hemoco]

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

Do you get this error in the installer or when starting the service?

[gdavid]

i have my lansweeper service / www / db installed on WRKGRPSERVER
curious why you asked for the config file?

how does it know about the config file? it seems its using the account i log into the domain machines with to create the connection thats failing.

when i'm installing the service on the other domain machines i'm using the installer file that i downloaded from your website. it asks me for the database location in the form of SERVER\INSTANCE
is there another way to install the other parts? should i be installing it from a exe from my current install?

thanks again.

GD