RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premium

Hello RS,

Thank you for posting to the SBS Newsgroup.

I understand that you installed SQL Reporting Services on the SBS 2K3 SP1
Server and Visual Studio .Net on my workstation, and now you have many
issues. If I have misunderstood your concern, please let me know.

This is Reporting service issues, this inquiry would best be posted to the
microsoft.public.sqlserver.reportingsvcs Newsgroup. The reason why we
recommend posting appropriately is you will get the most qualified pool of
respondents, and other customers who read the newsgroups regularly can
either share their knowledge or learn from your interaction with us. Thank
you for your understanding.

Windows Sharepoint Services it is by default integrated in the SBS 2003.
The companyweb site is hosted by Windows Sharepoint Services. So I suggest
you that install it back on your server. Please refer to the following KB
article for detail steps:

How to remove and how to install the Windows Small Business Server 2003
SharePoint Services companyweb Web site
http://support.microsoft.com/default.aspx?scid=kb;en-us;829114

Additional information:

Reporting Services Licensing FAQ
http://www.microsoft.com/sql/reporting/howtobuy/faq.asp

SQL Server? 2000 Reporting Services Deployment Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

How to License Reporting Services
http://www.microsoft.com/sql/reporting/howtobuy/howtolicensers.asp

I am greatly appreciated your understanding and cooperation. If you need
any assistance regarding the SBS server, please feel free to post back, I
am glad to be of assistance!

Best regards,

Brandy Nee

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
>Thread-Topic: Difficulty Installing SQL Reporting Services on SBS 2003
Premium
>thread-index: AcWW1NvNKMx6iacnTxScLuTF3+VvmQ==
>X-WBNR-Posting-Host: 69.33.15.242
>From: "=?Utf-8?B?UlM=?=" <RS@xxxxxxxxxxxxxxxxxxxxxxxxx>
>Subject: Difficulty Installing SQL Reporting Services on SBS 2003 Premium
>Date: Mon, 1 Aug 2005 13:09:01 -0700
>Lines: 39
>Message-ID: <746BCC12-7570-4B57-89C5-11698B07F594@xxxxxxxxxxxxx>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:140563
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>I am trying to run reporting services on a SBS 2003 Premium server and
have
>been runninng into a lot of issues.
>
>I have installed the SQL Reporting Services Components on the server and
the
>Visual Studio .Net components on my workstation. The goal behind
installing
>the components in the specified locations include: report authoring on my
>workstation and finished reports available to all via the server.
>
>The issues I have encountered include:
>
>1) SQL Reporting Services activation error due to a conflict with
>Sharepoint. I have removed Sharepoint from the server as outlined in KB
>829114. After completion of the Sharepoint removal, I reinstalled SQL
>Reporting Services and Reporting Services SP2 and was again informed that
>activation was not possible due to a conflict with Sharepoint. How do I
>work around this problem?
>
>2) When accessing SQL Reporting Services from Visual Studio .Net on my
>workstation, I can open an existing project but I can't view content
within
>the data sources tab. When trying to do so I get an error that states:
"A
>connection cannot be made to the database. Set and test the connection
>string. Can't generate the SSPI context. How do I resolve this problem?
>
>3) When creating a new SQL Reporting Services project using the Report
>Wizard, the Shared Data Source field is blank and unavailable. Likewise,
>attempts to access shared data sources using the Server Explorer window
>result in the system prompting for a login when I try to select a listed
in
>the tree under my server. I am unable to login using our available
network
>or SQL User IDs.
>
>My server is running SBS 2003 SP1 which includes SQL 2000 SP4. My
>workstation is a member of the domain for which the server is the PDC.
>
>Is my topology realistic and can my problems resolved or should I relocate
>all components to the server? Even if located on the server, I will still
>encounter the activation problem and need a work around.
>
>Thanks for your help!
>
>

.

Relevant Pages

  • RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
    ... Microsoft CSS Online Newsgroup Support ... >Subject: RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi ... >> you that install it back on your server. ...
    (microsoft.public.windows.server.sbs)
  • Difficulty Installing SQL Reporting Services on SBS 2003 Premium
    ... I have installed the SQL Reporting Services Components on the server and the ... I have removed Sharepoint from the server as outlined in KB ...
    (microsoft.public.windows.server.sbs)
  • RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
    ... I took your advice and posted this issue in the SQL reporting services ... > I understand that you installed SQL Reporting Services on the SBS 2K3 SP1 ... > Windows Sharepoint Services it is by default integrated in the SBS 2003. ... > you that install it back on your server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2000 Reporting Services
    ... SQL reporting services to recognize the SBS default web sight so that it can correctly install!!!!!!!!!!?????????? ... and for further reading on SBS and CRM: ... CRM install the only way to get a free install of this service???? ...
    (microsoft.public.windows.server.sbs)
  • Reporting Services on SBS
    ... they had a separate server for nearly every function, ... So now I'm nearly down to the least amount of necessary servers (SBS, ... Reporting Services hosted on an additional server. ...
    (microsoft.public.windows.server.sbs)