Gabe's questions

We have a company we recently acquired and we would like for them to access our SQL Server Analysis Services (via Excel file) on our company's domain. They are external users with separate Windows domains.

I was reading about AD Forest trusts and I don't know if this is the right path. If we set up a trust relationship between the two domains, can I add NewCompany\NewUser to our SSAS security role and they would have access?

It seems like if they're in Azure, following the below would work? https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/identity/adds-forest

The end result I want is:

• for NewCompany\NewUser to refresh the cube/PivotTable in Excel on their PC without having to VPN (this is the key thing)
  • edit: Using a jumpbox would be ok too.

Is this possible and if so, is there a high-level overview of the steps needed? Would I be able to add NewCompany\Sam to SSAS security role, for example?

I'm a software developer so don't know much about infrasture/AD. This is mainly for my curiosity - I don't think we'll implement this. Thanks!

My company uses Windows Server 2016. New company uses Azure AD Services.

Error message is 'd:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied.'

I open SSRS configuration and I do see the service as started and running.

I gave Network Services the necessary permissions in the reportserver folder and config file. SQL Server and SSRS are using LocalSystem as the 'Log On As' in Sql server configuration manager. Most of my sites I googled seem only relevant when it's Network Service running. I changed it to log on as NT Autority\NetworkService but still had the same issue.

In SSRS Config Manager, I see that Web Service Identity is not configured (red), though it is showing as readonly domain\aspnet.

Windows Server 2003 R2 and SSRS 2005

An image server for static images and possibly other static files (css, js, etc). Are they only used for large/popular websites? Secondly, are they only really beneficial when the images undergo some sort of processing (e.g. resizing)? I'm not a server guy, so this is unfamiliar territory for me. I'm working with IIS. Are there major differences if it's done on a subdomain (images.mywebsite.com) on the same server or on another separate machine.

I'm deploying a simple ASP.NET application on IIS 7.5 and I'd like to know what changes I should make or configurations I should check to protect my server.

Will the default settings be secure enough? I'm very much a beginner when it comes to server management so any tips will be very helpful.