Need to change a table name from all sp's

Hey guys. I've a few sp's. This sp's are doing some inserts and updates in a
table
I need to setup a job to run every4 hours. And at
at 12 am, it's supposed to insert in table1
at 4 am, it's supposed to insert in table2 and truncate table1.
at 8 am, it's supposed to insert in table1
Please help me on writing this script. I can get the table name from
sysobjects and the text from sysomments but haven't reached farther than
that. Can someone think of a way to do this? Thank you..."Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:6B9DF2A1-0509-453E-9BC8-FD40A378DDF0@.microsoft.com...
> Hey guys. I've a few sp's. This sp's are doing some inserts and updates in
> a
> table
> I need to setup a job to run every4 hours. And at
> at 12 am, it's supposed to insert in table1
> at 4 am, it's supposed to insert in table2 and truncate table1.
> at 8 am, it's supposed to insert in table1
> Please help me on writing this script. I can get the table name from
> sysobjects and the text from sysomments but haven't reached farther than
> that. Can someone think of a way to do this? Thank you...
Why not setup 3 separate jobs, each that run once a day.
Job 1 at 12 am
Job 2 at 4 am
Job 3 at 8 am|||because the table being created is called by another stored proc. This store
d
proc is called by a report. That's why.|||"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:BF02A629-DFB7-44DD-9341-80B0D458C3B8@.microsoft.com...
> because the table being created is called by another stored proc. This
> stored
> proc is called by a report. That's why.
I don't understand what you're doing here.|||This is what's happening.
There is a report being accessed from a website. This report accesses a sp.
This sp has a select query inside it which goes to some tables and gets the
stuff. The table name I need to change is one of these tables. But as i said
in the first part, i need to update this table all the time and start from
scratch WITHOUT DOWN TIME. That's y i need to do wut i asked. Now, u think
there is a way where i can run a script to change these sp's so, that they
reflect different table name every 4 hours? Thank you.|||Based on your narrative it is hard to understand what you are trying to
accomplish.
On a cursory inspection, you are attempting something which normal
developers in general circumstances would not do. Can you elaborate you
requirements perhaps with a repro? Please refer to www.aspfaq.com/5006 for
more details on how you can present more information for others to help you.
Anith|||Allright, I'll paste part of the sp here. I really dont know what you guys
wnat me to paste here since my concern is with 5 sp's. instead of manually
going and replacing the names of a table, i want a script that would change
the names of a table.
Anyways, I'm pasting part of the script here...
----
--
ALTER Procedure
[dbo].[Report_PopulateTable_ITAssetComponent]
/* Input parameter to specify the user language ID */
@.inLanguageID int
AS
/* Getting Fixed ITAsset Components*/
SELECT ta.itassetobjectid as ItAssetObjectID,
ta.OrgUnitID as OrgUnitID,
OU.ObjectName as theOrgUnitName,
DO.ObjectName as theAssetName,
DA.SerialNumber as theSerialNumber,
DA.Manufacturer as theManufacturer,
DA.ModelNumber as theModelNumber,
DITT.ITAssetTypeName as theITAssetTypeName,
DIA.OSServicePack as theOSServicePack
into #FixedITAsset
FROM datObjects OU
join datObjects DO (nolock) on OU.ObjectID = DO.parentObjectID
join datAssets DA (nolock) on DO.ObjectID = DA.AssetObjectID
join datITAssets DIA (nolock) on DA.AssetObjectID= DIA.ITAssetObjectID
join ##tempassets ta (nolock) on DIA.ITAssetObjectID =
ta.itassetobjectid
join defITAssetTypes DITT (nolock) on DITT.ITAssetTypeID
=DIA.ITAssettypeID
WHERE
DO.parentObjectID =
(SELECT ParentObjectid FROM datObjects WHERE ObjectID =
DIA.ITAssetObjectID)
/*Get OrgUnit Name as per the Language and insert in the work table*/
SELECT @.theComponentName = string
FROM datStrings WHERE StringID=1226 AND LanguageID=@.inLanguageID
INSERT INTO DatStdItAssetComponents
(OrgUnitID,itassetobjectid,AssetName,Col
umnName,Value,LanguageID)
select
OrgUnitID,ITAssetObjectID,theAssetName,'
4271',theOrgUnitName,@.inLanguageID
from #FixedITAsset
----
--
That's an example of what's happening. This sp is about 7 pages long and
there are a few like these. Do you see where it says
'DatStdItAssetComponents'? I've to replace that with DatStdItAssetComponents
1
after 4 hours from now and back to 'DatStdItAssetComponents' 8 hours from
now. Keep alternating between the two table names. I've pasted only one
insert statement here but there are a lot more.
My point is to rplace the table name with another table name every 4 hours
by a SCRIPT. Thank you.|||"Tejas Parikh" <TejasParikh@.discussions.microsoft.com> wrote in message
news:A07841F1-E18F-47E9-9E01-68FF441747AB@.microsoft.com...
> Allright, I'll paste part of the sp here. I really dont know what you guys
> wnat me to paste here since my concern is with 5 sp's. instead of manually
> going and replacing the names of a table, i want a script that would
> change
> the names of a table.
> Anyways, I'm pasting part of the script here...
> ----
--
> ALTER Procedure
> [dbo].[Report_PopulateTable_ITAssetComponent]
> /* Input parameter to specify the user language ID */
> @.inLanguageID int
> AS
> /* Getting Fixed ITAsset Components*/
> SELECT ta.itassetobjectid as ItAssetObjectID,
> ta.OrgUnitID as OrgUnitID,
> OU.ObjectName as theOrgUnitName,
> DO.ObjectName as theAssetName,
> DA.SerialNumber as theSerialNumber,
> DA.Manufacturer as theManufacturer,
> DA.ModelNumber as theModelNumber,
> DITT.ITAssetTypeName as theITAssetTypeName,
> DIA.OSServicePack as theOSServicePack
> into #FixedITAsset
> FROM datObjects OU
> join datObjects DO (nolock) on OU.ObjectID = DO.parentObjectID
> join datAssets DA (nolock) on DO.ObjectID = DA.AssetObjectID
> join datITAssets DIA (nolock) on DA.AssetObjectID= DIA.ITAssetObjectID
> join ##tempassets ta (nolock) on DIA.ITAssetObjectID =
> ta.itassetobjectid
> join defITAssetTypes DITT (nolock) on DITT.ITAssetTypeID
> =DIA.ITAssettypeID
> WHERE
> DO.parentObjectID =
> (SELECT ParentObjectid FROM datObjects WHERE ObjectID =
> DIA.ITAssetObjectID)
> /*Get OrgUnit Name as per the Language and insert in the work table*/
> SELECT @.theComponentName = string
> FROM datStrings WHERE StringID=1226 AND LanguageID=@.inLanguageID
> INSERT INTO DatStdItAssetComponents
> (OrgUnitID,itassetobjectid,AssetName,Col
umnName,Value,LanguageID)
> select
> OrgUnitID,ITAssetObjectID,theAssetName,'
4271',theOrgUnitName,@.inLanguageID
> from #FixedITAsset
> ----
--
> That's an example of what's happening. This sp is about 7 pages long and
> there are a few like these. Do you see where it says
> 'DatStdItAssetComponents'? I've to replace that with
> DatStdItAssetComponents1
> after 4 hours from now and back to 'DatStdItAssetComponents' 8 hours from
> now. Keep alternating between the two table names. I've pasted only one
> insert statement here but there are a lot more.
> My point is to rplace the table name with another table name every 4 hours
> by a SCRIPT. Thank you.
Strange requirements but what do I know...
Why not just create a job that alters the stored procedure?
Look up Alter Procedure in Books Online.
You would need 2 jobs.
Job 1 runs at 4, job 2 runs at 8, job 1 runs at 12...|||Hello Tejas,
I am sure there is a better way ... but you could pass in the table name
as a variable into the stored procedure. You will then need to create all
your inserts etc. dynamically using that variable as your table name.
Hope that helps,
Sandeep

> Allright, I'll paste part of the sp here. I really dont know what you
> guys
> wnat me to paste here since my concern is with 5 sp's. instead of
> manually
> going and replacing the names of a table, i want a script that would
> change
> the names of a table.
> Anyways, I'm pasting part of the script here...
> ---
> --
> ALTER Procedure
> [dbo].[Report_PopulateTable_ITAssetComponent]
> /* Input parameter to specify the user language ID */
> @.inLanguageID int
> AS
> /* Getting Fixed ITAsset Components*/
> SELECT ta.itassetobjectid as ItAssetObjectID,
> ta.OrgUnitID as OrgUnitID,
> OU.ObjectName as theOrgUnitName,
> DO.ObjectName as theAssetName,
> DA.SerialNumber as theSerialNumber,
> DA.Manufacturer as theManufacturer,
> DA.ModelNumber as theModelNumber,
> DITT.ITAssetTypeName as theITAssetTypeName,
> DIA.OSServicePack as theOSServicePack
> into #FixedITAsset
> FROM datObjects OU
> join datObjects DO (nolock) on OU.ObjectID = DO.parentObjectID
> join datAssets DA (nolock) on DO.ObjectID = DA.AssetObjectID
> join datITAssets DIA (nolock) on DA.AssetObjectID=
> DIA.ITAssetObjectID
> join ##tempassets ta (nolock) on DIA.ITAssetObjectID =
> ta.itassetobjectid
> join defITAssetTypes DITT (nolock) on DITT.ITAssetTypeID
> =DIA.ITAssettypeID
> WHERE
> DO.parentObjectID =
> (SELECT ParentObjectid FROM datObjects WHERE ObjectID =
> DIA.ITAssetObjectID)
> /*Get OrgUnit Name as per the Language and insert in the work table*/
> SELECT @.theComponentName = string
> FROM datStrings WHERE StringID=1226 AND LanguageID=@.inLanguageID
> INSERT INTO DatStdItAssetComponents
> (OrgUnitID,itassetobjectid,AssetName,Col
umnName,Value,LanguageID)
> select
> OrgUnitID,ITAssetObjectID,theAssetName,'
4271',theOrgUnitName,@.inLangua
> geID
> from #FixedITAsset
> ---
> --
> That's an example of what's happening. This sp is about 7 pages long
> and there are a few like these. Do you see where it says
> 'DatStdItAssetComponents'? I've to replace that with
> DatStdItAssetComponents1 after 4 hours from now and back to
> 'DatStdItAssetComponents' 8 hours from now. Keep alternating between
> the two table names. I've pasted only one insert statement here but
> there are a lot more.
> My point is to rplace the table name with another table name every 4
> hours by a SCRIPT. Thank you.
>|||On Thu, 26 Jan 2006 15:17:02 -0800, Tejas Parikh wrote:

