SQL Server Performance

reporting services and Virtual sql2005 Cluster

Discussion in 'SQL Server 2005 Clustering' started by colinr, Apr 5, 2007.

  1. colinr New Member

    Following advice else where on the site I understand its not wise to install reportingservices on the sql 2005 clustered Virtual Server nodes. This raises the Question What is the best way to configure reporting services in the virtual environment ?

    Currently I have a Virtual domain controller,Node1 and Node2 with Sql2005 installed to the cluster



  2. satya Moderator

    For the production environment it is not recommended, so what is your requirement.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. MohammedU New Member

  4. colinr New Member

    my requirement is for A portable development server I have a high spec laptop i use, Im a contract SQL dba and use the laptop for both sql devlopment and as a prototype to demo what sql is capeable of. The faster it runs on my pc the better.

    The spec is centrino duo 2gig, twin scsci drives 60 gb, and 2 gb of ram so its pretty capeable.

    currently its running vista, visual studio dev, IIS locally, virtual server 2005 is installed with a recently installed sql2005 server cluster as per brads video demonstation. Ram Utilisation is currently about 60% with this running

    So ideally I need the local visual studio developing reports and RS somewhere to host them with the host os Accessing the reports via IE.

    That should about do it. Squeezing in Analysis Services may well be a tall order.

    Cheers

    Colin R













    quote:Originally posted by satya

    For the production environment it is not recommended, so what is your requirement.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. satya Moderator

    Then it can be deployed and follow the link suggested by Mohammed as it suits.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page