install on a new server

Currently we have SQL server reporting services running on a win 2000 server
running IIS. I need to move the reporting services to a new server running
win 2003 w/ IIS. How do I go about installing this on the new server and
keeping the old settings and reports.
thanks
mikeSimulate a Farm installation , then de-activate the first node.
1. Install another Reporting Services on the new server, pointing to the
existing SQL Server repository. When setup is complete, you should see all of
your reports through that server, since the repository (database) is the
same. During the install , you will be taken through a (web farm) setup
screen that is slightly different then a regular stand-alone install. On that
screen you have to specifiy the new server . Do that.
2. after verifiing that you are able to access your reports throught the new
server via the browser, go ahead and de-activate the first node by deleting
rows 2 and 3 from the keys tables in the ReportServer database (the metabase
repository at this point will think it has only one server) , after that
restart the new report server.
3. Take the first RS sever offline. You have successfully performed the
migration.
"Mike Fremont" wrote:
> Currently we have SQL server reporting services running on a win 2000 server
> running IIS. I need to move the reporting services to a new server running
> win 2003 w/ IIS. How do I go about installing this on the new server and
> keeping the old settings and reports.
> thanks
> mike|||Note that this only works if you are using RS Enterprise (web farm does not
work with standard).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nick" <Nick@.discussions.microsoft.com> wrote in message
news:A162A01B-ED4F-48A5-A149-6C658EACFE9A@.microsoft.com...
> Simulate a Farm installation , then de-activate the first node.
> 1. Install another Reporting Services on the new server, pointing to the
> existing SQL Server repository. When setup is complete, you should see all
of
> your reports through that server, since the repository (database) is the
> same. During the install , you will be taken through a (web farm) setup
> screen that is slightly different then a regular stand-alone install. On
that
> screen you have to specifiy the new server . Do that.
> 2. after verifiing that you are able to access your reports throught the
new
> server via the browser, go ahead and de-activate the first node by
deleting
> rows 2 and 3 from the keys tables in the ReportServer database (the
metabase
> repository at this point will think it has only one server) , after that
> restart the new report server.
> 3. Take the first RS sever offline. You have successfully performed the
> migration.
>
> "Mike Fremont" wrote:
> > Currently we have SQL server reporting services running on a win 2000
server
> > running IIS. I need to move the reporting services to a new server
running
> > win 2003 w/ IIS. How do I go about installing this on the new server
and
> > keeping the old settings and reports.
> >
> > thanks
> > mikesql

Install Help

Hello:
I am new to Reporting Services and I am having a problem displayingReporting Manager. I am running Win 2003 with IIS 6 and SQL Svr2000 SP3. VS 2003 has been installed and the developmentenvironment works fine.
I cannot get Report Manager to work I try to access the page and I get the following error:
Error
The request failed with HTTP Status 400: Bad Request
Their is a link for Home but when I click on it I get the same message.
When I try to access Report Server using //servername/reportmanager, Iget prompted for a user name and password. I put in thecredentials for a local admin and it brings me to a page that has the servername/reportserver. At the bottom is some versioninformation and that's all there is.
I have researched and tried a variety a solutions like running reactivate and rsconfig to no avail.
IIS is set up with a reports website and 2 virtual dorectories, onepointing to the appropriate folder in the MSSQL folder for reportmanager and report server.
I'm out of idea. If anyone can provide some ways I can troubleshoot, I would appreciate it
Brennan
Did you have the SSL option unchecked while you were installing the RS ? or are you using SSL ?|||The SSL option was unchecked.
Thanks
|||sorry I am out of ideas too..it was a big hassle for me when I first downloaded Rs and tried to get it work..and I do remember being popped up with username/pwd but I cant remember what xactly I did ..I had to set up forms based authentication so I followedthis article.see if that will help.|||Thanks

Install Error 1603

