Maintenance Plan DB Integrity Job Failed

I created a SQL Server 2000 database maintenance plan with the wizard.
I selected integrity checks and complete backups for my database and
completed the requiremenents.
I received the following error listed below.
Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
(Error 22029). The step failed.
Please help me resolve this error.Joe
Did you check an Error log for any info there?
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:2B2D49CA-5E9F-4B76-AE3E-CE9F52E6B802@.microsoft.com...
> I created a SQL Server 2000 database maintenance plan with the wizard.
> I selected integrity checks and complete backups for my database and
> completed the requiremenents.
> I received the following error listed below.
> Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
> 42000]
> (Error 22029). The step failed.
> Please help me resolve this error.
>|||Yes, I checked the SQL Server error log.
Nothing was in the error log that correponds to this error.
Thanks,
"Uri Dimant" wrote:
> Joe
> Did you check an Error log for any info there?
> "Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
> news:2B2D49CA-5E9F-4B76-AE3E-CE9F52E6B802@.microsoft.com...
> >
> > I created a SQL Server 2000 database maintenance plan with the wizard.
> > I selected integrity checks and complete backups for my database and
> > completed the requiremenents.
> >
> > I received the following error listed below.
> >
> > Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
> > 42000]
> > (Error 22029). The step failed.
> >
> > Please help me resolve this error.
> >
>
>|||Also, which job did this fail on?
For example, if you have a tran log backup job and you have mixed full
recovery model databases with simple model, you will get an error (even
though the backups completed, the error will be thrown). Its always a good
idea to separate out the system, full model user, bulk mode user and simple
model user database backups into separate plans, and configure each
appropriately.
Awaiting your response for more info as per Uri.
--
AndyP,
Sr. Database Administrator,
MCDBA 2003 &
Sybase Certified Pro DBA (AA115, SD115, AA12, AP12)
"Joe K." wrote:
> I created a SQL Server 2000 database maintenance plan with the wizard.
> I selected integrity checks and complete backups for my database and
> completed the requiremenents.
> I received the following error listed below.
> Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error 22029). The step failed.
> Please help me resolve this error.
>|||Specify a report file for the main plan and check that report file for error messages.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:2B2D49CA-5E9F-4B76-AE3E-CE9F52E6B802@.microsoft.com...
> I created a SQL Server 2000 database maintenance plan with the wizard.
> I selected integrity checks and complete backups for my database and
> completed the requiremenents.
> I received the following error listed below.
> Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000]
> (Error 22029). The step failed.
> Please help me resolve this error.
>

Maintaining Security

I am a beginer in SQL Server. I have developed a simple accounting application in VB and SQL. Now I have successfully completed my application. Now I want to deploy it to my client. So I installed SQl Server and required VB components in the clients computer. I also created 'sa' login and secret password only know by me. I thought my data in that clients computer was full safe but later on i found that we can also connect to the sql server using the NT administrative account and easily change the data of the database. So now I am worried that if someone enters and access the clients computer with administrator's password then he/she can change my data resulting the corruption of the data. So is there any way that I can prevent the access the database to the client with the NT administrative account or any way 2 track the way the data changed?

I am probably missing something from your application description; please correct me if any of my assumptions is wrong. I will list a few assumptions based on my understanding and try to answer your question and you some recommendations based on them:

* There is one SQL Server 2005 machine that can be remotely access by multiple clients running your application.

* You have a hardcoded SA password embedded in your application

I want to start by pointing out that by default members of the Windows Administrators group on the machine running SQL Server will have access to via this membership. You can remove such privilege to prevent an accidental access by removing the BUILTIN\Administrators login from SQL Server: DROP LOGIN [BUILTIN\Administrators]

It is important to remark that this will prevent the Windows administrators from connecting to SQL Server 2005 when the server is running normally, but any local administrator will be able to connect to SQL Server 2005 by starting the server in single-user-mode, this is allowed for system maintenance and to prevent accidental lockouts from the system. It is also important to note that it is pretty much impossible to stop an adversary that already has full access to the SQL Server 2005 machine as system administrator.

