How to deploy SQL Server 2005 Reporting Services on a network without a domain server?
- by ti
I have a small Windows network (~30 machines) and I need to deploy SQL Server 2005 Reporting Services. Because I use SQL Server Standard Edition and not Enterprise, I am forced to use Windows Authentication to the users.
I am a Linux admin, and have near zero knowledge on Active Directory. As deep as my shallow knowledge goes, I think that I would need to invest in a domain server, a mirrored backup of that domain server. I think that I need to change every computer to use this domain too, and if the domain server goes down, every computer will be unavailable.
Is there a easier way to deploy Windows Authentication so that users can access Reporting Services from their computers without changing the infra-structure that much?
Thanks!