SQL Server Performance

UNC Target Folder for File Share

Discussion in 'SQL Server Reporting Services' started by dmatta59, Feb 17, 2004.

  1. dmatta59 New Member

    Hello,

    Am trying to specify the target folder in UNC for file share delivery.
    The path exists and this is what was specifed: \webnamef$2004public

    The user credentials were adminstrative. Each time the Ok button would be depressed the
    scheduler would appear. When ok the schedule, it would return to initial screen
    where password would have to be reentered... Eventually would error with a generic
    nocategory error.

    Any ideas?

    dmatta59
  2. satya Moderator

  3. dmatta59 New Member

    Are you saying that it isn't operational? If not, then could a report be created as a PDF in a data share so that a link can be made to the static report?

    dmatta59
  4. satya Moderator

    Yes, the service must be started.
    Any error or information with this process?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. dmatta59 New Member




    Upon selecting new subscription, the I have chosen a delivery option of data share with the path of \localhostF$RptHome and rendor as Acrobat PDF. The creditionals are from a admin for now to eliminate the source of the error. The scheudule is accepted as default and upon submit receive the following error:

    An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help.

    The specified '@category_name' is invalid (valid values are returned by sp_help_category).

    Am looking for the errorlog and do not know what the category_name refers to. Any ideas?

    dmatta59
  6. satya Moderator

    Did you see valid values from the sp_help_category?
    I need to reproduce the error at my end to ensure I can be able to solve.
    Meanwhile may search under Reporting Server newsgroups under Microsoft.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  7. dmatta59 New Member

    I am new to SQL Reporting so where would I look for sp_help_category? I searched the online tool and nothing was under category or sp_help_category. Also, can't seem to locate the newsgroup for Reporting server under Microsoft so a link would be appreciated.

    Is the UNC path correct? To what does the sp_help_category relate to?

    dmatta59
  8. satya Moderator

    You can go with thishttp://www.microsoft.com/sql/reporting/default.asp link for reporting services information & help.

    SP_HELP_CATEGORY is a SQL command executed from MSDB database while managing the reports.

    Try specifying the server name physical name rather than mention the localhost in the report.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. satya Moderator

  10. dmatta59 New Member

    Thank you!!!

    Looked in the newsgroup and searched under sp_help_category. Another person had the same problem and a hotfix is required.

    Again, Thank You!!!

    dmatta59
  11. satya Moderator

    Glad you're able to findout the solution and appreciate for sharing the information.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  12. janborup New Member

    Hi Folks

    I got this Subscription error every time I try to use subscription
    >An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help.
    >The specified '@category_name' is invalid (valid values are returned by sp_help_category).
    AND
    >The specified '@owner_login_name' is invalid

    I have many many hours to find out what to do because I cound not find any hotfix af mentioned above.

    Here is the solution:

    At command-prompt ont he reportserver type:
    C:program FilesMicrosoft SQL Server80ToolsBinn>rsconfig -c -sYOUR_REPORTSERVER_SERVERNAME -dReportServer -aSQL -uSA -pYOUR_PASSWORD

    C:program FilesMicrosoft SQL Server80ToolsBinn>IISRESET

    This suddently works for me.

    Best regards

    Jan Borup Coyle
  13. satya Moderator

    Yes you can work it out by using rskeymgmt utility and set the public key for the Report Server, then try with rsactivate to refresh the service.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page