The next thing to note, and that hopefully is something I misunderstood is the hardcoded SA password in your application. I strongly recommend against such practice as an adversary can easily recover the plaintext password from your client and compromise the data. Even more, the account you are using in this case is SA; I strongly recommend using the “least privilege principle” and define roles for your application, based on the most common tasks. Probably you have administrative tasks (create users, tables, etc.), read-write tasks (update, inserts, etc.) and read-only tasks (search and read data, but not write). I would recommend creating different principals for such tasks and grant only the required privileges for each principal type, restricting access to the most privileged accounts (such as SA) only to users that require such high privileges.

Additionally I want to remind you of a new feature in SQL Server 2005 that may affect your design in case you use hardcoded passwords: password policy. SQL Server 2005 running on Windows 2003 can take advantage of the Windows password policies and use them in SQL logins (including SA); these password policies allows a domain/machine administrator to define password complexity, life-time, lockout policies, etc. in a centralized way. When running on Windows 2003, SQL Server will use this new feature by default, but you can explicitly turn it off for any given SQL account. It is highly recommended to take advantage of this feature especially for SA, but if you have hardcoded passwords (or passwords that are difficult to update in your app) you will probably have to disable the password policy for the accounts you use in your app.

Detect unexpected value changes is a little tricky. One possibility here may be to use a certificate to sign the data and store the signature along with the data; this way your application can verify that the signature is valid before consuming the data.

I hope this information will be useful, let us know if you have further questions or/and feedback.

-Raul Garcia

SDE/T

SQL Server Engine

|||Thanks. As I am only concern abt the protection of my data I wanna suggestion on "how do I safe gaurd my data" so only the login used by me or my program can change/add/remove the data from my database not other users from any other program. And I also wanna know that whether can I track the activities of third user who changes the data in my database.|||

You might want to take a look at a thread that is related to your question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=371562&SiteID=1.

You can only achieve what you are asking if you have full control over the machine where your program is installed. Otherwise, you could write your program, so you could detect if someone changed the data, but you would not be able to prevent such changes. In other words, there is no way to prevent corruption of your data by a third party.

Thanks
Laurentiu

Mailing Labels from a subreport?

I have a main report which is essentially a letter. When the letter is
completed, I have a SubReport which are mailing labels. In the sub report I
have 2 columns and in the main report I have 1 column. When I run the main
report, I only get 1 column of Labels. When I run the subreport I get the 2
columns that I'm looking for.
Any suggestions on how I can get the main report to show 2 columns of Labels?
Regarding the dimension of the Main Report:
Report
Margin .5 Left, .5 Right, .5 Top, .5 Bottom
Page Size 7.5in Width, 11in Height
Body
Columns 1
Size 7.5in, 21.7448in
On the Sub Report :
Columns 2
Column Spacing .25
Size 3.5in, 0.73958in
Is this possible?
Thanks!I've done some research and such a thing is not possible. The columns is
driven from the top level report.
I am thinking of a work-around:
I'll essentially have 2 datasets one on the left and one on the right. They
will both call the same stored procedure to get the label. However, the left
side will call with a parameter of "Even" and the right with "Odd". The only
rows that will be returned on the left will be the ones that are moded by
Even Numbers. The only rows that will be returned on the right will be the
ones moded by Odd Numbers. To get this Even/Odd in the stored procedure, I
will have an identity column.
"CraigZello" wrote:
> I have a main report which is essentially a letter. When the letter is
> completed, I have a SubReport which are mailing labels. In the sub report I
> have 2 columns and in the main report I have 1 column. When I run the main
> report, I only get 1 column of Labels. When I run the subreport I get the 2
> columns that I'm looking for.
> Any suggestions on how I can get the main report to show 2 columns of Labels?
> Regarding the dimension of the Main Report:
> Report
> Margin .5 Left, .5 Right, .5 Top, .5 Bottom
> Page Size 7.5in Width, 11in Height
> Body
> Columns 1
> Size 7.5in, 21.7448in
>
> On the Sub Report :
> Columns 2
> Column Spacing .25
> Size 3.5in, 0.73958in
> Is this possible?
> Thanks!
>
>