How to deploy SQL Server 2005 Reporting Services on a network without a domain server?

Posted by ti on Server Fault See other posts from Server Fault or by ti
Published on 2010-02-11T15:35:03Z Indexed on 2010/03/24 12:03 UTC
Read the original article Hit count: 334

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!

© Server Fault or respective owner

Related posts about sql-server

Related posts about active-directory