>Allright, I'll paste part of the sp here. I really dont know what you guys
>wnat me to paste here since my concern is with 5 sp's. instead of manually
>going and replacing the names of a table, i want a script that would change
>the names of a table.
Hi Tejas,
Maybe it's just me, but I honestly don't understand why you can't make
two copies of the stored procedure, then set up a job to run the first
at for instance 4AM, noon, 8PM and the second at midnight, 8AM, 4PM.
Self-modifying code is maintenance hell.
Hugo Kornelis, SQL Server MVP

Need support/help to setup replication

Hello,
Anybody know who I might call to pay for help setting up replication. I am
under a time constraint.
Rick Rushing
System Administrator
D & J Construction
What type of replication, and how long do you have?
Describe the scenario please :-)
I am available by the hour or by the minute...
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
www.experts-exchange.com - experts compete for points to answer your
questions
"Rick Rushing" <RickRushing@.discussions.microsoft.com> wrote in message
news:0EBE4237-238C-48DD-AA7C-E9096AC4B9C4@.microsoft.com...
> Hello,
> Anybody know who I might call to pay for help setting up replication. I am
> under a time constraint.
> --
> Rick Rushing
> System Administrator
> D & J Construction
|||Rick,
where abouts are you geographically? If in the UK or you're happy working
remotely, please drop me a line - email address at
www.replicationanswers.com.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Need some help with a query

