Lansweeper cross database view permissions problem

[dave2318]

Hi all,
I have created a cross database view that works int he lansweeper configuration utility but not in the lansweeper site due to permission problems.
in the service and web conf files i can see it's configured to use lansweeperuser as the user.
How do i change this to the active directory user that has the permissions on both databases?

Thanks in advance.

[dave2318]

Cool. very usefull information. Thanks!

[Hemoco]

In sql you can map user "lansweeperuser" to an active directory user.

You can use something similar to this:

EXEC sp_addlinkedsrvlogin 'ADSI', False, 'lansweeperuser','admin_account', 'admin_account_password'