I am using suiteanalytics connect without problem in our production account, but I wanted to also use it on our sandbox account. Everything is setup the same but I am getting connection errors on the SB. Has anyone managed to get both SB and Prod connected ?

Make sure you have it pointed at the right account links

Checked that so many times and get a connection error each time.

Are you using sb_1 or sb-1 in your connection string? It's sb-1 in all the URLs, but it's easy to forget you need to do the version with the underscore for most other stuff. So assuming you're in Sandbox 1, the account you'd need to use is (Account#)_sb1 assuming you haven't done custom names for your Sandboxes. I've head-desked a few times forgetting that. Usually in SuiteBundler.

We have account number then "-sb1" and we have a second sandbox "-sb2" So "999999-sb1" I've just used a dash in everything. Should I use an underscore somewhere?

All those should have an underscore in place of the dash. The actual account numbers for Sandboxes are (Account)_sb1 if you look at company info in the Sandbox. The dash is used in the URLs because you can't use an underscore. Or I assume that's the case anyway.

I've got it working now, thanks. I needed both the underscores and to use SB1 in uppercase!