ssrs_migration.rss script

[Poojakhanna29]

Hello All,

I am facing an issue when i am trying to copy one ssrs folder from one server to another server using ssrs_migration.rss script.

When the credentials are keyed in the command then it gives the reporting asmx could not connect error and Unauthorised exception.

When credentials are not given then some weird errors in the script are thrown.

Please if somebody can help.

Thanks

[kalpitabirhade28]

The issue you're facing seems to be related to authentication or connectivity problems while running the ssrs_migration.rss script for migrating an SSRS folder between servers. Here are some steps to troubleshoot and resolve the problem:

---

1. Verify Reporting Services URLs

• Ensure that the Report Server URL (e.g., http://<ServerName>/ReportServer) is correct and accessible from the machine where the script is running.
• Test the connectivity using a browser to verify that the endpoint responds.

---

2. Check User Credentials

• Ensure that the credentials provided have the required permissions on both the source and target Report Servers.
  • The user should have System Administrator or Content Manager roles on SSRS.
• If you're using default credentials, ensure that the Windows user running the script has sufficient permissions.

---

3. Command Syntax

Ensure you are using the correct syntax to run the script. For example:

rs.exe -i ssrs_migration.rss -s http://<SourceServer>/ReportServer -t http://<TargetServer>/ReportServer -u <Username> -p <Password>

• Replace <SourceServer> and <TargetServer> with your actual server names.
• Provide -u and -p options only if required for authentication.
• If credentials are not specified, the script uses the current Windows user's credentials.

---

4. Check SSL/TLS and Authentication Settings

• If the servers are using HTTPS, ensure SSL/TLS settings are correct and certificates are valid.
• If you're encountering the Unauthorized exception, it could be due to the authentication mode:
  • NTLM: Ensure the script is running in an environment with Kerberos delegation configured.
  • Basic Authentication: Make sure it is enabled if using non-domain credentials.

---

5. Edit the Script for Debugging

• Open the ssrs_migration.rss script and add debugging lines to log the response from the Report Server.
• Look for sections in the script where the connection or authentication might fail.

---

6. Use Fiddler or Network Monitoring

• Use a tool like Fiddler or Wireshark to capture the HTTP traffic and analyze where the connection or authentication is failing.

---

7. Ensure Proper .NET Framework Version

• SSRS scripts depend on the correct version of the .NET Framework. Ensure that the machine has the required version installed and configured.

---

8. Run Script with Elevated Privileges

• If you're running the script on a Windows system, ensure that you execute it in an elevated Command Prompt (Run as Administrator).

---

If the issue persists, could you share:

1. The exact error message or stack trace you're seeing.
2. Any relevant configurations from the ssrs_migration.rss script.

These details will help pinpoint the problem further.