Migrate Reporting Services Databases

I am upgrading the server that houses the SQL Reporting Services
databases (RSwwebservice, IIS and Report Manager are on another box).
The new server will have the same name (fqdn) as the old one.
Any issue with simply backin up the SQL RS dbs and restoring them the
new new server?
Thanks!Make sure to backup & restore the encryption key!
See also:
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_4915.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_dbadmin_v1_98xh.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106780668.274285.107650@.z14g2000cwz.googlegroups.com...
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>|||Thanks.
I am not moving the Reporting Services Front end (i.e IIS, Report
Manager, etc..) do I still need to backup/restore the encryption key?|||If you only move the backend database, but not the RS webservice it is not
required to backup and restore the encryption keys. Nonetheless, you should
always backup the keys right after installation of RS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1106840440.083283.232730@.c13g2000cwb.googlegroups.com...
> Thanks.
> I am not moving the Reporting Services Front end (i.e IIS, Report
> Manager, etc..) do I still need to backup/restore the encryption key?
>|||I am having a similar problem - we currently have sql server reporting server
and sql server standard on the same machine. I have loaded the sql reporting
services onto a new machine that also has sql server running. All I want to
do is move the database from the old machine to the new machine - when i do
the backup and restore i see the folders and all my reports but I can not run
any of the reports - i have tried to reactivate using rsactivate and rsconfig
without success. Can I just use DTS to copy the data from the old sql server
database to the new?
"Jim" wrote:
> I am upgrading the server that houses the SQL Reporting Services
> databases (RSwwebservice, IIS and Report Manager are on another box).
> The new server will have the same name (fqdn) as the old one.
> Any issue with simply backin up the SQL RS dbs and restoring them the
> new new server?
> Thanks!
>sql

Migrate database from MS Access to SQL Server 2000

Hi All,
I had installed Internet Information Sevices (IIS) on
Windows 2000 to simulate a web server. The ASP code to
open the Access database is:
Set db = Server.CreateObject("ADODB.Connection")
db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
&server.MapPath("../data/test.mdb")&";"
The code works fine on IIS and Access database. Then I
installed the SQL Server 2000 and changed the ASP code to:
Set db = Server.CreateObject("ADODB.Connection")
db.open "DRIVER={SQL
Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
dbsql="Y"
Where "myPC" is the computer name, "myPasswd" is the
password for user "sa". But the ASP code did not work.
Anything wrong?
Thanks in advance.> But the ASP code did not work.
You're going to have to be more specific.|||what error do u get'
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:063401c39b88$7ea843c0$a301280a@.phx.gbl...
> Hi All,
> I had installed Internet Information Sevices (IIS) on
> Windows 2000 to simulate a web server. The ASP code to
> open the Access database is:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> &server.MapPath("../data/test.mdb")&";"
> The code works fine on IIS and Access database. Then I
> installed the SQL Server 2000 and changed the ASP code to:
> Set db = Server.CreateObject("ADODB.Connection")
> db.open "DRIVER={SQL
> Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> dbsql="Y"
> Where "myPC" is the computer name, "myPasswd" is the
> password for user "sa". But the ASP code did not work.
> Anything wrong?
> Thanks in advance.
>|||Hi all,
Thanks for your kindness help.
The error message says:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation.
It is either closed or invalid in this context.
Which referred to the following code:
set rs=Server.CreateObject("ADODB.Recordset")
The reason is the database connection was not set up
successfully, where the cause was actually a typo in the
server name. It works now after I corrected it.
But thanks anyway!
Nancy
>--Original Message--
>Hi All,
>I had installed Internet Information Sevices (IIS) on
>Windows 2000 to simulate a web server. The ASP code to
>open the Access database is:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
>&server.MapPath("../data/test.mdb")&";"
>The code works fine on IIS and Access database. Then I
>installed the SQL Server 2000 and changed the ASP code to:
>Set db = Server.CreateObject("ADODB.Connection")
>db.open "DRIVER={SQL
>Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
>dbsql="Y"
>Where "myPC" is the computer name, "myPasswd" is the
>password for user "sa". But the ASP code did not work.
>Anything wrong?
>Thanks in advance.
>.
>|||did u open the connection
--
Shaju Thomas
"Nancy" <nlan2000@.hotmail.com> wrote in message
news:055a01c39d0b$9fc67390$a601280a@.phx.gbl...
> Hi all,
> Thanks for your kindness help.
> The error message says:
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
> Error Type:
> ADODB.Recordset (0x800A0E7D)
> The connection cannot be used to perform this operation.
> It is either closed or invalid in this context.
> Which referred to the following code:
> set rs=Server.CreateObject("ADODB.Recordset")
> The reason is the database connection was not set up
> successfully, where the cause was actually a typo in the
> server name. It works now after I corrected it.
> But thanks anyway!
> Nancy
>
> >--Original Message--
> >Hi All,
> >
> >I had installed Internet Information Sevices (IIS) on
> >Windows 2000 to simulate a web server. The ASP code to
> >open the Access database is:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "Driver={Microsoft Access Driver (*.mdb)}; DBQ="
> >&server.MapPath("../data/test.mdb")&";"
> >
> >The code works fine on IIS and Access database. Then I
> >installed the SQL Server 2000 and changed the ASP code to:
> >
> >Set db = Server.CreateObject("ADODB.Connection")
> >db.open "DRIVER={SQL
> >Server};SERVER=myPC;UID=sa;PWD=myPasswd;DATABASE=test"
> >dbsql="Y"
> >
> >Where "myPC" is the computer name, "myPasswd" is the
> >password for user "sa". But the ASP code did not work.
> >
> >Anything wrong?
> >
> >Thanks in advance.
> >
> >.
> >