I am getting the install error 1603 with ignore greyed out.
I am trying to install reporting services enterprise edition onto server
running
WIN 2003 with SQL server 2000.
I am installing it without VS.NET installed and
The .Net Framework has been installed
I have looked at http://support.microsoft.com/?kbid=867872 but I still get
the same error.
I even reinstalled the IIS 6.0. ASP.NET 1.1.4322 is registered with IIS.
I have changed the SQL Server instance used to host the report server
database to Local.
I have been busy installing it at a client for 2 days now.
I have a local version that installed without giving any problems.
Can someone please tell me how to get it installed?Hi,
I had this problem already with one of our customers. Their IT department
did a really closed installation of a Windows 2003 Standard web server.
Now the solution which worked for me:
1. Take a look on the services: COM+ Event System -> enable and run it!
2. Open Administrative Tools->Component Services
- Navigate to Component Services->Computers->My Computer and right click on it
- On tab COM security add IWAM_MACHINE and IUSR_MACHINE to [Access
Permissions] and [Default Launch Permission] by clicking on Edit Defaults...
Now hopefully it should work!
John D''Eramo
IT Manager
"Wesley" wrote:
> I am getting the install error 1603 with ignore greyed out.
> I am trying to install reporting services enterprise edition onto server
> running
> WIN 2003 with SQL server 2000.
> I am installing it without VS.NET installed and
> The .Net Framework has been installed
> I have looked at http://support.microsoft.com/?kbid=867872 but I still get
> the same error.
> I even reinstalled the IIS 6.0. ASP.NET 1.1.4322 is registered with IIS.
> I have changed the SQL Server instance used to host the report server
> database to Local.
> I have been busy installing it at a client for 2 days now.
> I have a local version that installed without giving any problems.
> Can someone please tell me how to get it installed?
>

Inserting records into Postgres from SQL server 2k Using Openquery

Hello,
We have a set of tables in a MS SQL Server 2000, These tables are
updated via
PDA from external location using a sycronisation from a Win CE MS SQL
DB.
This is all fine, I have to create a trigger that will insert the
information from
SQL Server to Postgres. I done a bit of reading and found the OPENQUERY
command and have been able to read from the Postgres DB but as yet have
been unable to write insert records into postgres using this. I am
using only
varchar and int4 fields which from what i have read should be fine.
Does anyone have a example of a INSERT INTO over a linked server that i
can
use as a base plus any information of pitfalls that might be usefull to
know about.
I have included my query below along with the error message i have
received.
I have been tinkering for most of a day with this and this is that last
error i received.
--Query
SET QUOTED_IDENTIFIER OFF
SET XACT_ABORT ON
declare @.var varchar(20)
declare @.var1 varchar(20)
declare @.var2 varchar(20)
declare @.var3 varchar(20)
declare @.var4 int
declare @.var5 int
declare @.cmd varchar(4000)
set @.var = '066'
set @.var1 = '5'
set @.var2 = '081'
set @.var3 = 'PKJ8889999H'
set @.var4 = 100
set @.var5 = 10
SELECT @.cmd = "INSERT INTO openquery(MARGE,'select customer_id,
location_id, product_code, max_level, min_level from
MARGE.consign.dbo.cs_static WHERE 1=0')
VALUES ('" + @.var1 + "','" + @.var2 + "','" + @.var3 + "','100','10')"
exec (@.cmd)
commit tran
--Error
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give
any information about the error.
OLE DB error trace [Non-interface error: OLE DB provider MSDASQL
returned an incorrect value for DBPROP_CATALOGLOCATION which should be
either DBPROPVAL_CL_END or DBPROPVAL_CL_START].
OLE DB error trace [OLE/DB Provider 'MSDASQL'
IColumnsInfo::GetColumnsInfo returned 0x80004005: The provider did not
give any information about the error.].I know its bad form to reply to your own post but after a day and a
half i've
sorted it out. Below are my working queries in case anyone has similar
issues *shrug* works for me and standard disclaimer applys :)
thanks
David Phillips
SET QUOTED_IDENTIFIER OFF
SET XACT_ABORT ON
declare @.var1 varchar(20)
declare @.var2 varchar(20)
declare @.var3 varchar(20)
declare @.var4 varchar(20)
declare @.var5 varchar(20)
declare @.cmd varchar(4000)
set @.var1 = '68922'
set @.var2 = '122'
set @.var3 = 'KHG8889900H'
set @.var4 = '5000'
set @.var5 = '1500'
SELECT @.cmd = "INSERT INTO openquery(MARGE,'select customer_id,
location_id, product_code, max_level, min_level from consign.cs_static
WHERE 1=0')
VALUES ('" + @.var1 + "','" + @.var2 + "','" + @.var3 + "','" + @.var4 +
"','" + @.var5 + "')"
exec (@.cmd)
SELECT * FROM OPENQUERY (MARGE, 'select * from consign.cs_static')
delete from openquery(MARGE, 'select customer_id, location_id,
product_code, max_level, min_level from consign.cs_static')where
location_id = 122