Hi Victor,
installed the module and it works fine in main site. but on subsites it says access denied when i click on In Site Analytics icon in admin dashboard, what i'm missing?
Are you logged in as admin in the child site? It works for me. I copied the /Data/Sites/1/supplementaladminlinks folder to the other sites under /Data/Sites/[SiteID/
You should be able to set the account id the same in Site Settings of each site under the API Keys tab you enter the main account id in the box labelled "Google Analytics Account Code" so that everything is tracked to your main account.
Then in In Site Analytics in the child sites if your are signed in as admin you should be able to go into Analytics Configuration in each child site and set the profile id you want to track as well as set roles allowed to access it.
When using a separate database for In Site Analytics you have to run the scripts manually on the second database because the setup page can only run scripts against the main database. So the setup page is going to install the tables and procs in the main db in any case but they won't be used if you set a different connection string for In Site analytics. So the schema version table is not really a factor, it affects only the things installed in the main db but has no knowledge of the other db used by In Site analytics. If it shows errors on the setup page installing into the main db you can just ignore them since you are using a separate db.
Hope that helps,
Joe