Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
---
--
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
---
--
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type: Error
Event Source: Report Server
Event Category: Management
Event ID: 129
Date: 5/10/2004
Time: 12:11:11 PM
User: N/A
Computer: xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
AndrewI am not an expert with Reporting Services by any means...but have you =
tried to re-deploy the project? You will want to tell VS to overwrite =
the data sources when deploying the project.
--=20
Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =
news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> ---
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> ---
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> decrypted.
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dseagreen">
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> Andrew
>|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.

>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't[vbcol=seagreen]
>.
>

Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
---
--
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
---
--
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type: Error
Event Source: Report Server
Event Category: Management
Event ID: 129
Date: 5/10/2004
Time: 12:11:11 PM
User: N/A
Computer: xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
AndrewI am not an expert with Reporting Services by any means...but have you =tried to re-deploy the project? You will want to tell VS to overwrite =the data sources when deploying the project.
-- Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and > have moved the databases over to a production server now, > replacing the default ReportServer and ReportServerTempDB > databases. However, when I try to run the reports through > IE on the new server I get the following error:
> > Reporting Services Error
> ---
> --
> > The encrypted value for configuration setting Dsn cannot > be decrypted. (rsFailedToDecryptConfigInformation) > An internal error occurred on the report server. See the > error log for more details. (rsInternalError) > > When I get online help about this (there's a link on the > error page that comes up), it says:
> > Explanation > The rsreportserver.config file stores encrypted values > that are used by the report server to connect to the > report server database. The values are encrypted using the > private key and public key of the computer. Encrypted > values include the data source name, connection string, > and credentials. This error occurs when one or more of > these values cannot be decrypted. Conditions that cause > this error to occur include configuration file corruption, > copying a configuration file for one computer to another, > performing a backup-and-restore operation that restores a > configuration file that is not valid for the current > computer. When this error occurs, the report server can no > longer connect to the report server database.
> > User Action > Run rsconfig utility to specify the encrypted connection > values used to connect to the report server database. For > more information this utility, search Books Online.
> > ---
> --
> > So, I run RSCONFIG through term. server with the following > command:
> > rsconfig -e -s \\xxx -a windows -d reportserver -u NT > Authority\Network Service
> > And I get the following error:
> > Error: HRESULT=3D0x8004F992 For more information, see the > event log in the Event Viewer.
> > I then check the Event Viewer and find the following:
> > Event Type: Error
> Event Source: Report Server
> Event Category: Management > Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the > C:\Program Files\Microsoft SQL Server\MSSQL\Reporting > Services\ReportServer\RSReportServer.config file cannot be > decrypted.
> ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> > I assume that my syntax is wrong for rsconfig, but I can't > figure it out. Can anyone offer a suggestion?
> > Thanks,
> > Andrew
>|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.
>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
>> I had SQL Reporting Services running on a test server
and
>> have moved the databases over to a production server
now,
>> replacing the default ReportServer and
ReportServerTempDB
>> databases. However, when I try to run the reports
through
>> IE on the new server I get the following error:
>> Reporting Services Error
>> ---
--
>> --
>> The encrypted value for configuration setting Dsn
cannot
>> be decrypted. (rsFailedToDecryptConfigInformation)
>> An internal error occurred on the report server. See
the
>> error log for more details. (rsInternalError)
>> When I get online help about this (there's a link on
the
>> error page that comes up), it says:
>> Explanation
>> The rsreportserver.config file stores encrypted values
>> that are used by the report server to connect to the
>> report server database. The values are encrypted using
the
>> private key and public key of the computer. Encrypted
>> values include the data source name, connection string,
>> and credentials. This error occurs when one or more of
>> these values cannot be decrypted. Conditions that cause
>> this error to occur include configuration file
corruption,
>> copying a configuration file for one computer to
another,
>> performing a backup-and-restore operation that restores
a
>> configuration file that is not valid for the current
>> computer. When this error occurs, the report server can
no
>> longer connect to the report server database.
>> User Action
>> Run rsconfig utility to specify the encrypted
connection
>> values used to connect to the report server database.
For
>> more information this utility, search Books Online.
>> ---
--
>> --
>> So, I run RSCONFIG through term. server with the
following
>> command:
>> rsconfig -e -s \\xxx -a windows -d reportserver -u NT
>> Authority\Network Service
>> And I get the following error:
>> Error: HRESULT=0x8004F992 For more information, see the
>> event log in the Event Viewer.
>> I then check the Event Viewer and find the following:
>> Event Type: Error
>> Event Source: Report Server
>> Event Category: Management
>> Event ID: 129
>> Date: 5/10/2004
>> Time: 12:11:11 PM
>> User: N/A
>> Computer: xxx
>> Description:
>> The encrypted value for Configuration/LogonDomain in
the
>> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\ReportServer\RSReportServer.config file cannot
be
>> decrypted.
>> ====================================>> I assume that my syntax is wrong for rsconfig, but I
can't
>> figure it out. Can anyone offer a suggestion?
>> Thanks,
>> Andrew
>.
>

Reporting Services

I must install several reports on a production server and I dont have VS.NET
to deploy them.
Is there another way?
Thanks
RicardoIf you go to Report Manager on your RS server, there should be a button
to upload a report ("Upload Report"), which can be assigned to the
various report groups you have set up.
Ricardo Antunez wrote:
> I must install several reports on a production server and I dont have VS.NET
> to deploy them.
> Is there another way?
> Thanks
> Ricardo

Reporting Services

I had SQL Reporting Services running on a test server and
have moved the databases over to a production server now,
replacing the default ReportServer and ReportServerTempDB
databases. However, when I try to run the reports through
IE on the new server I get the following error:
Reporting Services Error
The encrypted value for configuration setting Dsn cannot
be decrypted. (rsFailedToDecryptConfigInformation)
An internal error occurred on the report server. See the
error log for more details. (rsInternalError)
When I get online help about this (there's a link on the
error page that comes up), it says:
Explanation
The rsreportserver.config file stores encrypted values
that are used by the report server to connect to the
report server database. The values are encrypted using the
private key and public key of the computer. Encrypted
values include the data source name, connection string,
and credentials. This error occurs when one or more of
these values cannot be decrypted. Conditions that cause
this error to occur include configuration file corruption,
copying a configuration file for one computer to another,
performing a backup-and-restore operation that restores a
configuration file that is not valid for the current
computer. When this error occurs, the report server can no
longer connect to the report server database.
User Action
Run rsconfig utility to specify the encrypted connection
values used to connect to the report server database. For
more information this utility, search Books Online.
So, I run RSCONFIG through term. server with the following
command:
rsconfig -e -s \\xxx -a windows -d reportserver -u NT
Authority\Network Service
And I get the following error:
Error: HRESULT=0x8004F992 For more information, see the
event log in the Event Viewer.
I then check the Event Viewer and find the following:
Event Type:Error
Event Source:Report Server
Event Category:Management
Event ID:129
Date:5/10/2004
Time:12:11:11 PM
User:N/A
Computer:xxx
Description:
The encrypted value for Configuration/LogonDomain in the
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config file cannot be
decrypted.
====================================
I assume that my syntax is wrong for rsconfig, but I can't
figure it out. Can anyone offer a suggestion?
Thanks,
Andrew
I am not an expert with Reporting Services by any means...but have you =
tried to re-deploy the project? You will want to tell VS to overwrite =
the data sources when deploying the project.
--=20
Keith
"Abn" <anonymous@.discussions.microsoft.com> wrote in message =
news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...
> I had SQL Reporting Services running on a test server and=20
> have moved the databases over to a production server now,=20
> replacing the default ReportServer and ReportServerTempDB=20
> databases. However, when I try to run the reports through=20
> IE on the new server I get the following error:
>=20
> Reporting Services Error
> --
> =20
> The encrypted value for configuration setting Dsn cannot=20
> be decrypted. (rsFailedToDecryptConfigInformation)=20
> An internal error occurred on the report server. See the=20
> error log for more details. (rsInternalError)=20
>=20
> When I get online help about this (there's a link on the=20
> error page that comes up), it says:
>=20
> Explanation=20
> The rsreportserver.config file stores encrypted values=20
> that are used by the report server to connect to the=20
> report server database. The values are encrypted using the=20
> private key and public key of the computer. Encrypted=20
> values include the data source name, connection string,=20
> and credentials. This error occurs when one or more of=20
> these values cannot be decrypted. Conditions that cause=20
> this error to occur include configuration file corruption,=20
> copying a configuration file for one computer to another,=20
> performing a backup-and-restore operation that restores a=20
> configuration file that is not valid for the current=20
> computer. When this error occurs, the report server can no=20
> longer connect to the report server database.
> =20
> User Action=20
> Run rsconfig utility to specify the encrypted connection=20
> values used to connect to the report server database. For=20
> more information this utility, search Books Online.
>=20
> --
> =20
> So, I run RSCONFIG through term. server with the following=20
> command:
>=20
> rsconfig -e -s \\xxx -a windows -d reportserver -u NT=20
> Authority\Network Service
>=20
> And I get the following error:
>=20
> Error: HRESULT=3D0x8004F992 For more information, see the=20
> event log in the Event Viewer.
>=20
> I then check the Event Viewer and find the following:
>=20
> Event Type: Error
> Event Source: Report Server
> Event Category: Management=20
> Event ID: 129
> Date: 5/10/2004
> Time: 12:11:11 PM
> User: N/A
> Computer: xxx
> Description:
> The encrypted value for Configuration/LogonDomain in the=20
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting=20
> Services\ReportServer\RSReportServer.config file cannot be=20
> decrypted.
> =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3 D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> I assume that my syntax is wrong for rsconfig, but I can't=20
> figure it out. Can anyone offer a suggestion?
>=20
> Thanks,
>=20
> Andrew
>
|||Thanks for the reply, Keith. I did try this, but it did
not work.
If you have any other ideas I'd love to hear them.

>--Original Message--
>I am not an expert with Reporting Services by any
means...but have you tried to re-deploy the project? You
will want to tell VS to overwrite the data sources when
deploying the project.
>--
>Keith
>
>"Abn" <anonymous@.discussions.microsoft.com> wrote in
message news:aeaa01c436b5$097e5030$a101280a@.phx.gbl...[vbcol=seagreen]
and[vbcol=seagreen]
now,[vbcol=seagreen]
ReportServerTempDB[vbcol=seagreen]
through[vbcol=seagreen]
--[vbcol=seagreen]
cannot[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
corruption,[vbcol=seagreen]
another,[vbcol=seagreen]
a[vbcol=seagreen]
no[vbcol=seagreen]
connection[vbcol=seagreen]
For[vbcol=seagreen]
--[vbcol=seagreen]
following[vbcol=seagreen]
the[vbcol=seagreen]
be[vbcol=seagreen]
can't
>.
>

Reporting Service Problem

Hi Billy,
I have received the same error when installing the production version of rep
orting services onto Windows 2000 Server.
I tryed setting DTC to manual and then re-installing but still received the
same error message.
Do you have any other ideas?Hello,
Thank you for your posting in the community!
Based on the description, the issue is related to the installation of the Re
porting Service.If
you would, please post this question in the <microsoft.beta.reporting.servic
es.general>
newsgroup.
The reporting services newsgroup is primarily for issues involving the insta
lling problem of
Reporting Service. The reason why we recommend posting appropriately is you
will get
the most qualified pool of respondents, and other partners who read the news
groups
regularly can either share their knowledge or learn from your interaction wi
th us.
Thanks and have a good day!
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Reporting service licensing question?

Hi everyone,
I have SQL server Dev edt. installed on my laptop and my company has SQL
server Ent. Edt. on our production server.
I recently downloaded the reporting services trail of 120 days from the site
of microsoft.
Anyway my question is if i install the trail reporting services on both my
laptop and maybe later the production server, will it stop functioning after
120 days?
TIA,
Martin.Yes, I would expect the trial edition to stop working after the trial
period.
If you have a licensed copy of Enterprise Edition you should contact
your supplier to get a copy of the Reporting Services CD. Once you
have that you shouldn't be time limited.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 12:35:34 -0300, "Martin" <jk123@.hotmail.com> wrote:
>Hi everyone,
>I have SQL server Dev edt. installed on my laptop and my company has SQL
>server Ent. Edt. on our production server.
>I recently downloaded the reporting services trail of 120 days from the site
>of microsoft.
>Anyway my question is if i install the trail reporting services on both my
>laptop and maybe later the production server, will it stop functioning after
>120 days?
>TIA,
>Martin.
>

Reporting Server - 2nd SQL Server

Hi,
I have a SQL server running in our production environment. I would like to
create a test/reporting environment running on a seperate server. I will
take my DB backups from the production server and then restore it onto my
2nd server. What is the best way to get the 2nd system updated? I do not
want a live replication all day long. I simply need a method to update the
2nd server once a day at a scheduled time.
Ideas?
Thank you.You can use the log shipping model. This means that you can restore the logs
from your production server on the reporting server.
Here are some details you can actually see how it could be implemented:
http://www.sql-server-performance.c...og_shipping.asp
Let me know if it helps..
"Dragon" wrote:

> Hi,
> I have a SQL server running in our production environment. I would like to
> create a test/reporting environment running on a seperate server. I will
> take my DB backups from the production server and then restore it onto my
> 2nd server. What is the best way to get the 2nd system updated? I do not
> want a live replication all day long. I simply need a method to update the
> 2nd server once a day at a scheduled time.
> Ideas?
> Thank you.
>
>|||The log shipping model will leave your second server in a read only
state, rendering it useless for testing.|||The link I posted states pros and cons of this model. It all depends of what
type of testing.
"mryan" wrote:

> The log shipping model will leave your second server in a read only
> state, rendering it useless for testing.
>|||Thank you all for your replies.
Unfortunately I will need a totally indipendent system for my testing.
Having read only will not work as we will not be able to test applications
against it. Any other ideas? What about incremental backups and restores?
"Edgardo Valdez, MCSD, MCDBA"
<EdgardoValdezMCSDMCDBA@.discussions.microsoft.com> wrote in message
news:5B49860B-A765-49CE-9719-EE982B37ED00@.microsoft.com...[vbcol=seagreen]
> The link I posted states pros and cons of this model. It all depends of
> what
> type of testing.
> "mryan" wrote:
>

Reporting Server - 2nd SQL Server

Hi,
I have a SQL server running in our production environment. I would like to
create a test/reporting environment running on a seperate server. I will
take my DB backups from the production server and then restore it onto my
2nd server. What is the best way to get the 2nd system updated? I do not
want a live replication all day long. I simply need a method to update the
2nd server once a day at a scheduled time.
Ideas?
Thank you.You can use the log shipping model. This means that you can restore the logs
from your production server on the reporting server.
Here are some details you can actually see how it could be implemented:
http://www.sql-server-performance.com/sql_server_log_shipping.asp
Let me know if it helps..
"Dragon" wrote:
> Hi,
> I have a SQL server running in our production environment. I would like to
> create a test/reporting environment running on a seperate server. I will
> take my DB backups from the production server and then restore it onto my
> 2nd server. What is the best way to get the 2nd system updated? I do not
> want a live replication all day long. I simply need a method to update the
> 2nd server once a day at a scheduled time.
> Ideas?
> Thank you.
>
>|||The log shipping model will leave your second server in a read only
state, rendering it useless for testing.|||The link I posted states pros and cons of this model. It all depends of what
type of testing.
"mryan" wrote:
> The log shipping model will leave your second server in a read only
> state, rendering it useless for testing.
>|||Thank you all for your replies.
Unfortunately I will need a totally indipendent system for my testing.
Having read only will not work as we will not be able to test applications
against it. Any other ideas? What about incremental backups and restores?
"Edgardo Valdez, MCSD, MCDBA"
<EdgardoValdezMCSDMCDBA@.discussions.microsoft.com> wrote in message
news:5B49860B-A765-49CE-9719-EE982B37ED00@.microsoft.com...
> The link I posted states pros and cons of this model. It all depends of
> what
> type of testing.
> "mryan" wrote:
>> The log shipping model will leave your second server in a read only
>> state, rendering it useless for testing.
>>

Reporting Server - 2nd SQL Server

Hi,
I have a SQL server running in our production environment. I would like to
create a test/reporting environment running on a seperate server. I will
take my DB backups from the production server and then restore it onto my
2nd server. What is the best way to get the 2nd system updated? I do not
want a live replication all day long. I simply need a method to update the
2nd server once a day at a scheduled time.
Ideas?
Thank you.
You can use the log shipping model. This means that you can restore the logs
from your production server on the reporting server.
Here are some details you can actually see how it could be implemented:
http://www.sql-server-performance.co...g_shipping.asp
Let me know if it helps..
"Dragon" wrote:

> Hi,
> I have a SQL server running in our production environment. I would like to
> create a test/reporting environment running on a seperate server. I will
> take my DB backups from the production server and then restore it onto my
> 2nd server. What is the best way to get the 2nd system updated? I do not
> want a live replication all day long. I simply need a method to update the
> 2nd server once a day at a scheduled time.
> Ideas?
> Thank you.
>
>
|||The log shipping model will leave your second server in a read only
state, rendering it useless for testing.
|||The link I posted states pros and cons of this model. It all depends of what
type of testing.
"mryan" wrote:

> The log shipping model will leave your second server in a read only
> state, rendering it useless for testing.
>
|||Thank you all for your replies.
Unfortunately I will need a totally indipendent system for my testing.
Having read only will not work as we will not be able to test applications
against it. Any other ideas? What about incremental backups and restores?
"Edgardo Valdez, MCSD, MCDBA"
<EdgardoValdezMCSDMCDBA@.discussions.microsoft.com> wrote in message
news:5B49860B-A765-49CE-9719-EE982B37ED00@.microsoft.com...[vbcol=seagreen]
> The link I posted states pros and cons of this model. It all depends of
> what
> type of testing.
> "mryan" wrote: