SQL security

From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 07/02/03 

Date: Wed, 2 Jul 2003 10:04:00 -0700

Your sqlmaint.exe failed.[SQLSTATE 42000] (Error 22029)is
a generic error, look in the maintenance plan history to
get more details on why it failed. You do this by right-
clicking your maintnance plan and choosing maintenance
plan history and filtering.

Ray Higdon MCSE, MCDBA, CCNA
  
>-----Original Message-----
>No. It was added about 4 months before. I restore the DB
>twice yesterday and the first time everything is OK but
>second failed( I am using same backup set)
>
>Also, I saw some errors in Event Viewer at the same time
>as my restoration.
>
>System errors: The value named IRPStackSize in the
>server's Registry key LanmanServer\Parameters was
>invalid. The value was ignored, and processing
continued.
>
>Application errors:
>1.Unable to query the IIS Info service performance data.
>The error code returned by the service is data DWORD 0.
>
>2. Unable to query the W3SVC (HTTP) service performance
>data. The error code returned by the service is data
DWORD
>0.
>
>Also, backup to local server works but backup to network
>server not working with error: sqlmaint.exe failed.
>[SQLSTATE 42000] (Error 22029). The step failed.
>
>I wonder if the server have some problem with network
>connection. Thanks
>
>
>>-----Original Message-----
>>Did you add the group permissions today in SQL? If so,
>>did the restore take them out??
>>
>>Ray Higdon MCSE, MCDBA, CCNA
>>
>>>-----Original Message-----
>>>SQL 2000, windows 2000
>>>
>>>I am using window NT authentication. In SQL Server, I
>>give
>>>permission to NT group GROUP1. My NT login USER1 is the
>>>member of GROUP1.
>>>
>>>Get error when set up ODBC : Connection failed, sQL
>>state
>>>42000, SQl server error 4064. Can not open user default
>>>database. login failed.
>>>
>>>
>>>
>>>If I give permission to USER1 directly, It works.
>>>all SQL server login works.
>>>
>>>By the way, it worked before and not work after I
>>restore
>>>last night backup data. No change with user or any NT
>>>permissions
>>>
>>>Thanks
>>>.
>>>
>>.
>>
>.
>