As usual I'm learning by doing and I'm not sure I know what I'm doing.
We have a legacy server running Windows Server 2003 and Sql Server 2000.
We want to run a Reporting Services report off one of the tables in SQL
Server 2000 so I was told to install SQL2005 Standard including RS on the
server.
IIS has been installed. When it came time to install SQL2005 I had a few
moments of confusion. I am used to installing SQL2005 Express which seems to
automatically install a named instance. In this case I manually selected a
named instance (RS2005) because the wording of the screen seemed to imply
that the default instance of SQL2000 would be upgraded (which wouldn't be a
good idea.)
So I installed SQL2005 with a named instance and the BI Studio. I copied
over the report I wanted to deploy. Now my problem is that I cannot get it
to deploy. In BI/VS the TargetServerURL is
http://localhost/ReportServer$RS2005. All I get are connection errors: 'A
connection could not be made to the report server
http://localhost/ReportServer$RS2005. Additional information - The attempt
to connect to the report server failed. Check your connection information,
etc.'
I have run the Reporting Services Configuration manager. To save time, here
are the settings:
Report Server Status
Instance Name RS2005
Instance ID MSSQL.2
Running
--
Report Server Virtual Directory
Name ReportServer$RS2005
Website Default Website
Report Manager Virtual Directory Settings
Name Reports$RS2005
Website Default Web Site
Windows Service Identity
Service Nmae ReportServer$RS2005
Service Account LocalSystem
Built-in Account Local SystemFirst things first. Can you pull up Report Manager (this is the portal that
ships with RS and is used to manage RS).
http://yourservername/Reports/Pages/Folder.aspx
localhost only works if you are on the machine hosting RS.
Second, are you an adminstrator on that machine. All people in the local
administrator group on the machine that has RS installed will automatically
be in the RS administrators role.
Deploying is the last thing you should try.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> As usual I'm learning by doing and I'm not sure I know what I'm doing.
> We have a legacy server running Windows Server 2003 and Sql Server 2000.
> We want to run a Reporting Services report off one of the tables in SQL
> Server 2000 so I was told to install SQL2005 Standard including RS on the
> server.
> IIS has been installed. When it came time to install SQL2005 I had a few
> moments of confusion. I am used to installing SQL2005 Express which seems
> to
> automatically install a named instance. In this case I manually selected
> a
> named instance (RS2005) because the wording of the screen seemed to imply
> that the default instance of SQL2000 would be upgraded (which wouldn't be
> a
> good idea.)
> So I installed SQL2005 with a named instance and the BI Studio. I copied
> over the report I wanted to deploy. Now my problem is that I cannot get
> it
> to deploy. In BI/VS the TargetServerURL is
> http://localhost/ReportServer$RS2005. All I get are connection errors: 'A
> connection could not be made to the report server
> http://localhost/ReportServer$RS2005. Additional information - The
> attempt
> to connect to the report server failed. Check your connection
> information,
> etc.'
> I have run the Reporting Services Configuration manager. To save time,
> here
> are the settings:
> Report Server Status
> Instance Name RS2005
> Instance ID MSSQL.2
> Running
> --
> Report Server Virtual Directory
> Name ReportServer$RS2005
> Website Default Website
> Report Manager Virtual Directory Settings
> Name Reports$RS2005
> Website Default Web Site
> Windows Service Identity
> Service Nmae ReportServer$RS2005
> Service Account LocalSystem
> Built-in Account Local System
>|||No. I've tried both on the server itself and from another machine. Always
'Page cannot be found.'
(Tried with both http://<servername>/Reports and
http://<servername>/Reports$RS2005)
As far as I know I'm an administrator.
"Bruce L-C [MVP]" wrote:
> First things first. Can you pull up Report Manager (this is the portal that
> ships with RS and is used to manage RS).
> http://yourservername/Reports/Pages/Folder.aspx
> localhost only works if you are on the machine hosting RS.
> Second, are you an adminstrator on that machine. All people in the local
> administrator group on the machine that has RS installed will automatically
> be in the RS administrators role.
> Deploying is the last thing you should try.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> > As usual I'm learning by doing and I'm not sure I know what I'm doing.
> >
> > We have a legacy server running Windows Server 2003 and Sql Server 2000.
> > We want to run a Reporting Services report off one of the tables in SQL
> > Server 2000 so I was told to install SQL2005 Standard including RS on the
> > server.
> >
> > IIS has been installed. When it came time to install SQL2005 I had a few
> > moments of confusion. I am used to installing SQL2005 Express which seems
> > to
> > automatically install a named instance. In this case I manually selected
> > a
> > named instance (RS2005) because the wording of the screen seemed to imply
> > that the default instance of SQL2000 would be upgraded (which wouldn't be
> > a
> > good idea.)
> >
> > So I installed SQL2005 with a named instance and the BI Studio. I copied
> > over the report I wanted to deploy. Now my problem is that I cannot get
> > it
> > to deploy. In BI/VS the TargetServerURL is
> > http://localhost/ReportServer$RS2005. All I get are connection errors: 'A
> > connection could not be made to the report server
> > http://localhost/ReportServer$RS2005. Additional information - The
> > attempt
> > to connect to the report server failed. Check your connection
> > information,
> > etc.'
> >
> > I have run the Reporting Services Configuration manager. To save time,
> > here
> > are the settings:
> > Report Server Status
> > Instance Name RS2005
> > Instance ID MSSQL.2
> > Running
> >
> > --
> >
> > Report Server Virtual Directory
> > Name ReportServer$RS2005
> > Website Default Website
> >
> > Report Manager Virtual Directory Settings
> > Name Reports$RS2005
> > Website Default Web Site
> >
> > Windows Service Identity
> > Service Nmae ReportServer$RS2005
> > Service Account LocalSystem
> > Built-in Account Local System
> >
> >
>
>|||By what you posted it seems that you have it installed in the default
website in which case this should be working. Open up IIS adminstrator
(whatever it is called) and see if you have the websites.
By the way, you did not need to install SQL 2005. RS 2005 can use SQL 2000
for its object/metadata storage. You have to have a license for SQL Server
2005 but it does not need to be installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> No. I've tried both on the server itself and from another machine.
> Always
> 'Page cannot be found.'
> (Tried with both http://<servername>/Reports and
> http://<servername>/Reports$RS2005)
> As far as I know I'm an administrator.
> "Bruce L-C [MVP]" wrote:
>> First things first. Can you pull up Report Manager (this is the portal
>> that
>> ships with RS and is used to manage RS).
>> http://yourservername/Reports/Pages/Folder.aspx
>> localhost only works if you are on the machine hosting RS.
>> Second, are you an adminstrator on that machine. All people in the local
>> administrator group on the machine that has RS installed will
>> automatically
>> be in the RS administrators role.
>> Deploying is the last thing you should try.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> > As usual I'm learning by doing and I'm not sure I know what I'm doing.
>> >
>> > We have a legacy server running Windows Server 2003 and Sql Server
>> > 2000.
>> > We want to run a Reporting Services report off one of the tables in SQL
>> > Server 2000 so I was told to install SQL2005 Standard including RS on
>> > the
>> > server.
>> >
>> > IIS has been installed. When it came time to install SQL2005 I had a
>> > few
>> > moments of confusion. I am used to installing SQL2005 Express which
>> > seems
>> > to
>> > automatically install a named instance. In this case I manually
>> > selected
>> > a
>> > named instance (RS2005) because the wording of the screen seemed to
>> > imply
>> > that the default instance of SQL2000 would be upgraded (which wouldn't
>> > be
>> > a
>> > good idea.)
>> >
>> > So I installed SQL2005 with a named instance and the BI Studio. I
>> > copied
>> > over the report I wanted to deploy. Now my problem is that I cannot
>> > get
>> > it
>> > to deploy. In BI/VS the TargetServerURL is
>> > http://localhost/ReportServer$RS2005. All I get are connection errors:
>> > 'A
>> > connection could not be made to the report server
>> > http://localhost/ReportServer$RS2005. Additional information - The
>> > attempt
>> > to connect to the report server failed. Check your connection
>> > information,
>> > etc.'
>> >
>> > I have run the Reporting Services Configuration manager. To save time,
>> > here
>> > are the settings:
>> > Report Server Status
>> > Instance Name RS2005
>> > Instance ID MSSQL.2
>> > Running
>> >
>> > --
>> >
>> > Report Server Virtual Directory
>> > Name ReportServer$RS2005
>> > Website Default Website
>> >
>> > Report Manager Virtual Directory Settings
>> > Name Reports$RS2005
>> > Website Default Web Site
>> >
>> > Windows Service Identity
>> > Service Nmae ReportServer$RS2005
>> > Service Account LocalSystem
>> > Built-in Account Local System
>> >
>> >
>>|||By 'websites' do you mean the report directories under Default Web Site?
I have 4 report directories under the Default Web Site: ReportServer,
Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are empty.
The last two are full of what appears to be asp.net related files and
directories.
(I admit that I was under the impression that RS2005 needed a 2005 db to
store its data.)
"Bruce L-C [MVP]" wrote:
> By what you posted it seems that you have it installed in the default
> website in which case this should be working. Open up IIS adminstrator
> (whatever it is called) and see if you have the websites.
> By the way, you did not need to install SQL 2005. RS 2005 can use SQL 2000
> for its object/metadata storage. You have to have a license for SQL Server
> 2005 but it does not need to be installed.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> > No. I've tried both on the server itself and from another machine.
> > Always
> > 'Page cannot be found.'
> >
> > (Tried with both http://<servername>/Reports and
> > http://<servername>/Reports$RS2005)
> >
> > As far as I know I'm an administrator.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> First things first. Can you pull up Report Manager (this is the portal
> >> that
> >> ships with RS and is used to manage RS).
> >>
> >> http://yourservername/Reports/Pages/Folder.aspx
> >>
> >> localhost only works if you are on the machine hosting RS.
> >>
> >> Second, are you an adminstrator on that machine. All people in the local
> >> administrator group on the machine that has RS installed will
> >> automatically
> >> be in the RS administrators role.
> >>
> >> Deploying is the last thing you should try.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> > As usual I'm learning by doing and I'm not sure I know what I'm doing.
> >> >
> >> > We have a legacy server running Windows Server 2003 and Sql Server
> >> > 2000.
> >> > We want to run a Reporting Services report off one of the tables in SQL
> >> > Server 2000 so I was told to install SQL2005 Standard including RS on
> >> > the
> >> > server.
> >> >
> >> > IIS has been installed. When it came time to install SQL2005 I had a
> >> > few
> >> > moments of confusion. I am used to installing SQL2005 Express which
> >> > seems
> >> > to
> >> > automatically install a named instance. In this case I manually
> >> > selected
> >> > a
> >> > named instance (RS2005) because the wording of the screen seemed to
> >> > imply
> >> > that the default instance of SQL2000 would be upgraded (which wouldn't
> >> > be
> >> > a
> >> > good idea.)
> >> >
> >> > So I installed SQL2005 with a named instance and the BI Studio. I
> >> > copied
> >> > over the report I wanted to deploy. Now my problem is that I cannot
> >> > get
> >> > it
> >> > to deploy. In BI/VS the TargetServerURL is
> >> > http://localhost/ReportServer$RS2005. All I get are connection errors:
> >> > 'A
> >> > connection could not be made to the report server
> >> > http://localhost/ReportServer$RS2005. Additional information - The
> >> > attempt
> >> > to connect to the report server failed. Check your connection
> >> > information,
> >> > etc.'
> >> >
> >> > I have run the Reporting Services Configuration manager. To save time,
> >> > here
> >> > are the settings:
> >> > Report Server Status
> >> > Instance Name RS2005
> >> > Instance ID MSSQL.2
> >> > Running
> >> >
> >> > --
> >> >
> >> > Report Server Virtual Directory
> >> > Name ReportServer$RS2005
> >> > Website Default Website
> >> >
> >> > Report Manager Virtual Directory Settings
> >> > Name Reports$RS2005
> >> > Website Default Web Site
> >> >
> >> > Windows Service Identity
> >> > Service Nmae ReportServer$RS2005
> >> > Service Account LocalSystem
> >> > Built-in Account Local System
> >> >
> >> >
> >>
> >>
> >>
>
>|||You have somehow gotten a totally messed up install. You should not have
four sites. Try this:
http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> By 'websites' do you mean the report directories under Default Web Site?
> I have 4 report directories under the Default Web Site: ReportServer,
> Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are empty.
> The last two are full of what appears to be asp.net related files and
> directories.
> (I admit that I was under the impression that RS2005 needed a 2005 db to
> store its data.)
> "Bruce L-C [MVP]" wrote:
>> By what you posted it seems that you have it installed in the default
>> website in which case this should be working. Open up IIS adminstrator
>> (whatever it is called) and see if you have the websites.
>> By the way, you did not need to install SQL 2005. RS 2005 can use SQL
>> 2000
>> for its object/metadata storage. You have to have a license for SQL
>> Server
>> 2005 but it does not need to be installed.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
>> > No. I've tried both on the server itself and from another machine.
>> > Always
>> > 'Page cannot be found.'
>> >
>> > (Tried with both http://<servername>/Reports and
>> > http://<servername>/Reports$RS2005)
>> >
>> > As far as I know I'm an administrator.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> First things first. Can you pull up Report Manager (this is the portal
>> >> that
>> >> ships with RS and is used to manage RS).
>> >>
>> >> http://yourservername/Reports/Pages/Folder.aspx
>> >>
>> >> localhost only works if you are on the machine hosting RS.
>> >>
>> >> Second, are you an adminstrator on that machine. All people in the
>> >> local
>> >> administrator group on the machine that has RS installed will
>> >> automatically
>> >> be in the RS administrators role.
>> >>
>> >> Deploying is the last thing you should try.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> >> > As usual I'm learning by doing and I'm not sure I know what I'm
>> >> > doing.
>> >> >
>> >> > We have a legacy server running Windows Server 2003 and Sql Server
>> >> > 2000.
>> >> > We want to run a Reporting Services report off one of the tables in
>> >> > SQL
>> >> > Server 2000 so I was told to install SQL2005 Standard including RS
>> >> > on
>> >> > the
>> >> > server.
>> >> >
>> >> > IIS has been installed. When it came time to install SQL2005 I had
>> >> > a
>> >> > few
>> >> > moments of confusion. I am used to installing SQL2005 Express which
>> >> > seems
>> >> > to
>> >> > automatically install a named instance. In this case I manually
>> >> > selected
>> >> > a
>> >> > named instance (RS2005) because the wording of the screen seemed to
>> >> > imply
>> >> > that the default instance of SQL2000 would be upgraded (which
>> >> > wouldn't
>> >> > be
>> >> > a
>> >> > good idea.)
>> >> >
>> >> > So I installed SQL2005 with a named instance and the BI Studio. I
>> >> > copied
>> >> > over the report I wanted to deploy. Now my problem is that I cannot
>> >> > get
>> >> > it
>> >> > to deploy. In BI/VS the TargetServerURL is
>> >> > http://localhost/ReportServer$RS2005. All I get are connection
>> >> > errors:
>> >> > 'A
>> >> > connection could not be made to the report server
>> >> > http://localhost/ReportServer$RS2005. Additional information - The
>> >> > attempt
>> >> > to connect to the report server failed. Check your connection
>> >> > information,
>> >> > etc.'
>> >> >
>> >> > I have run the Reporting Services Configuration manager. To save
>> >> > time,
>> >> > here
>> >> > are the settings:
>> >> > Report Server Status
>> >> > Instance Name RS2005
>> >> > Instance ID MSSQL.2
>> >> > Running
>> >> >
>> >> > --
>> >> >
>> >> > Report Server Virtual Directory
>> >> > Name ReportServer$RS2005
>> >> > Website Default Website
>> >> >
>> >> > Report Manager Virtual Directory Settings
>> >> > Name Reports$RS2005
>> >> > Website Default Web Site
>> >> >
>> >> > Windows Service Identity
>> >> > Service Nmae ReportServer$RS2005
>> >> > Service Account LocalSystem
>> >> > Built-in Account Local System
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||I've already tried that and it doesn't work. Also tried deleting the empty
directories. (I might have created them when I was messing with the
Reporting Services Configuration Manager.)
"Bruce L-C [MVP]" wrote:
> You have somehow gotten a totally messed up install. You should not have
> four sites. Try this:
> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> > By 'websites' do you mean the report directories under Default Web Site?
> >
> > I have 4 report directories under the Default Web Site: ReportServer,
> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are empty.
> > The last two are full of what appears to be asp.net related files and
> > directories.
> >
> > (I admit that I was under the impression that RS2005 needed a 2005 db to
> > store its data.)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> By what you posted it seems that you have it installed in the default
> >> website in which case this should be working. Open up IIS adminstrator
> >> (whatever it is called) and see if you have the websites.
> >>
> >> By the way, you did not need to install SQL 2005. RS 2005 can use SQL
> >> 2000
> >> for its object/metadata storage. You have to have a license for SQL
> >> Server
> >> 2005 but it does not need to be installed.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> > No. I've tried both on the server itself and from another machine.
> >> > Always
> >> > 'Page cannot be found.'
> >> >
> >> > (Tried with both http://<servername>/Reports and
> >> > http://<servername>/Reports$RS2005)
> >> >
> >> > As far as I know I'm an administrator.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First things first. Can you pull up Report Manager (this is the portal
> >> >> that
> >> >> ships with RS and is used to manage RS).
> >> >>
> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >>
> >> >> localhost only works if you are on the machine hosting RS.
> >> >>
> >> >> Second, are you an adminstrator on that machine. All people in the
> >> >> local
> >> >> administrator group on the machine that has RS installed will
> >> >> automatically
> >> >> be in the RS administrators role.
> >> >>
> >> >> Deploying is the last thing you should try.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> > As usual I'm learning by doing and I'm not sure I know what I'm
> >> >> > doing.
> >> >> >
> >> >> > We have a legacy server running Windows Server 2003 and Sql Server
> >> >> > 2000.
> >> >> > We want to run a Reporting Services report off one of the tables in
> >> >> > SQL
> >> >> > Server 2000 so I was told to install SQL2005 Standard including RS
> >> >> > on
> >> >> > the
> >> >> > server.
> >> >> >
> >> >> > IIS has been installed. When it came time to install SQL2005 I had
> >> >> > a
> >> >> > few
> >> >> > moments of confusion. I am used to installing SQL2005 Express which
> >> >> > seems
> >> >> > to
> >> >> > automatically install a named instance. In this case I manually
> >> >> > selected
> >> >> > a
> >> >> > named instance (RS2005) because the wording of the screen seemed to
> >> >> > imply
> >> >> > that the default instance of SQL2000 would be upgraded (which
> >> >> > wouldn't
> >> >> > be
> >> >> > a
> >> >> > good idea.)
> >> >> >
> >> >> > So I installed SQL2005 with a named instance and the BI Studio. I
> >> >> > copied
> >> >> > over the report I wanted to deploy. Now my problem is that I cannot
> >> >> > get
> >> >> > it
> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> > http://localhost/ReportServer$RS2005. All I get are connection
> >> >> > errors:
> >> >> > 'A
> >> >> > connection could not be made to the report server
> >> >> > http://localhost/ReportServer$RS2005. Additional information - The
> >> >> > attempt
> >> >> > to connect to the report server failed. Check your connection
> >> >> > information,
> >> >> > etc.'
> >> >> >
> >> >> > I have run the Reporting Services Configuration manager. To save
> >> >> > time,
> >> >> > here
> >> >> > are the settings:
> >> >> > Report Server Status
> >> >> > Instance Name RS2005
> >> >> > Instance ID MSSQL.2
> >> >> > Running
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Report Server Virtual Directory
> >> >> > Name ReportServer$RS2005
> >> >> > Website Default Website
> >> >> >
> >> >> > Report Manager Virtual Directory Settings
> >> >> > Name Reports$RS2005
> >> >> > Website Default Web Site
> >> >> >
> >> >> > Windows Service Identity
> >> >> > Service Nmae ReportServer$RS2005
> >> >> > Service Account LocalSystem
> >> >> > Built-in Account Local System
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Maybe I should just uninstall everything and start over.
"Bruce L-C [MVP]" wrote:
> You have somehow gotten a totally messed up install. You should not have
> four sites. Try this:
> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> > By 'websites' do you mean the report directories under Default Web Site?
> >
> > I have 4 report directories under the Default Web Site: ReportServer,
> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are empty.
> > The last two are full of what appears to be asp.net related files and
> > directories.
> >
> > (I admit that I was under the impression that RS2005 needed a 2005 db to
> > store its data.)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> By what you posted it seems that you have it installed in the default
> >> website in which case this should be working. Open up IIS adminstrator
> >> (whatever it is called) and see if you have the websites.
> >>
> >> By the way, you did not need to install SQL 2005. RS 2005 can use SQL
> >> 2000
> >> for its object/metadata storage. You have to have a license for SQL
> >> Server
> >> 2005 but it does not need to be installed.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> > No. I've tried both on the server itself and from another machine.
> >> > Always
> >> > 'Page cannot be found.'
> >> >
> >> > (Tried with both http://<servername>/Reports and
> >> > http://<servername>/Reports$RS2005)
> >> >
> >> > As far as I know I'm an administrator.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First things first. Can you pull up Report Manager (this is the portal
> >> >> that
> >> >> ships with RS and is used to manage RS).
> >> >>
> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >>
> >> >> localhost only works if you are on the machine hosting RS.
> >> >>
> >> >> Second, are you an adminstrator on that machine. All people in the
> >> >> local
> >> >> administrator group on the machine that has RS installed will
> >> >> automatically
> >> >> be in the RS administrators role.
> >> >>
> >> >> Deploying is the last thing you should try.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> > As usual I'm learning by doing and I'm not sure I know what I'm
> >> >> > doing.
> >> >> >
> >> >> > We have a legacy server running Windows Server 2003 and Sql Server
> >> >> > 2000.
> >> >> > We want to run a Reporting Services report off one of the tables in
> >> >> > SQL
> >> >> > Server 2000 so I was told to install SQL2005 Standard including RS
> >> >> > on
> >> >> > the
> >> >> > server.
> >> >> >
> >> >> > IIS has been installed. When it came time to install SQL2005 I had
> >> >> > a
> >> >> > few
> >> >> > moments of confusion. I am used to installing SQL2005 Express which
> >> >> > seems
> >> >> > to
> >> >> > automatically install a named instance. In this case I manually
> >> >> > selected
> >> >> > a
> >> >> > named instance (RS2005) because the wording of the screen seemed to
> >> >> > imply
> >> >> > that the default instance of SQL2000 would be upgraded (which
> >> >> > wouldn't
> >> >> > be
> >> >> > a
> >> >> > good idea.)
> >> >> >
> >> >> > So I installed SQL2005 with a named instance and the BI Studio. I
> >> >> > copied
> >> >> > over the report I wanted to deploy. Now my problem is that I cannot
> >> >> > get
> >> >> > it
> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> > http://localhost/ReportServer$RS2005. All I get are connection
> >> >> > errors:
> >> >> > 'A
> >> >> > connection could not be made to the report server
> >> >> > http://localhost/ReportServer$RS2005. Additional information - The
> >> >> > attempt
> >> >> > to connect to the report server failed. Check your connection
> >> >> > information,
> >> >> > etc.'
> >> >> >
> >> >> > I have run the Reporting Services Configuration manager. To save
> >> >> > time,
> >> >> > here
> >> >> > are the settings:
> >> >> > Report Server Status
> >> >> > Instance Name RS2005
> >> >> > Instance ID MSSQL.2
> >> >> > Running
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Report Server Virtual Directory
> >> >> > Name ReportServer$RS2005
> >> >> > Website Default Website
> >> >> >
> >> >> > Report Manager Virtual Directory Settings
> >> >> > Name Reports$RS2005
> >> >> > Website Default Web Site
> >> >> >
> >> >> > Windows Service Identity
> >> >> > Service Nmae ReportServer$RS2005
> >> >> > Service Account LocalSystem
> >> >> > Built-in Account Local System
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||My suggestion is to do that and this time do not create SQL Server 2005
database. Just point it to an existing SQL Server 2000 db that you have.
There is no advantage to the added complexity of what you were doing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> Maybe I should just uninstall everything and start over.
> "Bruce L-C [MVP]" wrote:
>> You have somehow gotten a totally messed up install. You should not have
>> four sites. Try this:
>> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
>> > By 'websites' do you mean the report directories under Default Web
>> > Site?
>> >
>> > I have 4 report directories under the Default Web Site: ReportServer,
>> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are
>> > empty.
>> > The last two are full of what appears to be asp.net related files and
>> > directories.
>> >
>> > (I admit that I was under the impression that RS2005 needed a 2005 db
>> > to
>> > store its data.)
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> By what you posted it seems that you have it installed in the default
>> >> website in which case this should be working. Open up IIS adminstrator
>> >> (whatever it is called) and see if you have the websites.
>> >>
>> >> By the way, you did not need to install SQL 2005. RS 2005 can use SQL
>> >> 2000
>> >> for its object/metadata storage. You have to have a license for SQL
>> >> Server
>> >> 2005 but it does not need to be installed.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
>> >> > No. I've tried both on the server itself and from another machine.
>> >> > Always
>> >> > 'Page cannot be found.'
>> >> >
>> >> > (Tried with both http://<servername>/Reports and
>> >> > http://<servername>/Reports$RS2005)
>> >> >
>> >> > As far as I know I'm an administrator.
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> First things first. Can you pull up Report Manager (this is the
>> >> >> portal
>> >> >> that
>> >> >> ships with RS and is used to manage RS).
>> >> >>
>> >> >> http://yourservername/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> localhost only works if you are on the machine hosting RS.
>> >> >>
>> >> >> Second, are you an adminstrator on that machine. All people in the
>> >> >> local
>> >> >> administrator group on the machine that has RS installed will
>> >> >> automatically
>> >> >> be in the RS administrators role.
>> >> >>
>> >> >> Deploying is the last thing you should try.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> >> >> > As usual I'm learning by doing and I'm not sure I know what I'm
>> >> >> > doing.
>> >> >> >
>> >> >> > We have a legacy server running Windows Server 2003 and Sql
>> >> >> > Server
>> >> >> > 2000.
>> >> >> > We want to run a Reporting Services report off one of the tables
>> >> >> > in
>> >> >> > SQL
>> >> >> > Server 2000 so I was told to install SQL2005 Standard including
>> >> >> > RS
>> >> >> > on
>> >> >> > the
>> >> >> > server.
>> >> >> >
>> >> >> > IIS has been installed. When it came time to install SQL2005 I
>> >> >> > had
>> >> >> > a
>> >> >> > few
>> >> >> > moments of confusion. I am used to installing SQL2005 Express
>> >> >> > which
>> >> >> > seems
>> >> >> > to
>> >> >> > automatically install a named instance. In this case I manually
>> >> >> > selected
>> >> >> > a
>> >> >> > named instance (RS2005) because the wording of the screen seemed
>> >> >> > to
>> >> >> > imply
>> >> >> > that the default instance of SQL2000 would be upgraded (which
>> >> >> > wouldn't
>> >> >> > be
>> >> >> > a
>> >> >> > good idea.)
>> >> >> >
>> >> >> > So I installed SQL2005 with a named instance and the BI Studio.
>> >> >> > I
>> >> >> > copied
>> >> >> > over the report I wanted to deploy. Now my problem is that I
>> >> >> > cannot
>> >> >> > get
>> >> >> > it
>> >> >> > to deploy. In BI/VS the TargetServerURL is
>> >> >> > http://localhost/ReportServer$RS2005. All I get are connection
>> >> >> > errors:
>> >> >> > 'A
>> >> >> > connection could not be made to the report server
>> >> >> > http://localhost/ReportServer$RS2005. Additional information -
>> >> >> > The
>> >> >> > attempt
>> >> >> > to connect to the report server failed. Check your connection
>> >> >> > information,
>> >> >> > etc.'
>> >> >> >
>> >> >> > I have run the Reporting Services Configuration manager. To save
>> >> >> > time,
>> >> >> > here
>> >> >> > are the settings:
>> >> >> > Report Server Status
>> >> >> > Instance Name RS2005
>> >> >> > Instance ID MSSQL.2
>> >> >> > Running
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> > Report Server Virtual Directory
>> >> >> > Name ReportServer$RS2005
>> >> >> > Website Default Website
>> >> >> >
>> >> >> > Report Manager Virtual Directory Settings
>> >> >> > Name Reports$RS2005
>> >> >> > Website Default Web Site
>> >> >> >
>> >> >> > Windows Service Identity
>> >> >> > Service Nmae ReportServer$RS2005
>> >> >> > Service Account LocalSystem
>> >> >> > Built-in Account Local System
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Ok I did that and now I've got new problems.
I reinstalled without creating a SQL2005 db. I went through the RS Config
manager using only defaults and the DBs appear to have been created
successfully under the SQL2000 server.
Now when I try to deploy the report using VS/BI, I get an error: A
connection could not be made to the report server
http://localhost/ReportServer. Additional Information: Client found response
content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
request failed with the error message: '
The rest is too long to type here (looks like a big piece of HTML or XML)
but the system event log is full of error messages like this: The
application-specific permission settings do not grant Local Activation
permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
permission can be modified using the Component Services administrative tool.
Could this have something to do with the fact that I wrote the report on my
desktop and then copied the entire project over to the server?
"Bruce L-C [MVP]" wrote:
> My suggestion is to do that and this time do not create SQL Server 2005
> database. Just point it to an existing SQL Server 2000 db that you have.
> There is no advantage to the added complexity of what you were doing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> > Maybe I should just uninstall everything and start over.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You have somehow gotten a totally messed up install. You should not have
> >> four sites. Try this:
> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> >> > By 'websites' do you mean the report directories under Default Web
> >> > Site?
> >> >
> >> > I have 4 report directories under the Default Web Site: ReportServer,
> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are
> >> > empty.
> >> > The last two are full of what appears to be asp.net related files and
> >> > directories.
> >> >
> >> > (I admit that I was under the impression that RS2005 needed a 2005 db
> >> > to
> >> > store its data.)
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> By what you posted it seems that you have it installed in the default
> >> >> website in which case this should be working. Open up IIS adminstrator
> >> >> (whatever it is called) and see if you have the websites.
> >> >>
> >> >> By the way, you did not need to install SQL 2005. RS 2005 can use SQL
> >> >> 2000
> >> >> for its object/metadata storage. You have to have a license for SQL
> >> >> Server
> >> >> 2005 but it does not need to be installed.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> >> > No. I've tried both on the server itself and from another machine.
> >> >> > Always
> >> >> > 'Page cannot be found.'
> >> >> >
> >> >> > (Tried with both http://<servername>/Reports and
> >> >> > http://<servername>/Reports$RS2005)
> >> >> >
> >> >> > As far as I know I'm an administrator.
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> First things first. Can you pull up Report Manager (this is the
> >> >> >> portal
> >> >> >> that
> >> >> >> ships with RS and is used to manage RS).
> >> >> >>
> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >> >>
> >> >> >> localhost only works if you are on the machine hosting RS.
> >> >> >>
> >> >> >> Second, are you an adminstrator on that machine. All people in the
> >> >> >> local
> >> >> >> administrator group on the machine that has RS installed will
> >> >> >> automatically
> >> >> >> be in the RS administrators role.
> >> >> >>
> >> >> >> Deploying is the last thing you should try.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> >> > As usual I'm learning by doing and I'm not sure I know what I'm
> >> >> >> > doing.
> >> >> >> >
> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
> >> >> >> > Server
> >> >> >> > 2000.
> >> >> >> > We want to run a Reporting Services report off one of the tables
> >> >> >> > in
> >> >> >> > SQL
> >> >> >> > Server 2000 so I was told to install SQL2005 Standard including
> >> >> >> > RS
> >> >> >> > on
> >> >> >> > the
> >> >> >> > server.
> >> >> >> >
> >> >> >> > IIS has been installed. When it came time to install SQL2005 I
> >> >> >> > had
> >> >> >> > a
> >> >> >> > few
> >> >> >> > moments of confusion. I am used to installing SQL2005 Express
> >> >> >> > which
> >> >> >> > seems
> >> >> >> > to
> >> >> >> > automatically install a named instance. In this case I manually
> >> >> >> > selected
> >> >> >> > a
> >> >> >> > named instance (RS2005) because the wording of the screen seemed
> >> >> >> > to
> >> >> >> > imply
> >> >> >> > that the default instance of SQL2000 would be upgraded (which
> >> >> >> > wouldn't
> >> >> >> > be
> >> >> >> > a
> >> >> >> > good idea.)
> >> >> >> >
> >> >> >> > So I installed SQL2005 with a named instance and the BI Studio.
> >> >> >> > I
> >> >> >> > copied
> >> >> >> > over the report I wanted to deploy. Now my problem is that I
> >> >> >> > cannot
> >> >> >> > get
> >> >> >> > it
> >> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> >> > http://localhost/ReportServer$RS2005. All I get are connection
> >> >> >> > errors:
> >> >> >> > 'A
> >> >> >> > connection could not be made to the report server
> >> >> >> > http://localhost/ReportServer$RS2005. Additional information -
> >> >> >> > The
> >> >> >> > attempt
> >> >> >> > to connect to the report server failed. Check your connection
> >> >> >> > information,
> >> >> >> > etc.'
> >> >> >> >
> >> >> >> > I have run the Reporting Services Configuration manager. To save
> >> >> >> > time,
> >> >> >> > here
> >> >> >> > are the settings:
> >> >> >> > Report Server Status
> >> >> >> > Instance Name RS2005
> >> >> >> > Instance ID MSSQL.2
> >> >> >> > Running
> >> >> >> >
> >> >> >> > --
> >> >> >> >
> >> >> >> > Report Server Virtual Directory
> >> >> >> > Name ReportServer$RS2005
> >> >> >> > Website Default Website
> >> >> >> >
> >> >> >> > Report Manager Virtual Directory Settings
> >> >> >> > Name Reports$RS2005
> >> >> >> > Website Default Web Site
> >> >> >> >
> >> >> >> > Windows Service Identity
> >> >> >> > Service Nmae ReportServer$RS2005
> >> >> >> > Service Account LocalSystem
> >> >> >> > Built-in Account Local System
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Can you see Report Manager. That is the first thing you need to do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
> Ok I did that and now I've got new problems.
> I reinstalled without creating a SQL2005 db. I went through the RS Config
> manager using only defaults and the DBs appear to have been created
> successfully under the SQL2000 server.
> Now when I try to deploy the report using VS/BI, I get an error: A
> connection could not be made to the report server
> http://localhost/ReportServer. Additional Information: Client found
> response
> content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
> request failed with the error message: '
> The rest is too long to type here (looks like a big piece of HTML or XML)
> but the system event log is full of error messages like this: The
> application-specific permission settings do not grant Local Activation
> permission for the COM Server application with CLSID
> {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> permission can be modified using the Component Services administrative
> tool.
> Could this have something to do with the fact that I wrote the report on
> my
> desktop and then copied the entire project over to the server?
> "Bruce L-C [MVP]" wrote:
>> My suggestion is to do that and this time do not create SQL Server 2005
>> database. Just point it to an existing SQL Server 2000 db that you have.
>> There is no advantage to the added complexity of what you were doing.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
>> > Maybe I should just uninstall everything and start over.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> You have somehow gotten a totally messed up install. You should not
>> >> have
>> >> four sites. Try this:
>> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
>> >> > By 'websites' do you mean the report directories under Default Web
>> >> > Site?
>> >> >
>> >> > I have 4 report directories under the Default Web Site:
>> >> > ReportServer,
>> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are
>> >> > empty.
>> >> > The last two are full of what appears to be asp.net related files
>> >> > and
>> >> > directories.
>> >> >
>> >> > (I admit that I was under the impression that RS2005 needed a 2005
>> >> > db
>> >> > to
>> >> > store its data.)
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> By what you posted it seems that you have it installed in the
>> >> >> default
>> >> >> website in which case this should be working. Open up IIS
>> >> >> adminstrator
>> >> >> (whatever it is called) and see if you have the websites.
>> >> >>
>> >> >> By the way, you did not need to install SQL 2005. RS 2005 can use
>> >> >> SQL
>> >> >> 2000
>> >> >> for its object/metadata storage. You have to have a license for SQL
>> >> >> Server
>> >> >> 2005 but it does not need to be installed.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
>> >> >> > No. I've tried both on the server itself and from another
>> >> >> > machine.
>> >> >> > Always
>> >> >> > 'Page cannot be found.'
>> >> >> >
>> >> >> > (Tried with both http://<servername>/Reports and
>> >> >> > http://<servername>/Reports$RS2005)
>> >> >> >
>> >> >> > As far as I know I'm an administrator.
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> First things first. Can you pull up Report Manager (this is the
>> >> >> >> portal
>> >> >> >> that
>> >> >> >> ships with RS and is used to manage RS).
>> >> >> >>
>> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
>> >> >> >>
>> >> >> >> localhost only works if you are on the machine hosting RS.
>> >> >> >>
>> >> >> >> Second, are you an adminstrator on that machine. All people in
>> >> >> >> the
>> >> >> >> local
>> >> >> >> administrator group on the machine that has RS installed will
>> >> >> >> automatically
>> >> >> >> be in the RS administrators role.
>> >> >> >>
>> >> >> >> Deploying is the last thing you should try.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
>> >> >> >> > I'm
>> >> >> >> > doing.
>> >> >> >> >
>> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
>> >> >> >> > Server
>> >> >> >> > 2000.
>> >> >> >> > We want to run a Reporting Services report off one of the
>> >> >> >> > tables
>> >> >> >> > in
>> >> >> >> > SQL
>> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
>> >> >> >> > including
>> >> >> >> > RS
>> >> >> >> > on
>> >> >> >> > the
>> >> >> >> > server.
>> >> >> >> >
>> >> >> >> > IIS has been installed. When it came time to install SQL2005
>> >> >> >> > I
>> >> >> >> > had
>> >> >> >> > a
>> >> >> >> > few
>> >> >> >> > moments of confusion. I am used to installing SQL2005 Express
>> >> >> >> > which
>> >> >> >> > seems
>> >> >> >> > to
>> >> >> >> > automatically install a named instance. In this case I
>> >> >> >> > manually
>> >> >> >> > selected
>> >> >> >> > a
>> >> >> >> > named instance (RS2005) because the wording of the screen
>> >> >> >> > seemed
>> >> >> >> > to
>> >> >> >> > imply
>> >> >> >> > that the default instance of SQL2000 would be upgraded (which
>> >> >> >> > wouldn't
>> >> >> >> > be
>> >> >> >> > a
>> >> >> >> > good idea.)
>> >> >> >> >
>> >> >> >> > So I installed SQL2005 with a named instance and the BI
>> >> >> >> > Studio.
>> >> >> >> > I
>> >> >> >> > copied
>> >> >> >> > over the report I wanted to deploy. Now my problem is that I
>> >> >> >> > cannot
>> >> >> >> > get
>> >> >> >> > it
>> >> >> >> > to deploy. In BI/VS the TargetServerURL is
>> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
>> >> >> >> > connection
>> >> >> >> > errors:
>> >> >> >> > 'A
>> >> >> >> > connection could not be made to the report server
>> >> >> >> > http://localhost/ReportServer$RS2005. Additional
>> >> >> >> > information -
>> >> >> >> > The
>> >> >> >> > attempt
>> >> >> >> > to connect to the report server failed. Check your connection
>> >> >> >> > information,
>> >> >> >> > etc.'
>> >> >> >> >
>> >> >> >> > I have run the Reporting Services Configuration manager. To
>> >> >> >> > save
>> >> >> >> > time,
>> >> >> >> > here
>> >> >> >> > are the settings:
>> >> >> >> > Report Server Status
>> >> >> >> > Instance Name RS2005
>> >> >> >> > Instance ID MSSQL.2
>> >> >> >> > Running
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> >
>> >> >> >> > Report Server Virtual Directory
>> >> >> >> > Name ReportServer$RS2005
>> >> >> >> > Website Default Website
>> >> >> >> >
>> >> >> >> > Report Manager Virtual Directory Settings
>> >> >> >> > Name Reports$RS2005
>> >> >> >> > Website Default Web Site
>> >> >> >> >
>> >> >> >> > Windows Service Identity
>> >> >> >> > Service Nmae ReportServer$RS2005
>> >> >> >> > Service Account LocalSystem
>> >> >> >> > Built-in Account Local System
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Now what. Am I forgetting some option when running RS off SQL 2000? Got a
very different error.
The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and
then click the Refresh button, or try again later.
----
A name was started with an invalid character. Error processing resource
'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
<%@. Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.Folde
"Bruce L-C [MVP]" wrote:
> Can you see Report Manager. That is the first thing you need to do.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
> > Ok I did that and now I've got new problems.
> >
> > I reinstalled without creating a SQL2005 db. I went through the RS Config
> > manager using only defaults and the DBs appear to have been created
> > successfully under the SQL2000 server.
> >
> > Now when I try to deploy the report using VS/BI, I get an error: A
> > connection could not be made to the report server
> > http://localhost/ReportServer. Additional Information: Client found
> > response
> > content type of 'text/html; charset=utf-8', but expected 'text/xml'. The
> > request failed with the error message: '
> >
> > The rest is too long to type here (looks like a big piece of HTML or XML)
> > but the system event log is full of error messages like this: The
> > application-specific permission settings do not grant Local Activation
> > permission for the COM Server application with CLSID
> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> > permission can be modified using the Component Services administrative
> > tool.
> >
> > Could this have something to do with the fact that I wrote the report on
> > my
> > desktop and then copied the entire project over to the server?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> My suggestion is to do that and this time do not create SQL Server 2005
> >> database. Just point it to an existing SQL Server 2000 db that you have.
> >> There is no advantage to the added complexity of what you were doing.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> >> > Maybe I should just uninstall everything and start over.
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> You have somehow gotten a totally messed up install. You should not
> >> >> have
> >> >> four sites. Try this:
> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> >> >> > By 'websites' do you mean the report directories under Default Web
> >> >> > Site?
> >> >> >
> >> >> > I have 4 report directories under the Default Web Site:
> >> >> > ReportServer,
> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2 are
> >> >> > empty.
> >> >> > The last two are full of what appears to be asp.net related files
> >> >> > and
> >> >> > directories.
> >> >> >
> >> >> > (I admit that I was under the impression that RS2005 needed a 2005
> >> >> > db
> >> >> > to
> >> >> > store its data.)
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> By what you posted it seems that you have it installed in the
> >> >> >> default
> >> >> >> website in which case this should be working. Open up IIS
> >> >> >> adminstrator
> >> >> >> (whatever it is called) and see if you have the websites.
> >> >> >>
> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can use
> >> >> >> SQL
> >> >> >> 2000
> >> >> >> for its object/metadata storage. You have to have a license for SQL
> >> >> >> Server
> >> >> >> 2005 but it does not need to be installed.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> >> >> > No. I've tried both on the server itself and from another
> >> >> >> > machine.
> >> >> >> > Always
> >> >> >> > 'Page cannot be found.'
> >> >> >> >
> >> >> >> > (Tried with both http://<servername>/Reports and
> >> >> >> > http://<servername>/Reports$RS2005)
> >> >> >> >
> >> >> >> > As far as I know I'm an administrator.
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> First things first. Can you pull up Report Manager (this is the
> >> >> >> >> portal
> >> >> >> >> that
> >> >> >> >> ships with RS and is used to manage RS).
> >> >> >> >>
> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >> >> >>
> >> >> >> >> localhost only works if you are on the machine hosting RS.
> >> >> >> >>
> >> >> >> >> Second, are you an adminstrator on that machine. All people in
> >> >> >> >> the
> >> >> >> >> local
> >> >> >> >> administrator group on the machine that has RS installed will
> >> >> >> >> automatically
> >> >> >> >> be in the RS administrators role.
> >> >> >> >>
> >> >> >> >> Deploying is the last thing you should try.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
> >> >> >> >> > I'm
> >> >> >> >> > doing.
> >> >> >> >> >
> >> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
> >> >> >> >> > Server
> >> >> >> >> > 2000.
> >> >> >> >> > We want to run a Reporting Services report off one of the
> >> >> >> >> > tables
> >> >> >> >> > in
> >> >> >> >> > SQL
> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
> >> >> >> >> > including
> >> >> >> >> > RS
> >> >> >> >> > on
> >> >> >> >> > the
> >> >> >> >> > server.
> >> >> >> >> >
> >> >> >> >> > IIS has been installed. When it came time to install SQL2005
> >> >> >> >> > I
> >> >> >> >> > had
> >> >> >> >> > a
> >> >> >> >> > few
> >> >> >> >> > moments of confusion. I am used to installing SQL2005 Express
> >> >> >> >> > which
> >> >> >> >> > seems
> >> >> >> >> > to
> >> >> >> >> > automatically install a named instance. In this case I
> >> >> >> >> > manually
> >> >> >> >> > selected
> >> >> >> >> > a
> >> >> >> >> > named instance (RS2005) because the wording of the screen
> >> >> >> >> > seemed
> >> >> >> >> > to
> >> >> >> >> > imply
> >> >> >> >> > that the default instance of SQL2000 would be upgraded (which
> >> >> >> >> > wouldn't
> >> >> >> >> > be
> >> >> >> >> > a
> >> >> >> >> > good idea.)
> >> >> >> >> >
> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
> >> >> >> >> > Studio.
> >> >> >> >> > I
> >> >> >> >> > copied
> >> >> >> >> > over the report I wanted to deploy. Now my problem is that I
> >> >> >> >> > cannot
> >> >> >> >> > get
> >> >> >> >> > it
> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
> >> >> >> >> > connection
> >> >> >> >> > errors:
> >> >> >> >> > 'A
> >> >> >> >> > connection could not be made to the report server
> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
> >> >> >> >> > information -
> >> >> >> >> > The
> >> >> >> >> > attempt
> >> >> >> >> > to connect to the report server failed. Check your connection
> >> >> >> >> > information,
> >> >> >> >> > etc.'
> >> >> >> >> >
> >> >> >> >> > I have run the Reporting Services Configuration manager. To
> >> >> >> >> > save
> >> >> >> >> > time,
> >> >> >> >> > here
> >> >> >> >> > are the settings:
> >> >> >> >> > Report Server Status
> >> >> >> >> > Instance Name RS2005
> >> >> >> >> > Instance ID MSSQL.2
> >> >> >> >> > Running
> >> >> >> >> >
> >> >> >> >> > --
> >> >> >> >> >
> >> >> >> >> > Report Server Virtual Directory
> >> >> >> >> > Name ReportServer$RS2005
> >> >> >> >> > Website Default Website
> >> >> >> >> >
> >> >> >> >> > Report Manager Virtual Directory Settings
> >> >> >> >> > Name Reports$RS2005
> >> >> >> >> > Website Default Web Site
> >> >> >> >> >
> >> >> >> >> > Windows Service Identity
> >> >> >> >> > Service Nmae ReportServer$RS2005
> >> >> >> >> > Service Account LocalSystem
> >> >> >> >> > Built-in Account Local System
> >> >> >> >> >
> >> >> >> >> >
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||If the RS configuration tool shows everything good it should not be a
problem.
I have never seen this error.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:23A2FD03-F2FF-4D94-A851-C2C6921C0A4A@.microsoft.com...
> Now what. Am I forgetting some option when running RS off SQL 2000? Got
> a
> very different error.
> The XML page cannot be displayed
> Cannot view XML input using XSL style sheet. Please correct the error and
> then click the Refresh button, or try again later.
>
> ----
> A name was started with an invalid character. Error processing resource
> 'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
> <%@. Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false"
> Inherits="Microsoft.ReportingServices.UI.Folde
>
> "Bruce L-C [MVP]" wrote:
>> Can you see Report Manager. That is the first thing you need to do.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
>> > Ok I did that and now I've got new problems.
>> >
>> > I reinstalled without creating a SQL2005 db. I went through the RS
>> > Config
>> > manager using only defaults and the DBs appear to have been created
>> > successfully under the SQL2000 server.
>> >
>> > Now when I try to deploy the report using VS/BI, I get an error: A
>> > connection could not be made to the report server
>> > http://localhost/ReportServer. Additional Information: Client found
>> > response
>> > content type of 'text/html; charset=utf-8', but expected 'text/xml'.
>> > The
>> > request failed with the error message: '
>> >
>> > The rest is too long to type here (looks like a big piece of HTML or
>> > XML)
>> > but the system event log is full of error messages like this: The
>> > application-specific permission settings do not grant Local Activation
>> > permission for the COM Server application with CLSID
>> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
>> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
>> > permission can be modified using the Component Services administrative
>> > tool.
>> >
>> > Could this have something to do with the fact that I wrote the report
>> > on
>> > my
>> > desktop and then copied the entire project over to the server?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> My suggestion is to do that and this time do not create SQL Server
>> >> 2005
>> >> database. Just point it to an existing SQL Server 2000 db that you
>> >> have.
>> >> There is no advantage to the added complexity of what you were doing.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
>> >> > Maybe I should just uninstall everything and start over.
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> You have somehow gotten a totally messed up install. You should not
>> >> >> have
>> >> >> four sites. Try this:
>> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
>> >> >> > By 'websites' do you mean the report directories under Default
>> >> >> > Web
>> >> >> > Site?
>> >> >> >
>> >> >> > I have 4 report directories under the Default Web Site:
>> >> >> > ReportServer,
>> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2
>> >> >> > are
>> >> >> > empty.
>> >> >> > The last two are full of what appears to be asp.net related files
>> >> >> > and
>> >> >> > directories.
>> >> >> >
>> >> >> > (I admit that I was under the impression that RS2005 needed a
>> >> >> > 2005
>> >> >> > db
>> >> >> > to
>> >> >> > store its data.)
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> By what you posted it seems that you have it installed in the
>> >> >> >> default
>> >> >> >> website in which case this should be working. Open up IIS
>> >> >> >> adminstrator
>> >> >> >> (whatever it is called) and see if you have the websites.
>> >> >> >>
>> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can
>> >> >> >> use
>> >> >> >> SQL
>> >> >> >> 2000
>> >> >> >> for its object/metadata storage. You have to have a license for
>> >> >> >> SQL
>> >> >> >> Server
>> >> >> >> 2005 but it does not need to be installed.
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
>> >> >> >> > No. I've tried both on the server itself and from another
>> >> >> >> > machine.
>> >> >> >> > Always
>> >> >> >> > 'Page cannot be found.'
>> >> >> >> >
>> >> >> >> > (Tried with both http://<servername>/Reports and
>> >> >> >> > http://<servername>/Reports$RS2005)
>> >> >> >> >
>> >> >> >> > As far as I know I'm an administrator.
>> >> >> >> >
>> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >
>> >> >> >> >> First things first. Can you pull up Report Manager (this is
>> >> >> >> >> the
>> >> >> >> >> portal
>> >> >> >> >> that
>> >> >> >> >> ships with RS and is used to manage RS).
>> >> >> >> >>
>> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
>> >> >> >> >>
>> >> >> >> >> localhost only works if you are on the machine hosting RS.
>> >> >> >> >>
>> >> >> >> >> Second, are you an adminstrator on that machine. All people
>> >> >> >> >> in
>> >> >> >> >> the
>> >> >> >> >> local
>> >> >> >> >> administrator group on the machine that has RS installed will
>> >> >> >> >> automatically
>> >> >> >> >> be in the RS administrators role.
>> >> >> >> >>
>> >> >> >> >> Deploying is the last thing you should try.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> >> >> message
>> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
>> >> >> >> >> > I'm
>> >> >> >> >> > doing.
>> >> >> >> >> >
>> >> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
>> >> >> >> >> > Server
>> >> >> >> >> > 2000.
>> >> >> >> >> > We want to run a Reporting Services report off one of the
>> >> >> >> >> > tables
>> >> >> >> >> > in
>> >> >> >> >> > SQL
>> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
>> >> >> >> >> > including
>> >> >> >> >> > RS
>> >> >> >> >> > on
>> >> >> >> >> > the
>> >> >> >> >> > server.
>> >> >> >> >> >
>> >> >> >> >> > IIS has been installed. When it came time to install
>> >> >> >> >> > SQL2005
>> >> >> >> >> > I
>> >> >> >> >> > had
>> >> >> >> >> > a
>> >> >> >> >> > few
>> >> >> >> >> > moments of confusion. I am used to installing SQL2005
>> >> >> >> >> > Express
>> >> >> >> >> > which
>> >> >> >> >> > seems
>> >> >> >> >> > to
>> >> >> >> >> > automatically install a named instance. In this case I
>> >> >> >> >> > manually
>> >> >> >> >> > selected
>> >> >> >> >> > a
>> >> >> >> >> > named instance (RS2005) because the wording of the screen
>> >> >> >> >> > seemed
>> >> >> >> >> > to
>> >> >> >> >> > imply
>> >> >> >> >> > that the default instance of SQL2000 would be upgraded
>> >> >> >> >> > (which
>> >> >> >> >> > wouldn't
>> >> >> >> >> > be
>> >> >> >> >> > a
>> >> >> >> >> > good idea.)
>> >> >> >> >> >
>> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
>> >> >> >> >> > Studio.
>> >> >> >> >> > I
>> >> >> >> >> > copied
>> >> >> >> >> > over the report I wanted to deploy. Now my problem is that
>> >> >> >> >> > I
>> >> >> >> >> > cannot
>> >> >> >> >> > get
>> >> >> >> >> > it
>> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
>> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
>> >> >> >> >> > connection
>> >> >> >> >> > errors:
>> >> >> >> >> > 'A
>> >> >> >> >> > connection could not be made to the report server
>> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
>> >> >> >> >> > information -
>> >> >> >> >> > The
>> >> >> >> >> > attempt
>> >> >> >> >> > to connect to the report server failed. Check your
>> >> >> >> >> > connection
>> >> >> >> >> > information,
>> >> >> >> >> > etc.'
>> >> >> >> >> >
>> >> >> >> >> > I have run the Reporting Services Configuration manager.
>> >> >> >> >> > To
>> >> >> >> >> > save
>> >> >> >> >> > time,
>> >> >> >> >> > here
>> >> >> >> >> > are the settings:
>> >> >> >> >> > Report Server Status
>> >> >> >> >> > Instance Name RS2005
>> >> >> >> >> > Instance ID MSSQL.2
>> >> >> >> >> > Running
>> >> >> >> >> >
>> >> >> >> >> > --
>> >> >> >> >> >
>> >> >> >> >> > Report Server Virtual Directory
>> >> >> >> >> > Name ReportServer$RS2005
>> >> >> >> >> > Website Default Website
>> >> >> >> >> >
>> >> >> >> >> > Report Manager Virtual Directory Settings
>> >> >> >> >> > Name Reports$RS2005
>> >> >> >> >> > Website Default Web Site
>> >> >> >> >> >
>> >> >> >> >> > Windows Service Identity
>> >> >> >> >> > Service Nmae ReportServer$RS2005
>> >> >> >> >> > Service Account LocalSystem
>> >> >> >> >> > Built-in Account Local System
>> >> >> >> >> >
>> >> >> >> >> >
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||If this stumps an MVP, then I'm really in trouble!
It's quitting time here (Eastern time). Let's continue this tomorrow.
"Bruce L-C [MVP]" wrote:
> If the RS configuration tool shows everything good it should not be a
> problem.
> I have never seen this error.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:23A2FD03-F2FF-4D94-A851-C2C6921C0A4A@.microsoft.com...
> > Now what. Am I forgetting some option when running RS off SQL 2000? Got
> > a
> > very different error.
> >
> > The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
> >
> > <%@. Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.Folde
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Can you see Report Manager. That is the first thing you need to do.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
> >> > Ok I did that and now I've got new problems.
> >> >
> >> > I reinstalled without creating a SQL2005 db. I went through the RS
> >> > Config
> >> > manager using only defaults and the DBs appear to have been created
> >> > successfully under the SQL2000 server.
> >> >
> >> > Now when I try to deploy the report using VS/BI, I get an error: A
> >> > connection could not be made to the report server
> >> > http://localhost/ReportServer. Additional Information: Client found
> >> > response
> >> > content type of 'text/html; charset=utf-8', but expected 'text/xml'.
> >> > The
> >> > request failed with the error message: '
> >> >
> >> > The rest is too long to type here (looks like a big piece of HTML or
> >> > XML)
> >> > but the system event log is full of error messages like this: The
> >> > application-specific permission settings do not grant Local Activation
> >> > permission for the COM Server application with CLSID
> >> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> >> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> >> > permission can be modified using the Component Services administrative
> >> > tool.
> >> >
> >> > Could this have something to do with the fact that I wrote the report
> >> > on
> >> > my
> >> > desktop and then copied the entire project over to the server?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> My suggestion is to do that and this time do not create SQL Server
> >> >> 2005
> >> >> database. Just point it to an existing SQL Server 2000 db that you
> >> >> have.
> >> >> There is no advantage to the added complexity of what you were doing.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> >> >> > Maybe I should just uninstall everything and start over.
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> You have somehow gotten a totally messed up install. You should not
> >> >> >> have
> >> >> >> four sites. Try this:
> >> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> >> >> >> > By 'websites' do you mean the report directories under Default
> >> >> >> > Web
> >> >> >> > Site?
> >> >> >> >
> >> >> >> > I have 4 report directories under the Default Web Site:
> >> >> >> > ReportServer,
> >> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2
> >> >> >> > are
> >> >> >> > empty.
> >> >> >> > The last two are full of what appears to be asp.net related files
> >> >> >> > and
> >> >> >> > directories.
> >> >> >> >
> >> >> >> > (I admit that I was under the impression that RS2005 needed a
> >> >> >> > 2005
> >> >> >> > db
> >> >> >> > to
> >> >> >> > store its data.)
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> By what you posted it seems that you have it installed in the
> >> >> >> >> default
> >> >> >> >> website in which case this should be working. Open up IIS
> >> >> >> >> adminstrator
> >> >> >> >> (whatever it is called) and see if you have the websites.
> >> >> >> >>
> >> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can
> >> >> >> >> use
> >> >> >> >> SQL
> >> >> >> >> 2000
> >> >> >> >> for its object/metadata storage. You have to have a license for
> >> >> >> >> SQL
> >> >> >> >> Server
> >> >> >> >> 2005 but it does not need to be installed.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> >> >> >> > No. I've tried both on the server itself and from another
> >> >> >> >> > machine.
> >> >> >> >> > Always
> >> >> >> >> > 'Page cannot be found.'
> >> >> >> >> >
> >> >> >> >> > (Tried with both http://<servername>/Reports and
> >> >> >> >> > http://<servername>/Reports$RS2005)
> >> >> >> >> >
> >> >> >> >> > As far as I know I'm an administrator.
> >> >> >> >> >
> >> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >> >
> >> >> >> >> >> First things first. Can you pull up Report Manager (this is
> >> >> >> >> >> the
> >> >> >> >> >> portal
> >> >> >> >> >> that
> >> >> >> >> >> ships with RS and is used to manage RS).
> >> >> >> >> >>
> >> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >> >> >> >>
> >> >> >> >> >> localhost only works if you are on the machine hosting RS.
> >> >> >> >> >>
> >> >> >> >> >> Second, are you an adminstrator on that machine. All people
> >> >> >> >> >> in
> >> >> >> >> >> the
> >> >> >> >> >> local
> >> >> >> >> >> administrator group on the machine that has RS installed will
> >> >> >> >> >> automatically
> >> >> >> >> >> be in the RS administrators role.
> >> >> >> >> >>
> >> >> >> >> >> Deploying is the last thing you should try.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> >> message
> >> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
> >> >> >> >> >> > I'm
> >> >> >> >> >> > doing.
> >> >> >> >> >> >
> >> >> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
> >> >> >> >> >> > Server
> >> >> >> >> >> > 2000.
> >> >> >> >> >> > We want to run a Reporting Services report off one of the
> >> >> >> >> >> > tables
> >> >> >> >> >> > in
> >> >> >> >> >> > SQL
> >> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
> >> >> >> >> >> > including
> >> >> >> >> >> > RS
> >> >> >> >> >> > on
> >> >> >> >> >> > the
> >> >> >> >> >> > server.
> >> >> >> >> >> >
> >> >> >> >> >> > IIS has been installed. When it came time to install
> >> >> >> >> >> > SQL2005
> >> >> >> >> >> > I
> >> >> >> >> >> > had
> >> >> >> >> >> > a
> >> >> >> >> >> > few
> >> >> >> >> >> > moments of confusion. I am used to installing SQL2005
> >> >> >> >> >> > Express
> >> >> >> >> >> > which
> >> >> >> >> >> > seems
> >> >> >> >> >> > to
> >> >> >> >> >> > automatically install a named instance. In this case I
> >> >> >> >> >> > manually
> >> >> >> >> >> > selected
> >> >> >> >> >> > a
> >> >> >> >> >> > named instance (RS2005) because the wording of the screen
> >> >> >> >> >> > seemed
> >> >> >> >> >> > to
> >> >> >> >> >> > imply
> >> >> >> >> >> > that the default instance of SQL2000 would be upgraded
> >> >> >> >> >> > (which
> >> >> >> >> >> > wouldn't
> >> >> >> >> >> > be
> >> >> >> >> >> > a
> >> >> >> >> >> > good idea.)
> >> >> >> >> >> >
> >> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
> >> >> >> >> >> > Studio.
> >> >> >> >> >> > I
> >> >> >> >> >> > copied
> >> >> >> >> >> > over the report I wanted to deploy. Now my problem is that
> >> >> >> >> >> > I
> >> >> >> >> >> > cannot
> >> >> >> >> >> > get
> >> >> >> >> >> > it
> >> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
> >> >> >> >> >> > connection
> >> >> >> >> >> > errors:
> >> >> >> >> >> > 'A
> >> >> >> >> >> > connection could not be made to the report server
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
> >> >> >> >> >> > information -
> >> >> >> >> >> > The
> >> >> >> >> >> > attempt
> >> >> >> >> >> > to connect to the report server failed. Check your
> >> >> >> >> >> > connection
> >> >> >> >> >> > information,
> >> >> >> >> >> > etc.'
> >> >> >> >> >> >
> >> >> >> >> >> > I have run the Reporting Services Configuration manager.
> >> >> >> >> >> > To
> >> >> >> >> >> > save
> >> >> >> >> >> > time,
> >> >> >> >> >> > here
> >> >> >> >> >> > are the settings:
> >> >> >> >> >> > Report Server Status
> >> >> >> >> >> > Instance Name RS2005
> >> >> >> >> >> > Instance ID MSSQL.2
> >> >> >> >> >> > Running
> >> >> >> >> >> >
> >> >> >> >> >> > --
> >> >> >> >> >> >
> >> >> >> >> >> > Report Server Virtual Directory
> >> >> >> >> >> > Name ReportServer$RS2005
> >> >> >> >> >> > Website Default Website
> >> >> >> >> >> >
> >> >> >> >> >> > Report Manager Virtual Directory Settings
> >> >> >> >> >> > Name Reports$RS2005
> >> >> >> >> >> > Website Default Web Site
> >> >> >> >> >> >
> >> >> >> >> >> > Windows Service Identity
> >> >> >> >> >> > Service Nmae ReportServer$RS2005
> >> >> >> >> >> > Service Account LocalSystem
> >> >> >> >> >> > Built-in Account Local System
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>|||I probably forgot to mention: This server is part of a very large corporate
network, all regulated (so far as I know) using Active Directory. I have no
hands-on experience with Active Directory. Could this complicate the RS
configuration?
"Bruce L-C [MVP]" wrote:
> If the RS configuration tool shows everything good it should not be a
> problem.
> I have never seen this error.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:23A2FD03-F2FF-4D94-A851-C2C6921C0A4A@.microsoft.com...
> > Now what. Am I forgetting some option when running RS off SQL 2000? Got
> > a
> > very different error.
> >
> > The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
> >
> > <%@. Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.Folde
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Can you see Report Manager. That is the first thing you need to do.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
> >> > Ok I did that and now I've got new problems.
> >> >
> >> > I reinstalled without creating a SQL2005 db. I went through the RS
> >> > Config
> >> > manager using only defaults and the DBs appear to have been created
> >> > successfully under the SQL2000 server.
> >> >
> >> > Now when I try to deploy the report using VS/BI, I get an error: A
> >> > connection could not be made to the report server
> >> > http://localhost/ReportServer. Additional Information: Client found
> >> > response
> >> > content type of 'text/html; charset=utf-8', but expected 'text/xml'.
> >> > The
> >> > request failed with the error message: '
> >> >
> >> > The rest is too long to type here (looks like a big piece of HTML or
> >> > XML)
> >> > but the system event log is full of error messages like this: The
> >> > application-specific permission settings do not grant Local Activation
> >> > permission for the COM Server application with CLSID
> >> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> >> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> >> > permission can be modified using the Component Services administrative
> >> > tool.
> >> >
> >> > Could this have something to do with the fact that I wrote the report
> >> > on
> >> > my
> >> > desktop and then copied the entire project over to the server?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> My suggestion is to do that and this time do not create SQL Server
> >> >> 2005
> >> >> database. Just point it to an existing SQL Server 2000 db that you
> >> >> have.
> >> >> There is no advantage to the added complexity of what you were doing.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> >> >> > Maybe I should just uninstall everything and start over.
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> You have somehow gotten a totally messed up install. You should not
> >> >> >> have
> >> >> >> four sites. Try this:
> >> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> >> >> >> > By 'websites' do you mean the report directories under Default
> >> >> >> > Web
> >> >> >> > Site?
> >> >> >> >
> >> >> >> > I have 4 report directories under the Default Web Site:
> >> >> >> > ReportServer,
> >> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2
> >> >> >> > are
> >> >> >> > empty.
> >> >> >> > The last two are full of what appears to be asp.net related files
> >> >> >> > and
> >> >> >> > directories.
> >> >> >> >
> >> >> >> > (I admit that I was under the impression that RS2005 needed a
> >> >> >> > 2005
> >> >> >> > db
> >> >> >> > to
> >> >> >> > store its data.)
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> By what you posted it seems that you have it installed in the
> >> >> >> >> default
> >> >> >> >> website in which case this should be working. Open up IIS
> >> >> >> >> adminstrator
> >> >> >> >> (whatever it is called) and see if you have the websites.
> >> >> >> >>
> >> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can
> >> >> >> >> use
> >> >> >> >> SQL
> >> >> >> >> 2000
> >> >> >> >> for its object/metadata storage. You have to have a license for
> >> >> >> >> SQL
> >> >> >> >> Server
> >> >> >> >> 2005 but it does not need to be installed.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> >> >> >> > No. I've tried both on the server itself and from another
> >> >> >> >> > machine.
> >> >> >> >> > Always
> >> >> >> >> > 'Page cannot be found.'
> >> >> >> >> >
> >> >> >> >> > (Tried with both http://<servername>/Reports and
> >> >> >> >> > http://<servername>/Reports$RS2005)
> >> >> >> >> >
> >> >> >> >> > As far as I know I'm an administrator.
> >> >> >> >> >
> >> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >> >
> >> >> >> >> >> First things first. Can you pull up Report Manager (this is
> >> >> >> >> >> the
> >> >> >> >> >> portal
> >> >> >> >> >> that
> >> >> >> >> >> ships with RS and is used to manage RS).
> >> >> >> >> >>
> >> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >> >> >> >>
> >> >> >> >> >> localhost only works if you are on the machine hosting RS.
> >> >> >> >> >>
> >> >> >> >> >> Second, are you an adminstrator on that machine. All people
> >> >> >> >> >> in
> >> >> >> >> >> the
> >> >> >> >> >> local
> >> >> >> >> >> administrator group on the machine that has RS installed will
> >> >> >> >> >> automatically
> >> >> >> >> >> be in the RS administrators role.
> >> >> >> >> >>
> >> >> >> >> >> Deploying is the last thing you should try.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> >> message
> >> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
> >> >> >> >> >> > I'm
> >> >> >> >> >> > doing.
> >> >> >> >> >> >
> >> >> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
> >> >> >> >> >> > Server
> >> >> >> >> >> > 2000.
> >> >> >> >> >> > We want to run a Reporting Services report off one of the
> >> >> >> >> >> > tables
> >> >> >> >> >> > in
> >> >> >> >> >> > SQL
> >> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
> >> >> >> >> >> > including
> >> >> >> >> >> > RS
> >> >> >> >> >> > on
> >> >> >> >> >> > the
> >> >> >> >> >> > server.
> >> >> >> >> >> >
> >> >> >> >> >> > IIS has been installed. When it came time to install
> >> >> >> >> >> > SQL2005
> >> >> >> >> >> > I
> >> >> >> >> >> > had
> >> >> >> >> >> > a
> >> >> >> >> >> > few
> >> >> >> >> >> > moments of confusion. I am used to installing SQL2005
> >> >> >> >> >> > Express
> >> >> >> >> >> > which
> >> >> >> >> >> > seems
> >> >> >> >> >> > to
> >> >> >> >> >> > automatically install a named instance. In this case I
> >> >> >> >> >> > manually
> >> >> >> >> >> > selected
> >> >> >> >> >> > a
> >> >> >> >> >> > named instance (RS2005) because the wording of the screen
> >> >> >> >> >> > seemed
> >> >> >> >> >> > to
> >> >> >> >> >> > imply
> >> >> >> >> >> > that the default instance of SQL2000 would be upgraded
> >> >> >> >> >> > (which
> >> >> >> >> >> > wouldn't
> >> >> >> >> >> > be
> >> >> >> >> >> > a
> >> >> >> >> >> > good idea.)
> >> >> >> >> >> >
> >> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
> >> >> >> >> >> > Studio.
> >> >> >> >> >> > I
> >> >> >> >> >> > copied
> >> >> >> >> >> > over the report I wanted to deploy. Now my problem is that
> >> >> >> >> >> > I
> >> >> >> >> >> > cannot
> >> >> >> >> >> > get
> >> >> >> >> >> > it
> >> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
> >> >> >> >> >> > connection
> >> >> >> >> >> > errors:
> >> >> >> >> >> > 'A
> >> >> >> >> >> > connection could not be made to the report server
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
> >> >> >> >> >> > information -
> >> >> >> >> >> > The
> >> >> >> >> >> > attempt
> >> >> >> >> >> > to connect to the report server failed. Check your
> >> >> >> >> >> > connection
> >> >> >> >> >> > information,
> >> >> >> >> >> > etc.'
> >> >> >> >> >> >
> >> >> >> >> >> > I have run the Reporting Services Configuration manager.
> >> >> >> >> >> > To
> >> >> >> >> >> > save
> >> >> >> >> >> > time,
> >> >> >> >> >> > here
> >> >> >> >> >> > are the settings:
> >> >> >> >> >> > Report Server Status
> >> >> >> >> >> > Instance Name RS2005
> >> >> >> >> >> > Instance ID MSSQL.2
> >> >> >> >> >> > Running
> >> >> >> >> >> >
> >> >> >> >> >> > --
> >> >> >> >> >> >
> >> >> >> >> >> > Report Server Virtual Directory
> >> >> >> >> >> > Name ReportServer$RS2005
> >> >> >> >> >> > Website Default Website
> >> >> >> >> >> >
> >> >> >> >> >> > Report Manager Virtual Directory Settings
> >> >> >> >> >> > Name Reports$RS2005
> >> >> >> >> >> > Website Default Web Site
> >> >> >> >> >> >
> >> >> >> >> >> > Windows Service Identity
> >> >> >> >> >> > Service Nmae ReportServer$RS2005
> >> >> >> >> >> > Service Account LocalSystem
> >> >> >> >> >> > Built-in Account Local System
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>|||Stop the presses!!! I have solved the problem of the missing Folder page and
the report is now successsfully deployed!!!!
The problem is not in RS. The problem is that the Dot Net Framework was
installed on the Windows 2003 server before the IIS component was installed.
The solution was simple:
"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i"
Looks like I have a few brain cells left.
"Bruce L-C [MVP]" wrote:
> If the RS configuration tool shows everything good it should not be a
> problem.
> I have never seen this error.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> news:23A2FD03-F2FF-4D94-A851-C2C6921C0A4A@.microsoft.com...
> > Now what. Am I forgetting some option when running RS off SQL 2000? Got
> > a
> > very different error.
> >
> > The XML page cannot be displayed
> > Cannot view XML input using XSL style sheet. Please correct the error and
> > then click the Refresh button, or try again later.
> >
> >
> > ----
> >
> > A name was started with an invalid character. Error processing resource
> > 'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
> >
> > <%@. Page language="c#" Codebehind="Folder.aspx.cs" AutoEventWireup="false"
> > Inherits="Microsoft.ReportingServices.UI.Folde
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Can you see Report Manager. That is the first thing you need to do.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
> >> > Ok I did that and now I've got new problems.
> >> >
> >> > I reinstalled without creating a SQL2005 db. I went through the RS
> >> > Config
> >> > manager using only defaults and the DBs appear to have been created
> >> > successfully under the SQL2000 server.
> >> >
> >> > Now when I try to deploy the report using VS/BI, I get an error: A
> >> > connection could not be made to the report server
> >> > http://localhost/ReportServer. Additional Information: Client found
> >> > response
> >> > content type of 'text/html; charset=utf-8', but expected 'text/xml'.
> >> > The
> >> > request failed with the error message: '
> >> >
> >> > The rest is too long to type here (looks like a big piece of HTML or
> >> > XML)
> >> > but the system event log is full of error messages like this: The
> >> > application-specific permission settings do not grant Local Activation
> >> > permission for the COM Server application with CLSID
> >> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
> >> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security
> >> > permission can be modified using the Component Services administrative
> >> > tool.
> >> >
> >> > Could this have something to do with the fact that I wrote the report
> >> > on
> >> > my
> >> > desktop and then copied the entire project over to the server?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> My suggestion is to do that and this time do not create SQL Server
> >> >> 2005
> >> >> database. Just point it to an existing SQL Server 2000 db that you
> >> >> have.
> >> >> There is no advantage to the added complexity of what you were doing.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
> >> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
> >> >> > Maybe I should just uninstall everything and start over.
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> You have somehow gotten a totally messed up install. You should not
> >> >> >> have
> >> >> >> four sites. Try this:
> >> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
> >> >> >> > By 'websites' do you mean the report directories under Default
> >> >> >> > Web
> >> >> >> > Site?
> >> >> >> >
> >> >> >> > I have 4 report directories under the Default Web Site:
> >> >> >> > ReportServer,
> >> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2
> >> >> >> > are
> >> >> >> > empty.
> >> >> >> > The last two are full of what appears to be asp.net related files
> >> >> >> > and
> >> >> >> > directories.
> >> >> >> >
> >> >> >> > (I admit that I was under the impression that RS2005 needed a
> >> >> >> > 2005
> >> >> >> > db
> >> >> >> > to
> >> >> >> > store its data.)
> >> >> >> >
> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >
> >> >> >> >> By what you posted it seems that you have it installed in the
> >> >> >> >> default
> >> >> >> >> website in which case this should be working. Open up IIS
> >> >> >> >> adminstrator
> >> >> >> >> (whatever it is called) and see if you have the websites.
> >> >> >> >>
> >> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can
> >> >> >> >> use
> >> >> >> >> SQL
> >> >> >> >> 2000
> >> >> >> >> for its object/metadata storage. You have to have a license for
> >> >> >> >> SQL
> >> >> >> >> Server
> >> >> >> >> 2005 but it does not need to be installed.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> --
> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >>
> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> message
> >> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
> >> >> >> >> > No. I've tried both on the server itself and from another
> >> >> >> >> > machine.
> >> >> >> >> > Always
> >> >> >> >> > 'Page cannot be found.'
> >> >> >> >> >
> >> >> >> >> > (Tried with both http://<servername>/Reports and
> >> >> >> >> > http://<servername>/Reports$RS2005)
> >> >> >> >> >
> >> >> >> >> > As far as I know I'm an administrator.
> >> >> >> >> >
> >> >> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >> >> >
> >> >> >> >> >> First things first. Can you pull up Report Manager (this is
> >> >> >> >> >> the
> >> >> >> >> >> portal
> >> >> >> >> >> that
> >> >> >> >> >> ships with RS and is used to manage RS).
> >> >> >> >> >>
> >> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
> >> >> >> >> >>
> >> >> >> >> >> localhost only works if you are on the machine hosting RS.
> >> >> >> >> >>
> >> >> >> >> >> Second, are you an adminstrator on that machine. All people
> >> >> >> >> >> in
> >> >> >> >> >> the
> >> >> >> >> >> local
> >> >> >> >> >> administrator group on the machine that has RS installed will
> >> >> >> >> >> automatically
> >> >> >> >> >> be in the RS administrators role.
> >> >> >> >> >>
> >> >> >> >> >> Deploying is the last thing you should try.
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> --
> >> >> >> >> >> Bruce Loehle-Conger
> >> >> >> >> >> MVP SQL Server Reporting Services
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
> >> >> >> >> >> message
> >> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
> >> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know what
> >> >> >> >> >> > I'm
> >> >> >> >> >> > doing.
> >> >> >> >> >> >
> >> >> >> >> >> > We have a legacy server running Windows Server 2003 and Sql
> >> >> >> >> >> > Server
> >> >> >> >> >> > 2000.
> >> >> >> >> >> > We want to run a Reporting Services report off one of the
> >> >> >> >> >> > tables
> >> >> >> >> >> > in
> >> >> >> >> >> > SQL
> >> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
> >> >> >> >> >> > including
> >> >> >> >> >> > RS
> >> >> >> >> >> > on
> >> >> >> >> >> > the
> >> >> >> >> >> > server.
> >> >> >> >> >> >
> >> >> >> >> >> > IIS has been installed. When it came time to install
> >> >> >> >> >> > SQL2005
> >> >> >> >> >> > I
> >> >> >> >> >> > had
> >> >> >> >> >> > a
> >> >> >> >> >> > few
> >> >> >> >> >> > moments of confusion. I am used to installing SQL2005
> >> >> >> >> >> > Express
> >> >> >> >> >> > which
> >> >> >> >> >> > seems
> >> >> >> >> >> > to
> >> >> >> >> >> > automatically install a named instance. In this case I
> >> >> >> >> >> > manually
> >> >> >> >> >> > selected
> >> >> >> >> >> > a
> >> >> >> >> >> > named instance (RS2005) because the wording of the screen
> >> >> >> >> >> > seemed
> >> >> >> >> >> > to
> >> >> >> >> >> > imply
> >> >> >> >> >> > that the default instance of SQL2000 would be upgraded
> >> >> >> >> >> > (which
> >> >> >> >> >> > wouldn't
> >> >> >> >> >> > be
> >> >> >> >> >> > a
> >> >> >> >> >> > good idea.)
> >> >> >> >> >> >
> >> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
> >> >> >> >> >> > Studio.
> >> >> >> >> >> > I
> >> >> >> >> >> > copied
> >> >> >> >> >> > over the report I wanted to deploy. Now my problem is that
> >> >> >> >> >> > I
> >> >> >> >> >> > cannot
> >> >> >> >> >> > get
> >> >> >> >> >> > it
> >> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
> >> >> >> >> >> > connection
> >> >> >> >> >> > errors:
> >> >> >> >> >> > 'A
> >> >> >> >> >> > connection could not be made to the report server
> >> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
> >> >> >> >> >> > information -
> >> >> >> >> >> > The
> >> >> >> >> >> > attempt
> >> >> >> >> >> > to connect to the report server failed. Check your
> >> >> >> >> >> > connection
> >> >> >> >> >> > information,
> >> >> >> >> >> > etc.'
> >> >> >> >> >> >
> >> >> >> >> >> > I have run the Reporting Services Configuration manager.
> >> >> >> >> >> > To
> >> >> >> >> >> > save
> >> >> >> >> >> > time,
> >> >> >> >> >> > here
> >> >> >> >> >> > are the settings:
> >> >> >> >> >> > Report Server Status
> >> >> >> >> >> > Instance Name RS2005
> >> >> >> >> >> > Instance ID MSSQL.2
> >> >> >> >> >> > Running
> >> >> >> >> >> >
> >> >> >> >> >> > --
> >> >> >> >> >> >
> >> >> >> >> >> > Report Server Virtual Directory
> >> >> >> >> >> > Name ReportServer$RS2005
> >> >> >> >> >> > Website Default Website
> >> >> >> >> >> >
> >> >> >> >> >> > Report Manager Virtual Directory Settings
> >> >> >> >> >> > Name Reports$RS2005
> >> >> >> >> >> > Website Default Web Site
> >> >> >> >> >> >
> >> >> >> >> >> > Windows Service Identity
> >> >> >> >> >> > Service Nmae ReportServer$RS2005
> >> >> >> >> >> > Service Account LocalSystem
> >> >> >> >> >> > Built-in Account Local System
> >> >> >> >> >> >
> >> >> >> >> >> >
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>|||Interesting. I would have thought the act of installing would have detected
and installed/configured IIS for the 2.0 framework. I guess the installer
thought everything was OK when it was not.
Glad to hear it is all OK now. One benefit. You have a simplier environment
running without SQL 2005 database and just using the 2000 database already
installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
news:43FC7545-4619-4E0E-8F06-9B9E2D6AF466@.microsoft.com...
> Stop the presses!!! I have solved the problem of the missing Folder page
> and
> the report is now successsfully deployed!!!!
> The problem is not in RS. The problem is that the Dot Net Framework was
> installed on the Windows 2003 server before the IIS component was
> installed.
> The solution was simple:
> "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i"
> Looks like I have a few brain cells left.
> "Bruce L-C [MVP]" wrote:
>> If the RS configuration tool shows everything good it should not be a
>> problem.
>> I have never seen this error.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> news:23A2FD03-F2FF-4D94-A851-C2C6921C0A4A@.microsoft.com...
>> > Now what. Am I forgetting some option when running RS off SQL 2000?
>> > Got
>> > a
>> > very different error.
>> >
>> > The XML page cannot be displayed
>> > Cannot view XML input using XSL style sheet. Please correct the error
>> > and
>> > then click the Refresh button, or try again later.
>> >
>> >
>> > ----
>> >
>> > A name was started with an invalid character. Error processing resource
>> > 'http://ussog-s-a000002/Reports/Pages/Folder.aspx'...
>> >
>> > <%@. Page language="c#" Codebehind="Folder.aspx.cs"
>> > AutoEventWireup="false"
>> > Inherits="Microsoft.ReportingServices.UI.Folde
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Can you see Report Manager. That is the first thing you need to do.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in message
>> >> news:22ACC894-897A-4C62-A25D-AB116C07BD7D@.microsoft.com...
>> >> > Ok I did that and now I've got new problems.
>> >> >
>> >> > I reinstalled without creating a SQL2005 db. I went through the RS
>> >> > Config
>> >> > manager using only defaults and the DBs appear to have been created
>> >> > successfully under the SQL2000 server.
>> >> >
>> >> > Now when I try to deploy the report using VS/BI, I get an error: A
>> >> > connection could not be made to the report server
>> >> > http://localhost/ReportServer. Additional Information: Client found
>> >> > response
>> >> > content type of 'text/html; charset=utf-8', but expected 'text/xml'.
>> >> > The
>> >> > request failed with the error message: '
>> >> >
>> >> > The rest is too long to type here (looks like a big piece of HTML or
>> >> > XML)
>> >> > but the system event log is full of error messages like this: The
>> >> > application-specific permission settings do not grant Local
>> >> > Activation
>> >> > permission for the COM Server application with CLSID
>> >> > {BA126AD1-2166-11D1-B1D0-00805FC1270E}
>> >> > to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This
>> >> > security
>> >> > permission can be modified using the Component Services
>> >> > administrative
>> >> > tool.
>> >> >
>> >> > Could this have something to do with the fact that I wrote the
>> >> > report
>> >> > on
>> >> > my
>> >> > desktop and then copied the entire project over to the server?
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> My suggestion is to do that and this time do not create SQL Server
>> >> >> 2005
>> >> >> database. Just point it to an existing SQL Server 2000 db that you
>> >> >> have.
>> >> >> There is no advantage to the added complexity of what you were
>> >> >> doing.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:F5CFAD3D-6221-4DAB-923B-863B88E0D5BA@.microsoft.com...
>> >> >> > Maybe I should just uninstall everything and start over.
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> You have somehow gotten a totally messed up install. You should
>> >> >> >> not
>> >> >> >> have
>> >> >> >> four sites. Try this:
>> >> >> >> http://yourservername/Reports$RS2005/Reports/Pages/Folder.aspx
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> >> message
>> >> >> >> news:D65947A7-6E16-4331-8810-D59BBEE1487C@.microsoft.com...
>> >> >> >> > By 'websites' do you mean the report directories under Default
>> >> >> >> > Web
>> >> >> >> > Site?
>> >> >> >> >
>> >> >> >> > I have 4 report directories under the Default Web Site:
>> >> >> >> > ReportServer,
>> >> >> >> > Reports, Reports$RS2005, and ReportServer$RS2005. The first 2
>> >> >> >> > are
>> >> >> >> > empty.
>> >> >> >> > The last two are full of what appears to be asp.net related
>> >> >> >> > files
>> >> >> >> > and
>> >> >> >> > directories.
>> >> >> >> >
>> >> >> >> > (I admit that I was under the impression that RS2005 needed a
>> >> >> >> > 2005
>> >> >> >> > db
>> >> >> >> > to
>> >> >> >> > store its data.)
>> >> >> >> >
>> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >
>> >> >> >> >> By what you posted it seems that you have it installed in the
>> >> >> >> >> default
>> >> >> >> >> website in which case this should be working. Open up IIS
>> >> >> >> >> adminstrator
>> >> >> >> >> (whatever it is called) and see if you have the websites.
>> >> >> >> >>
>> >> >> >> >> By the way, you did not need to install SQL 2005. RS 2005 can
>> >> >> >> >> use
>> >> >> >> >> SQL
>> >> >> >> >> 2000
>> >> >> >> >> for its object/metadata storage. You have to have a license
>> >> >> >> >> for
>> >> >> >> >> SQL
>> >> >> >> >> Server
>> >> >> >> >> 2005 but it does not need to be installed.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> --
>> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >>
>> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote in
>> >> >> >> >> message
>> >> >> >> >> news:BD671A1B-82BA-466C-B6A0-7A73EB6B3FFA@.microsoft.com...
>> >> >> >> >> > No. I've tried both on the server itself and from another
>> >> >> >> >> > machine.
>> >> >> >> >> > Always
>> >> >> >> >> > 'Page cannot be found.'
>> >> >> >> >> >
>> >> >> >> >> > (Tried with both http://<servername>/Reports and
>> >> >> >> >> > http://<servername>/Reports$RS2005)
>> >> >> >> >> >
>> >> >> >> >> > As far as I know I'm an administrator.
>> >> >> >> >> >
>> >> >> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >> >> >
>> >> >> >> >> >> First things first. Can you pull up Report Manager (this
>> >> >> >> >> >> is
>> >> >> >> >> >> the
>> >> >> >> >> >> portal
>> >> >> >> >> >> that
>> >> >> >> >> >> ships with RS and is used to manage RS).
>> >> >> >> >> >>
>> >> >> >> >> >> http://yourservername/Reports/Pages/Folder.aspx
>> >> >> >> >> >>
>> >> >> >> >> >> localhost only works if you are on the machine hosting RS.
>> >> >> >> >> >>
>> >> >> >> >> >> Second, are you an adminstrator on that machine. All
>> >> >> >> >> >> people
>> >> >> >> >> >> in
>> >> >> >> >> >> the
>> >> >> >> >> >> local
>> >> >> >> >> >> administrator group on the machine that has RS installed
>> >> >> >> >> >> will
>> >> >> >> >> >> automatically
>> >> >> >> >> >> be in the RS administrators role.
>> >> >> >> >> >>
>> >> >> >> >> >> Deploying is the last thing you should try.
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> --
>> >> >> >> >> >> Bruce Loehle-Conger
>> >> >> >> >> >> MVP SQL Server Reporting Services
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >> "B. Chernick" <BChernick@.discussions.microsoft.com> wrote
>> >> >> >> >> >> in
>> >> >> >> >> >> message
>> >> >> >> >> >> news:B0ABE746-24C8-4D92-9952-776C52F6EF9D@.microsoft.com...
>> >> >> >> >> >> > As usual I'm learning by doing and I'm not sure I know
>> >> >> >> >> >> > what
>> >> >> >> >> >> > I'm
>> >> >> >> >> >> > doing.
>> >> >> >> >> >> >
>> >> >> >> >> >> > We have a legacy server running Windows Server 2003 and
>> >> >> >> >> >> > Sql
>> >> >> >> >> >> > Server
>> >> >> >> >> >> > 2000.
>> >> >> >> >> >> > We want to run a Reporting Services report off one of
>> >> >> >> >> >> > the
>> >> >> >> >> >> > tables
>> >> >> >> >> >> > in
>> >> >> >> >> >> > SQL
>> >> >> >> >> >> > Server 2000 so I was told to install SQL2005 Standard
>> >> >> >> >> >> > including
>> >> >> >> >> >> > RS
>> >> >> >> >> >> > on
>> >> >> >> >> >> > the
>> >> >> >> >> >> > server.
>> >> >> >> >> >> >
>> >> >> >> >> >> > IIS has been installed. When it came time to install
>> >> >> >> >> >> > SQL2005
>> >> >> >> >> >> > I
>> >> >> >> >> >> > had
>> >> >> >> >> >> > a
>> >> >> >> >> >> > few
>> >> >> >> >> >> > moments of confusion. I am used to installing SQL2005
>> >> >> >> >> >> > Express
>> >> >> >> >> >> > which
>> >> >> >> >> >> > seems
>> >> >> >> >> >> > to
>> >> >> >> >> >> > automatically install a named instance. In this case I
>> >> >> >> >> >> > manually
>> >> >> >> >> >> > selected
>> >> >> >> >> >> > a
>> >> >> >> >> >> > named instance (RS2005) because the wording of the
>> >> >> >> >> >> > screen
>> >> >> >> >> >> > seemed
>> >> >> >> >> >> > to
>> >> >> >> >> >> > imply
>> >> >> >> >> >> > that the default instance of SQL2000 would be upgraded
>> >> >> >> >> >> > (which
>> >> >> >> >> >> > wouldn't
>> >> >> >> >> >> > be
>> >> >> >> >> >> > a
>> >> >> >> >> >> > good idea.)
>> >> >> >> >> >> >
>> >> >> >> >> >> > So I installed SQL2005 with a named instance and the BI
>> >> >> >> >> >> > Studio.
>> >> >> >> >> >> > I
>> >> >> >> >> >> > copied
>> >> >> >> >> >> > over the report I wanted to deploy. Now my problem is
>> >> >> >> >> >> > that
>> >> >> >> >> >> > I
>> >> >> >> >> >> > cannot
>> >> >> >> >> >> > get
>> >> >> >> >> >> > it
>> >> >> >> >> >> > to deploy. In BI/VS the TargetServerURL is
>> >> >> >> >> >> > http://localhost/ReportServer$RS2005. All I get are
>> >> >> >> >> >> > connection
>> >> >> >> >> >> > errors:
>> >> >> >> >> >> > 'A
>> >> >> >> >> >> > connection could not be made to the report server
>> >> >> >> >> >> > http://localhost/ReportServer$RS2005. Additional
>> >> >> >> >> >> > information -
>> >> >> >> >> >> > The
>> >> >> >> >> >> > attempt
>> >> >> >> >> >> > to connect to the report server failed. Check your
>> >> >> >> >> >> > connection
>> >> >> >> >> >> > information,
>> >> >> >> >> >> > etc.'
>> >> >> >> >> >> >
>> >> >> >> >> >> > I have run the Reporting Services Configuration manager.
>> >> >> >> >> >> > To
>> >> >> >> >> >> > save
>> >> >> >> >> >> > time,
>> >> >> >> >> >> > here
>> >> >> >> >> >> > are the settings:
>> >> >> >> >> >> > Report Server Status
>> >> >> >> >> >> > Instance Name RS2005
>> >> >> >> >> >> > Instance ID MSSQL.2
>> >> >> >> >> >> > Running
>> >> >> >> >> >> >
>> >> >> >> >> >> > --
>> >> >> >> >> >> >
>> >> >> >> >> >> > Report Server Virtual Directory
>> >> >> >> >> >> > Name ReportServer$RS2005
>> >> >> >> >> >> > Website Default Website
>> >> >> >> >> >> >
>> >> >> >> >> >> > Report Manager Virtual Directory Settings
>> >> >> >> >> >> > Name Reports$RS2005
>> >> >> >> >> >> > Website Default Web Site
>> >> >> >> >> >> >
>> >> >> >> >> >> > Windows Service Identity
>> >> >> >> >> >> > Service Nmae ReportServer$RS2005
>> >> >> >> >> >> > Service Account LocalSystem
>> >> >> >> >> >> > Built-in Account Local System
>> >> >> >> >> >> >
>> >> >> >> >> >> >
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment