Newbie question about Office version on client machine

Does it matter what version of Office is installed on the clients
machine for opening reports generated by reporting Services?
The reason I am asking is because our users are getting an office
upgrade from 2000 to XP on their machines.No, it does not matter.
"Amit" <amit.gaind@.gmail.com> wrote in message
news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
> Does it matter what version of Office is installed on the clients
> machine for opening reports generated by reporting Services?
> The reason I am asking is because our users are getting an office
> upgrade from 2000 to XP on their machines.
>|||On Mar 20, 10:42 am, "Norman Yuan" <NotR...@.NotReal.not> wrote:
> No, it does not matter.
> "Amit" <amit.ga...@.gmail.com> wrote in message
> news:1174400171.358992.243630@.l75g2000hse.googlegroups.com...
>
> > Does it matter what version of Office is installed on the clients
> > machine for opening reports generated by reporting Services?
> > The reason I am asking is because our users are getting an office
> > upgrade from 2000 to XP on their machines.- Hide quoted text -
> - Show quoted text -
thank you.

Newbie in SQL server 2005

Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.Regards,Anson

SQL Server 2005 Express Edition is the replacement for MSDE & SQL Server Personal Edition.

See the following edition information:

http://www.sqlservercentral.com/columnists/bknight/comparisonofsqlserver2005editions.asp

http://www.microsoft.com/sql/editions/default.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx

-Aaron

|||

Have a look into this link. This contains the minimum requirements for SQL 2005. On having a look into this you can decide which version can be installed on your machine

http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx

Note : For enterprise edition the OS required is Microsoft Windows 2003 server

|||

Best is to use Sql Server 2005 Developer Edition if want to install on Windows Xp and want to use for development...

Satya

Newbie help with joins

I am learning vb.net and ms sql (2000 evaluation version); I can't get my joins to work in Tsql:

select m.lname,m.fname,m.idno,m.payorno,p.payorno.p.payor name
from dbtemp..d_mbrdata m join dbtemp..d_payors p
on (m.payorno = p.payorno)

inner join query returns no records at all. left outerjoin returns the mbrdata fields, but the payors fields show as null. payorno in both tables is type integer and both tables definitely have matching records. I created index for both tables on payorno.

Does anyone have an idea what i am doing wrong here? Thanks.There is nothing wrong with query. If left join returns some data - problem is in second table (matching records).

Just run this query (without join):

select *
from dbtemp..d_mbrdata
where payorno in (select distinct payorno from dbtemp..d_payors)|||Yeah, from the way u'r describing u'r results, it seems there is no m.payorno that is equal to p.payorno.

Maybe u can try debuggin further by inserting a new record into both this tables with a "confirm" identical payorno and do your select join statement again.
It should return 1 joined record.|||Try running this and see what key values are returned:
select m.payorno, p.payorno
from dbtemp..d_mbrdata m
full outer join dbtemp..d_payors p on (m.payorno = p.payorno)
where mpayrono is null or p.payorno is null

blindman

Newbie Advice re: Installing SSRS

