UNC Target Folder for File Share | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

UNC Target Folder for File Share

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
What is the status of Scheduler service on OS? 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.
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
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.

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
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.
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
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.
This is the linkhttp://www.microsoft.com/sql/community/newsgroups/default.asp for the newsgroups maintained by the MS, have a look.
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.
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
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.
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
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.
]]>