I will install a Windows 2003 Server Enterprise Edition with SP2.
I will install a Sql Server 2005 SP2 including the Analysis Services and all the others services, with all the tools and examples on that Windows 2003 Server.
I have a notebook (client) with a Windows XP HOME SP3.
I want to connect my notebook as client with the remote Analysis Services on the Windows 2003 Server using my LAN.
Here my questions:
1) The Windows 2003 Server can be a Workgroup or it must be a Domain Controller?
2) What user account I must to set for the SQL Server Database Services, Analysis services, Reporting Services, Notification Services, Integration Services and Browse Services, in order to allow remote connections? (Domain User, Local System, Network Service, Local Service, etc.).
3) My XP Home will be able to connect to the remote Analysis Services on the Windows 2003 Server, or I will need to upgrade to XP Professional?
(I know that the XP Home Edition can not be joining to a domain).
I will appreciate any comments about it.
Thanks in advance,