Hello everyone, I have a table that is setup to record a page of web
form elements. The form elements are dynamically created. Each page
contains x number of questions. (x depends on many different things
There are 4 pages. Since we never know how many form elements are on
the page, the DB was design as such
GroupID int
PageID int
QuestionID int
FormElementID int
FormElementValue varchar(500)
The problem is when trying to grab a combination of forms to display in
a report I have to write a query like this (let's assume I am trying to
grab all records that have $5/10 years) On page 1, question 4, the
form element 1 is the dollar amount and the form element 2 is the
number of years.
SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
FormElementID=1 AND FormElementValue=5 AND GroupID IN (SELECT GroupID
from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
FormElementValue=10)
This works fine. My problem is when I have to grab all other
combinations. So let's say my client wants $5/10 years, $10/15 years,
$15/20 years and all other combinations as four distinct numbers. How
can I accomplish this? Currently I am doing this (which I know is poor
as it just looks wrong and takes forever to run.
SELECT GroupID FROM thistable WHERE GroupID NOT IN (
SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
FormElementID=1 AND FormElementValue=5 AND GroupID IN (SELECT GroupID
from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
FormElementValue=10)
AND GroupID NOT IN (
SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
FormElementID=1 AND FormElementValue=10 AND GroupID IN (SELECT GroupID
from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
FormElementValue=15)
AND GroupID NOT IN (
SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
FormElementID=1 AND FormElementValue=15 AND GroupID IN (SELECT GroupID
from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
FormElementValue=20)
Let me know if you have any ideas, thanks for your help in advance
(please note that I wrote the script above based on my real script, I
can't display the exact real code, but above is very close.night_day (night_day_8@.yahoo.com) writes:
> This works fine. My problem is when I have to grab all other
> combinations. So let's say my client wants $5/10 years, $10/15 years,
> $15/20 years and all other combinations as four distinct numbers. How
> can I accomplish this? Currently I am doing this (which I know is poor
> as it just looks wrong and takes forever to run.
> SELECT GroupID FROM thistable WHERE GroupID NOT IN (
> SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
> FormElementID=1 AND FormElementValue=5 AND GroupID IN (SELECT GroupID
> from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
> FormElementValue=10)
> AND GroupID NOT IN (
> SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
> FormElementID=1 AND FormElementValue=10 AND GroupID IN (SELECT GroupID
> from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
> FormElementValue=15)
> AND GroupID NOT IN (
> SELECT GroupID FROM thistable WHERE PageID=1 and QuestionID=4 AND
> FormElementID=1 AND FormElementValue=15 AND GroupID IN (SELECT GroupID
> from thistable WHERE PageID=1 AND Question_ID=4 AND FormElementID=2 AND
> FormElementValue=20)
You should be able to sort this out, if you learn to master EXISTS/NOT
EXISTS. I show example with your first query to get you going:
SELECT t1.GroupID
FROM thistable t1
WHERE t1.PageID=1
and t1.QuestionID=4
AND t1.FormElementID=1
AND t1.FormElementValue=5
AND EXISTS (SELECT *
from thistable t2
WHERE t2.PageID=1
AND t2.Question_ID=4
AND t2.FormElementID=2
AND t2.FormElementValue=10
AND t1.GroupID = t2.GroupID)
The point here is that you may not need multiple subqueries, but could
then use OR conditions.
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|||Hi Erland,
Thank you for your response. I've spend some time converting my
original query to use EXISTS, I can now generate the same output using
a version running NOT EXISTS as my current NOT IN statements.
Unfortunately, I've run the 2 queries in query analyzer and the NOT
EXISTS statements takes 12 seconds whereas my current NOT IN statement
takes 7 seconds so I am not seeing any benefit from using NOT EXISTS.
My query looks like so
SELECT d.GroupID
FROM thistable d
WHERE d.PageID=1
and d.QuestionID=4
AND d.FormElementID=1
AND d.FormElementValue=5
and NOT EXISTS (SELECT * FROM thistable t1 WHERE t1.PageID=1 AND
t1.Question_ID=4 AND t1.FormElementID=1 AND FormElementValue = 5
AND EXISTS (SELECT * from thistable t2 WHERE t2.PageID=1 AND
t2.Question_ID=4 AND t2.FormElementID=2 AND FormElementValue = 10 AND
t1.GroupID = t2.GroupID) and d.GroupID=t1.GroupID)|||night_day (night_day_8@.yahoo.com) writes:
> Thank you for your response. I've spend some time converting my
> original query to use EXISTS, I can now generate the same output using
> a version running NOT EXISTS as my current NOT IN statements.
> Unfortunately, I've run the 2 queries in query analyzer and the NOT
> EXISTS statements takes 12 seconds whereas my current NOT IN statement
> takes 7 seconds so I am not seeing any benefit from using NOT EXISTS.
> My query looks like so
> SELECT d.GroupID
> FROM thistable d
> WHERE d.PageID=1
> and d.QuestionID=4
> AND d.FormElementID=1
> AND d.FormElementValue=5
> and NOT EXISTS (SELECT * FROM thistable t1 WHERE t1.PageID=1 AND
> t1.Question_ID=4 AND t1.FormElementID=1 AND FormElementValue = 5
> AND EXISTS (SELECT * from thistable t2 WHERE t2.PageID=1 AND
> t2.Question_ID=4 AND t2.FormElementID=2 AND FormElementValue = 10 AND
> t1.GroupID = t2.GroupID) and d.GroupID=t1.GroupID)
Eh, the query is not exactly trivial to understand. I feel quite
bewildered. It would help if you posted:
o CREATE TABLE statement for the table.
o The output of sp_helpindex for the table.
o Some indication of number of rows and distribution.
It could also be interesting to see the query plans. You can this
by surrounding the query in SET SHOWPLAN_ALL ON. (This will not execute
the query.)
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

need solution for change file path

greeting,
i would like to ask some question about MS SQL 2000 Server.
recall: during the installation, for the setup type, there's one setting for
the destination folder for (1) program files and (2)data files
i need a solution for:
during the installation, if the user pin point the path to default
<<DRIVE>>:\program files\mssql...
now i am having a new partition for the HDD, how can i switch MSSQL ordinary
data files path directory pin point to another directory?
example : from default data files path directory c:\mssql to e:\mssql?
thank youyk.ngYou can set a new database default location by selecting the server
properties, database settings tab and update the data and log directories on
the new database default location section.
Ben Nevarez, MCDBA, OCP
Database Administrator
"zouky" wrote:
> greeting,
> i would like to ask some question about MS SQL 2000 Server.
> recall: during the installation, for the setup type, there's one setting for
> the destination folder for (1) program files and (2)data files
> i need a solution for:
> during the installation, if the user pin point the path to default
> <<DRIVE>>:\program files\mssql...
> now i am having a new partition for the HDD, how can i switch MSSQL ordinary
> data files path directory pin point to another directory?
> example : from default data files path directory c:\mssql to e:\mssql?
> thank youyk.ng
>
>

need solution for change file path

greeting,
i would like to ask some question about MS SQL 2000 Server.
recall: during the installation, for the setup type, there's one setting for
the destination folder for (1) program files and (2)data files
i need a solution for:
during the installation, if the user pin point the path to default
<<DRIVE>>:\program files\mssql...
now i am having a new partition for the HDD, how can i switch MSSQL ordinary
data files path directory pin point to another directory?
example : from default data files path directory c:\mssql to e:\mssql?
thank youyk.ngYou can set a new database default location by selecting the server
properties, database settings tab and update the data and log directories on
the new database default location section.
Ben Nevarez, MCDBA, OCP
Database Administrator
"zouky" wrote:

> greeting,
> i would like to ask some question about MS SQL 2000 Server.
> recall: during the installation, for the setup type, there's one setting f
or
> the destination folder for (1) program files and (2)data files
> i need a solution for:
> during the installation, if the user pin point the path to default
> <<DRIVE>>:\program files\mssql...
> now i am having a new partition for the HDD, how can i switch MSSQL ordina
ry
> data files path directory pin point to another directory?
> example : from default data files path directory c:\mssql to e:\mssql?
> thank youyk.ng
>
>

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

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

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.