.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

SQL Server 2005 Maintenance Plans - Reporting And Logging Does Not Work

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :Sql Server
 

I have a maintenance plan built on a SQL Server 2005 instance that rebuilds indexes, rebuilds statistics, checks for database integrity, performs a maintenance cleanup, and performs a history cleanup.  This job runs once per week.

In the "Reporting and Logging" section I have the following options:

- Generate a text file report is checked

- Create a new file is selected

- A valid destination folder is identified

- Send report to an email recipient is checked

- A valid agent operator is selected

- Log extended information is checked

The job seems to complete successfully and a report is created and emailed, but the only information in the report is as follows:

Quest SLSSQLMaint Utility.
Logging on to SQL Server 'DEVSQL01' with Windows Authentication
Logged on to SQL Server 'DEVSQL01'

[1] Delete old text report files...
[1] Execution Time: 0 hrs, 0 mins, 0 secs.


[2] Send DBMail or SendMail report file....

[2] Execution Time: 0 hrs, 0 mins, 1 secs.

End of maintenance plan 'DB Maintenance Plan (No Backups) [DB Maintenance]' on 9/29/2010 8:40:49 PM (Success)
C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\Binn\slssqlmaint.exe Process Exit Code: 0 (Success)

Where is the information about the rest of the maintenance plan?&nbs


View Complete Post


More Related Resource Links

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Data Points: Report Controls in SQL Server 2005 Reporting Services

  

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006


Data Points: Designing Reports with SQL Server Reporting Services 2005

  

Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both Windows® Forms and Web-based applications.

John Papa

MSDN Magazine June 2006


Problem when installing Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint

  
Hi,

I have configured the SharePoint Production Server(Standalone) with WS 2008 64 bit version, SQL Server 2005 with SP3 , Visual Studio 2008 and MOSS 2007(SP3). I have configured SSRS 2005 in SharePoint integration mode. Everything works fine till the last step. Now, i am trying to install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies feature and failed. I am getting below error message.

Product: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies -- You must first install SharePoint Server before installing SQL Server 2005 Reporting Services Add-in for SharePoint Technologies



Any help will be very appreciated!

Thanks,
-Raj

SQL Server 2005: Install reporting services - which version?

  
Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

  
Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website.  SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

SharePoint integration with SQL Server 2005 Reporting Services

  
Hello Everyone,   I have been banging my head against the wall with trying to integrate SharePoint 2007 and SQL Reporting Services.  If anyone could offer any assistance, I would appreciate it greatly. I have been following these 2 websites down to the letter in trying to configure everything:     1. http://msdn2.microsoft.com/en-us/library/bb326356.aspx     <---Microsoft's Steps   2. http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with- wss-3-0-and-moss-2007.aspx   <---SharePoint Blog Group     Basically my setup is as follows:   Server 1 = SharePoint 2007 Server 2 = SQL Server Reporting Services SP2 / SharePoint 2007 services Server 3 = Database   Server1 is setup and running SharePoint 2007 fine with no problems. It was installed under the complete option with its own server farm. Then with the Server2, SharePoint 2007 is installed again, also under the complete complete option, and configured to join Server1's server farm. In this way, Server2 is able to supply Server1 with services and it has been said that if you are using 2 different servers, one for SharePoint and one for Reporting Services, you need to have an instance of SharePoint on the reporting services box. With a SharePoint "front-end" the reporting-services now has a way to also join Server1s farm.   This is where the headache be

Error with Maintenance Plans - SQL 2005

  
Hi everyone.I have a problem with SQL 2005 with Cluster.  There is no issues with installation process and the cluster works fine. Normally I install SQL and apply Service Pack. So I do this, installing Service Pack 3 in both nodes (two nodes)After this, I create some databaese and restore backup from other SQL 2005 Server and also I import the logins to access SQLBut when I try access Maintenance Palns appears the following messageFailed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)Additional Information:    an exception occurred while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) Invalid column name 'from_msx'Invalid column name 'has_targets') Microsoft Sql Server, Error:207)What I do. Remove client components, Integration and Notification Services in both nodes, reinstall and apply Service Pack. Now I can create a new plan. but in the saving step appears the following messageSaving maitenance plan failed.Additional information:Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)An exception occurred while executing a Transact-SQL statement or batch (Microsoft.SqlServer.ConnectionInfo) Invalid colum name 'ms_job_id' (Microsoft Sql Server, Error:207)I found some information in Internet, about a script that fixes this, but in Service Pack 2. I thinking in remove SQL , reinstall and test without SP. And

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

Run Reporting services 2005 with databases housed on SQL Server 2008?

  
Hi, I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to  a different forum or not so sorry for the double post. I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running something like this: Server A: SQL 2005 Reporting Services Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine first?

re: Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

  
To have access to the webpart "report viewer for sql server reporting services" you can of course install Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies. My question though is, does your SharePoint 2007 server have to be running in integrated mode so as to be able to install and use the report viewer web part? Thanks.

how can i export/import maintenance plans from 2005 to 2008?

  
I have this link http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html However, it is not the solution for me. When I expand SERVERNAME (Integration Services), all I can see it is Running packages and Stored packages, and I cannot expand any deeper. And the scripting way which described in the link above, seems is not finished. It just tells you about the select...JulieShop

SQL Server 2005 (X64) Maintenance Clean Up Task Using Hours Option for File Age

  
I'm running into an issue with SQL Server 2005 64-bit and the maintenance clean up tasks.  I have it set up to delete any transaction logs or backups older than 12 hours.  It seems that there could be some sort of bug because, according to the log files, SQL is running the clean up for 12 days instead.  I've created a work around for this by using execute transact-sql tasks instead, but was wondering if there's a problem with my version of SQL Server, like an SP or patch that I've overlooked. Here's my version information: Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

SQL Reporting Services 2005 don't work

  

Hi all,

I've go the next problem.

There is an application which uses SQL 2005 Express Edition + SQL Reporting Services. Both these products are installed together in the same combination for more than hundred times and worked perfectly. Though there is one installation where SSRS was installed but don't work.

Symptoms:

1) There are no error messages in the SQL Setup. Both SQL Database Services and SQL Reporting Services realy were installed;

2) IIS contains required virtual directories. ASP.NET is installed and configured properly;

3) SQL Database Services is working fine; required databases exist. Network Service (account which is used for running SSRS service) is a member of required roles in these databases;

4) After installation SSRS service is down. After starting it stops again in a few moments;

5) Windows Application Event Log contains no error messages from SSRS

6) Reporting Services Configuration Manager claims that SSRS were not initialized;

7) In SSRS log there are error message saying

Microsoft.ReportingServices.Diagnostics.Utilities.EventLogSourceNotFound: The event source "

Can't install Service Pack 3 for SQL Server 2005 Reporting Services

  

I just installed a stand-alone SQL Server 2005 reporting services on a 64-bit Server 2008 machine without receiving any errors.  I have not configured reporting services yet, but I'd like to patch it with Service pack 3. However, when I execute Service Pack 3, it won't let me check the box for reporting services.  I've rebooted, etc.  The database is not installed on this server, just reporting services.

I have performed many searches, but I have not seen anyone with a similar problem.  What can I do so that it allows me to check the box during service pack installation?

--Max


Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend