?
Solved

SSRS 2008 new computer name

Posted on 2011-10-14
3
Medium Priority
?
204 Views
Last Modified: 2012-08-13
We just replaced a stand alone SQL server. After the new computer was joined to the domain and the database was restored we went to check the status on some SQL reports.

The subscription is not working because it keeps trying to execute the subscription with the old computer administrator account.

We went in and checked the RSReportServer.config file and set the URL root to localhost/ReportServer and that didn't solve the problem.

Is there another config file that would reference the old compuer name? Or did we miss a configuration some where?
0
Comment
Question by:eseinc
  • 2
3 Comments
 
LVL 25

Accepted Solution

by:
TempDBA earned 2000 total points
ID: 36970431
Check the a/c in the reporting service configuration manager that is used to make connection between the service and the database.
0
 

Author Comment

by:eseinc
ID: 36970820
There was a setting in the reporting services config that still referenced the old server. Thanks for your help
0
 

Author Closing Comment

by:eseinc
ID: 36970823
reporting services config was where it was at
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question