Newbie question on Reporting Services

The shop I work in is new to SQL Server and this fall we are installing
Sql Server 2005 with Reporting Services. Apparently the application the
database will support will use Reporting Services. A question is
arising on whether the created report(s) is considered a database
object. That is, if one creates and saves off a report in Test, is this
report migrated to production or is the same object in the same
location simply used by production?
Many thanks in advance.
GerryYou deploy reports to the server. If you have a test server and a
development server, the best is to deploy it to test and then when you are
ready, deploy it to production. Reporting services stores the report
metadata in the database. RS is an asp.net application that heavily uses the
database for its object/metadata storage, scheduling etc.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<datapro01@.yahoo.com> wrote in message
news:1156342425.017659.314250@.74g2000cwt.googlegroups.com...
> The shop I work in is new to SQL Server and this fall we are installing
> Sql Server 2005 with Reporting Services. Apparently the application the
> database will support will use Reporting Services. A question is
> arising on whether the created report(s) is considered a database
> object. That is, if one creates and saves off a report in Test, is this
> report migrated to production or is the same object in the same
> location simply used by production?
>
> Many thanks in advance.
> Gerry
>|||Thanks Bruce
Bruce L-C [MVP] wrote:
> You deploy reports to the server. If you have a test server and a
> development server, the best is to deploy it to test and then when you are
> ready, deploy it to production. Reporting services stores the report
> metadata in the database. RS is an asp.net application that heavily uses the
> database for its object/metadata storage, scheduling etc.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <datapro01@.yahoo.com> wrote in message
> news:1156342425.017659.314250@.74g2000cwt.googlegroups.com...
> > The shop I work in is new to SQL Server and this fall we are installing
> > Sql Server 2005 with Reporting Services. Apparently the application the
> > database will support will use Reporting Services. A question is
> > arising on whether the created report(s) is considered a database
> > object. That is, if one creates and saves off a report in Test, is this
> > report migrated to production or is the same object in the same
> > location simply used by production?
> >
> >
> > Many thanks in advance.
> > Gerry
> >

Newbie Question

After having problems with my first attempt at installing Reporting Services, I did some reading, found the answers I needed and did a re-install. Everything worked fine, however, I did not delete the original web sites from the first install (called Reports and ReportServer) and when I did the re-install then the new sites created were Reports1 and ReportServer1. Is there anyway to rename those to Reports and ReportServer in IIS and then re-configure RS to point to them? I did see a parm for URLRoot which points to ReportServer1 but did not find anything which points to Reports1. Of course, I suppose I could go through another re-install but I would rather not. Thanks in advance for any help!
DaveYou need to change the URLRoot that you mentioned as well as ReportServerUrl
element in RSWebApplication.config. There are also some registry settings
that need to change. I don't remember them off hand, but search for Report1
and ReportServer1 and you should find them.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BD7C402E-745D-4FF2-9677-B547367A5365@.microsoft.com...
> After having problems with my first attempt at installing Reporting
Services, I did some reading, found the answers I needed and did a
re-install. Everything worked fine, however, I did not delete the original
web sites from the first install (called Reports and ReportServer) and when
I did the re-install then the new sites created were Reports1 and
ReportServer1. Is there anyway to rename those to Reports and ReportServer
in IIS and then re-configure RS to point to them? I did see a parm for
URLRoot which points to ReportServer1 but did not find anything which points
to Reports1. Of course, I suppose I could go through another re-install but
I would rather not. Thanks in advance for any help!
> Davesql

Newbie Alert !

Dear Folks,

First time here.

Have just installed a 120-day evaluation copy of MSSQL 2000.

In the 'blur' and confusion of installing this on my WinXP Laptop, I
forgot to record the password.

Finally, I got into the 'logins' tab on the Enterprise Manager, and
modified the 'sa' password to 'ivlem1', and I think it was recorded
properly.

I tried to test my installation with the following at the Command
Prompt:

osql /Usa /P ivlem1

It failed saying I wasn't 'Trusted'

I would appreciate any help offered !

TIA,

-Mel SmithDid you select "mixed" mode for authentication. I would test this
differently...fire up QA and use your SA account/passwd to account.
There are too many things that could go wrong with establishing a
connection using osql.

HTH

MJKulangara
http://sqladventures.blogspot.com|||Mel Smith (medsyntel@.aol.com) writes:
> Have just installed a 120-day evaluation copy of MSSQL 2000.
> In the 'blur' and confusion of installing this on my WinXP Laptop, I
> forgot to record the password.
> Finally, I got into the 'logins' tab on the Enterprise Manager, and
> modified the 'sa' password to 'ivlem1', and I think it was recorded
> properly.
> I tried to test my installation with the following at the Command
> Prompt:
> osql /Usa /P ivlem1
> It failed saying I wasn't 'Trusted'

SQL Server have to means of authentication: Windows authentication (a.k.a
Integrated Security or Trusted Connection) and SQL Server authentication.
Windows authentication is always there, SQL authentication is optional,
and usually referred to as "mixed mode".

Windows authentcation means that you log into SQL Server with your
Windows credentials. This is very simple, you just say "osql /E" and
you are on the air. No need for password, as you are already logged
into Windows.

By default, only Windows authentication is enabled. This is because
SQL Server authentication is less secure. However, many enable
SQL authentiation for various reasons. For instance, if you are a
developer you may work with Windows authentication as long as you
develop and have sysadmin rights. But when you need to test, you
want a low-priv user, and testing different users is much easier
with SQL authentication.

You can change authentication mode from Enterprise Manager. Right-
click the server, select Properties, and then use the Security tab.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland and MJK,

Thank you both for your advice !

Erland:

I tried "osql /E" and it worked ! (i.e., I got correct correct results
for the two queries: select @.@.servername and select @.@.version)

(now I'm going to go blind reading all there is on Books Online to get
myself up to speed )

btw, I'm fairly expert in xBase databases (my job is tech support for a
structural steel company that uses my software, but is now moving to MSSQL)
and I have to show that I'm up to the task to help them make that move. In
fact, they have purchased AccPac for Windows, and have installed MSSQL 2000.
But I'm at a remote location from the headquarters of this company and must
get used to MSSQL all by myself in the 'sunny south'.

Thanks again.

-Mel Smith
Mesa, Arizona, USA

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.

newbe to SQL2005 & MSDE

HELP!!
having on trouble installing, just gettting everything connected.
(xp sp2)
First i loaded MSDE, then realized i needed the web admin tool to create the db...but can't get the web admin tool to connnect to anything..
so I took a stab at SQL 2005 Std ed beta....loaded fine, but then realized i need another admin tool to create db so I loaded the xpress manager...again, loads fine, but doesnt'connec to any DB..
why is this so difficult for me....SQL Svr v6 was so much easier with enterprise manager!!!
HELP!!
DonDon, what do you mean by "the web admin tool"? The utility that comes with Visual Studio .NET 2005?
Can you explain what you mean by "but doesn't connect to any DB."? Are you receiving any error messages?