RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
- From: v-branee@xxxxxxxxxxxxxxxxxxxx ("Brandy Nee [MSFT]")
- Date: Thu, 18 Aug 2005 01:31:49 GMT
Hello RS,
Thank you for posting back!
I still suggest you that post your issue to the
microsoft.public.sqlserver.reportingsvcs Newsgroup, and see whether the MVP
or the other regular customers can share some experience with you. Or you
can Microsoft Product Support Services via telephone so that a dedicated
Support Professional can assist with your request. Please be advised that
contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
Thanks a lot for your understanding!
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
Premi
>thread-index: AcWjWuQ5g/DK2AavRZmrEkhJXK6R/A==
>X-WBNR-Posting-Host: 69.33.3.136
>From: "=?Utf-8?B?UlM=?=" <RS@xxxxxxxxxxxxxxxxxxxxxxxxx>
>References: <746BCC12-7570-4B57-89C5-11698B07F594@xxxxxxxxxxxxx>
<A75J5KxlFHA.940@xxxxxxxxxxxxxxxxxxxxx>
>Subject: RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
>Date: Wed, 17 Aug 2005 11:38:42 -0700
>Lines: 160
>Message-ID: <1157F93D-1F5D-499C-A499-685CBF421CCF@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:145287
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>Hi Brandy,
>
>I took your advice and posted this issue in the SQL reporting services
>forum, unfortunately no one there is interested in responding. I'm
looking
>for assitance through other channels but would appreciate any additional
>ideas you may have.
>
>Thanks,
>
>RS
>
>""Brandy Nee [MSFT]"" wrote:
>
>> 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!
>> >
>> >
>>
>>
>
.
- References:
- Prev by Date: Re: Cannot setup SQL Mail on SBS 2003
- Next by Date: BAD_POOL_CALLER
- Previous by thread: RE: Difficulty Installing SQL Reporting Services on SBS 2003 Premi
- Next by thread: Internet group not allowing internet access to user
- Index(es):
Relevant Pages
|
Loading
