SSRS 2000 TEMPDB errors

Posted on 2009-05-01
Medium Priority
Last Modified: 2012-08-14
Hi there:
  I am running a report and report manger gives the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help
Cannot read the next data row for the data set dataset1. (rsErrorReadingNextDataRow) Get Online Help
Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

Can someone tell me how to fix that?


Question by:HuiShi
LVL 60

Accepted Solution

chapmandew earned 1000 total points
ID: 24281472
restarting sql server will fix it...but the underlying problem is likely that you have a few transactions open or a few really large temp tables out there.  regardless, restarting the sql server is an immediate fix.
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 24281482
Your temp db is not allowed to grow at all and that is the problem.
Right Click your tempdb in Enterprise Manager and enable Autogrowth properties to fix out this issue.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

839 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