Hi, I've decided to install SSRS (2005) on my windows XP machine. I'm not very familiar with IIS (i'm currently using version 5.1) and I think between IIS and SSRS, i've managed to break something.

I've been looking at various articles to try and get some clarity on my predicament. However, i'm not getting any joy with them.s

I have located the logfiles (which I can provide). Unfortunately, I have no idea how to intepret the information contained therein.

Can anyone help?

Many thanks in advance

ClintPlease provide more information. First make sure every tab in the configuration tool is green. Then try to access your report server virtual directory. If there is an error on the web page please copy it here. Also copy the corresponding error in the log files.|||

Hi James, thank you for taking the time to answer me. I will endeavour to provide the information that you requested.

1. The configuration window - This is what i'm getting when I view it.

Picture held on my web site

2. When I try and browse to my Reporting Server (using I.E. 7) with the name http://<servername>/reports this is what I get.

Server Error in '/Reports' Application.

---

The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: The configuration file contains an element that is not valid. The ReportServerUrl element is not a configuration file element.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ThrowInvalidFormat(String element) +41

Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1135

Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32

[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166

Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62

Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296

Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134

Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84

Microsoft.ReportingServices.UI.GlobalApp.Application_Start(Object sender, EventArgs e) +32

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

3. The error logs are very long so if you look at the bottom of the link above, you'll see links to the files. I'm sorry about the crude mechanism to provide the information to you. But I hope you can see access them.

Many thanks

Clint

|||

Can you open your RSWebApplication.config file(%ProgramFiles%\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportManager\RSWebApplication.config) and check the entries for ReportServerUrl and ReportServerVirtualDirectory. You have to specify ONLY one of them and not both.

For example,

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,
Sharmila

|||

Hi Sharmila, thanks for enquiring.

The contents of the configuration file is listed below:

The <servername> has replaced the name of my server.

Many thanks

Clint

-

<Configuration>

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

<Extensions>

<DeliveryUI>

<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">

<DefaultDeliveryExtension>True</DefaultDeliveryExtension>

<Configuration>

<RSEmailDPConfiguration>

<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>

</RSEmailDPConfiguration>

</Configuration>

</Extension>

<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>

</DeliveryUI>

</Extensions>

<Add Key="MaxActiveReqForOneUser" Value="20"/>

<Add Key="DisplayErrorLink" Value="true"/>

</Configuration>

|||

As seen in the config file, you have specified both ReportServerUrl and ReportServerVirtualDirectory. You can specify ONLY one.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Try something like this,

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Hope this helps,

Sharmila

|||

Hi Sharmila, out of interest does specifying both make a difference? You clearly seem to imply that it does, I was just curious to know.

I'm going to try it now.

Regards

Clint

|||

I've just tried it with /reports and got this.

Error

The report server is not responding. Verify that the report server is running and can be accessed from this computer.

Home

I also tried browsing to the /reportserver and got this.

--

Reporting Services Error

---

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||

Can we check a few things?

1. Is RS service running? Is yes, can we restart and also retart IIS.

2. Open the config tool and see if all sections are configured properly as before(in the screenshot you provided).

3. Also, look in the log files to get more info on the internal error.

Thanks,
Sharmila

|||

Hi Sharmila,

I have tried to answer your questions below:

1. I've restarted IIS

2. The configuration tool reports the service states in exactly the same way as my screen shot.

3. The report logs from 19:30 (GMT) are listed below the screenshot. Do you want me to provide the latest logs (22:30)?

Thanks

Clint

|||

Yes, please provide the latest logs.

Thanks,

Sharmila

|||

As an FYI..., there is a similar post that addresses the same issue. - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=251336&SiteID=1

I just noticed that in the RSWebApplication.config, for ReportServerUrl, the Url is missing a "/" for http://. I'm assuming that it is just a typo. Can we just stop the RS service and start it again and also reset IIS.

<UI>

<ReportServerUrl>http:/<servername>/reportserver</ReportServerUrl>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

Thanks,
Sharmila

|||

Hi. I've updated the logs here.

Thanks

Clint

|||

Hi. I've restarted the RS services and IIS and yes it was a typo.

Thank you

Clint

|||Do you have <xmlns=..."> in your web.config (both report server and report manager dir), rsreportserver.config or rswebapplication.config files? If so remove the line.

Newbie - Subscription problem

I know this has probably been asked many many times, but
can someone please help me.
Recently, I installed the evaluation version of RS (and
SP1). I have been trying to test out the subscription
feature, but can't seem to get it working. When I store
the credentials as a Windows login, I get an error
stating that the login failed. If I store the sa login
under the credentials I do not get a login failed error,
but nothing happens. The report is never delivered. Can
anyone tell me how to make subscriptions work?
I am running RS on a Window 2000 server and am trying to
send email through and Exchange 2000 server.
Thanks in advance for your help.When using sa after the subscription fires, what is in the log files? Does
the status of the subscription ever change?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim" <tim@.discussions.microsoft.com> wrote in message
news:2d93d01c46b4b$965ad170$a601280a@.phx.gbl...
> I know this has probably been asked many many times, but
> can someone please help me.
> Recently, I installed the evaluation version of RS (and
> SP1). I have been trying to test out the subscription
> feature, but can't seem to get it working. When I store
> the credentials as a Windows login, I get an error
> stating that the login failed. If I store the sa login
> under the credentials I do not get a login failed error,
> but nothing happens. The report is never delivered. Can
> anyone tell me how to make subscriptions work?
> I am running RS on a Window 2000 server and am trying to
> send email through and Exchange 2000 server.
> Thanks in advance for your help.
>