troubleshooting Question

Installing SQL Server 2005 Analysis Services on Windows 2003 Server (Workgroup or Domain?)

Avatar of luiggye
luiggyeFlag for Uruguay asked on
DatabasesMicrosoft SQL Server 2005Windows Server 2003
3 Comments1 Solution1076 ViewsLast Modified:

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,

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros