Maintenance - Integrity Check failure

Found log for job:
'Error: 4062, Cannot open user default database '<ID>'.
Using master db instead.'
Will check Microsoft Error list.

>--Original Message--
>I've got a database in SQL Server 7/Windows 2000 that is
>maintained through 'Database Maintenance Plans'.
>Integrity of the database is checked once a week
>using 'Integrity Check'. The weekly 'Integrity Check'
is
>failing. The error message given is 'The job has failed
>in step one, please review step 1' and nothing is put
>into the application event log. The transaction sql
>command for checking the integrity check of a database
is
>DBCC Checkdb('database'). The command line integrity
>check works fine and returns no errors.
>Failures are also occuring for 'Update Statistics used
by
>query optimizer' and 'Reorganize data and index pages'
in
>Maintenance.
>What is causing these maintenance plans to fail?
>.
>If you get this when SQL Agent logs in to run a job then
most likely the default database for the SQL Agent service
account is assigned to a database that no longer exists on
the server. You may want to check the default database for
that account. You'd probably want it set to master.
-Sue
On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
<anonymous@.discussions.microsoft.com> wrote:
>Found log for job:
>'Error: 4062, Cannot open user default database '<ID>'.
>Using master db instead.'
>Will check Microsoft Error list.
>
>is
>is
>by
>in|||You should also not automatically repair errors. You shoudl always do
root-cause analysis as these errors are usually an indication that you have
a hardware problem.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:73ma70t1m49tgqnqmk0ccuiopd3qd4n4rj@.
4ax.com...
> If you get this when SQL Agent logs in to run a job then
> most likely the default database for the SQL Agent service
> account is assigned to a database that no longer exists on
> the server. You may want to check the default database for
> that account. You'd probably want it set to master.
> -Sue
> On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
> <anonymous@.discussions.microsoft.com> wrote:
>
>

Maintenance - Integrity Check failure

Found log for job:
'Error: 4062, Cannot open user default database '<ID>'.
Using master db instead.'
Will check Microsoft Error list.

>--Original Message--
>I've got a database in SQL Server 7/Windows 2000 that is
>maintained through 'Database Maintenance Plans'.
>Integrity of the database is checked once a week
>using 'Integrity Check'. The weekly 'Integrity Check'
is
>failing. The error message given is 'The job has failed
>in step one, please review step 1' and nothing is put
>into the application event log. The transaction sql
>command for checking the integrity check of a database
is
>DBCC Checkdb('database'). The command line integrity
>check works fine and returns no errors.
>Failures are also occuring for 'Update Statistics used
by
>query optimizer' and 'Reorganize data and index pages'
in
>Maintenance.
>What is causing these maintenance plans to fail?
>.
>
If you get this when SQL Agent logs in to run a job then
most likely the default database for the SQL Agent service
account is assigned to a database that no longer exists on
the server. You may want to check the default database for
that account. You'd probably want it set to master.
-Sue
On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
<anonymous@.discussions.microsoft.com> wrote:
>Found log for job:
>'Error: 4062, Cannot open user default database '<ID>'.
>Using master db instead.'
>Will check Microsoft Error list.
>
>is
>is
>by
>in
|||You should also not automatically repair errors. You shoudl always do
root-cause analysis as these errors are usually an indication that you have
a hardware problem.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:73ma70t1m49tgqnqmk0ccuiopd3qd4n4rj@.4ax.com...
> If you get this when SQL Agent logs in to run a job then
> most likely the default database for the SQL Agent service
> account is assigned to a database that no longer exists on
> the server. You may want to check the default database for
> that account. You'd probably want it set to master.
> -Sue
> On Wed, 7 Apr 2004 14:24:33 -0700, "Jim"
> <anonymous@.discussions.microsoft.com> wrote:
>

Mail Profile: MAPI error 271: One or more receipts not found

I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,
I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:

> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,
|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:

> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,

Mail Profile: MAPI error 271: One or more receipts not found

I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operato
r
to get everything working after network guys moved my MAPI account to anothe
r
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:

> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was lookin
g
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:

> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have se
t
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due t
o
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,

Mail Profile: MAPI error 271: One or more receipts not found

I have a database server that has SQL Server 2000 with 2 instances
(default,RAC), that creates error from Mail Profile when tested. I have set
up the SQL Mail on several other servers on the network without an error.
When I test the Mail Profile under Mail Session and SQL Server Agent I
received the following error.
Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
MAPI error 271. One or more of the receipts was not found in the address
book.
Please help me resolve this error.
Thank You,I had lots of issues with MAPI too, I ended up switching to SMTP. But you
are testing the mail from the operator?
Check your MAPI profile, and SQLAgent. One one server where I am not
allowed to switch from MAPI to SMTP. I had to recreate the profile, operator
to get everything working after network guys moved my MAPI account to another
server.
--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,|||I had the same problem - turned out the MAPI profile of the SQLAgent had
cached mode set up for the outlook client, so the address book it was looking
at was not current and the address I was trying to send it to was not in
there. I recommend logging in as the SQLAgent user on the server, open up
Outlook and try sending email to the address that's giving the error.
"Joe K." wrote:
> I have a database server that has SQL Server 2000 with 2 instances
> (default,RAC), that creates error from Mail Profile when tested. I have set
> up the SQL Mail on several other servers on the network without an error.
> When I test the Mail Profile under Mail Session and SQL Server Agent I
> received the following error.
> Error 22022: SQLServerAgent: Unable to get default MAPI messge store due to
> MAPI error 271. One or more of the receipts was not found in the address
> book.
> Please help me resolve this error.
> Thank You,

mail profile

Hello,
I setup a default mail profile. However, on the same
server, in the SQL Server Agent property window, the mail
profile does not show any profile at all. If I manually
type in the default profile, it generates error message
stating that either there is no default mail client. Thank
you for your help.
JeffWhen you create the mail profile you need to be logged in as the same =account that SQL Agent is configured to use. Also start outlook using =the profile to ensure that any configuration prompts are sorted before =Agent tries to use the profile.
Mike John
"Jeff" <zli@.pattonboggs.com> wrote in message =news:4b4501c37642$a62a3950$a501280a@.phx.gbl...
> Hello, > > I setup a default mail profile. However, on the same > server, in the SQL Server Agent property window, the mail > profile does not show any profile at all. If I manually > type in the default profile, it generates error message > stating that either there is no default mail client. Thank > you for your help.
> > Jeff|||Mike,
I used the same login account as both SQLServer and
SQLServerAgent accounts, and it is also same as mailbox
account. And there is only one mail profile for my MS
outlook which is default. I did same configuration to one
of my test server and it works ok.
>--Original Message--
>When you create the mail profile you need to be logged in
as the same account that SQL Agent is configured to use.
Also start outlook using the profile to ensure that any
configuration prompts are sorted before Agent tries to use
the profile.
>Mike John
>"Jeff" <zli@.pattonboggs.com> wrote in message
news:4b4501c37642$a62a3950$a501280a@.phx.gbl...
>> Hello,
>> I setup a default mail profile. However, on the same
>> server, in the SQL Server Agent property window, the
mail
>> profile does not show any profile at all. If I manually
>> type in the default profile, it generates error message
>> stating that either there is no default mail client.
Thank
>> you for your help.
>> Jeff
>.
>|||Are SQL Server and Agent using the *same* account? I've seen this (no drop-down box) when you have
different accounts for the services.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Jeff" <zli@.pattonboggs.com> wrote in message news:4c2b01c3764d$2e6b01f0$a501280a@.phx.gbl...
> Mike,
> I used the same login account as both SQLServer and
> SQLServerAgent accounts, and it is also same as mailbox
> account. And there is only one mail profile for my MS
> outlook which is default. I did same configuration to one
> of my test server and it works ok.
> >--Original Message--
> >When you create the mail profile you need to be logged in
> as the same account that SQL Agent is configured to use.
> Also start outlook using the profile to ensure that any
> configuration prompts are sorted before Agent tries to use
> the profile.
> >
> >Mike John
> >
> >"Jeff" <zli@.pattonboggs.com> wrote in message
> news:4b4501c37642$a62a3950$a501280a@.phx.gbl...
> >> Hello,
> >>
> >> I setup a default mail profile. However, on the same
> >> server, in the SQL Server Agent property window, the
> mail
> >> profile does not show any profile at all. If I manually
> >> type in the default profile, it generates error message
> >> stating that either there is no default mail client.
> Thank
> >> you for your help.
> >>
> >> Jeff
> >
> >.
> >|||Also seen this but memory failing me on the reason - does it not also =happen if you have omitted to fire up outlook using the profile?
Mike John
"Tibor Karaszi" =<tibor.please_reply_to_public_forum.karaszi@.cornerstone.se> wrote in =message news:eYBRj2pdDHA.1532@.TK2MSFTNGP10.phx.gbl...
> Are SQL Server and Agent using the *same* account? I've seen this (no =drop-down box) when you have
> different accounts for the services.
> > -- > Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=3Ddjq&as =ugroup=3Dmicrosoft.public.sqlserver
> > > "Jeff" <zli@.pattonboggs.com> wrote in message =news:4c2b01c3764d$2e6b01f0$a501280a@.phx.gbl...
> > Mike,
> >
> > I used the same login account as both SQLServer and
> > SQLServerAgent accounts, and it is also same as mailbox
> > account. And there is only one mail profile for my MS
> > outlook which is default. I did same configuration to one
> > of my test server and it works ok.
> >
> > >--Original Message--
> > >When you create the mail profile you need to be logged in
> > as the same account that SQL Agent is configured to use.
> > Also start outlook using the profile to ensure that any
> > configuration prompts are sorted before Agent tries to use
> > the profile.
> > >
> > >Mike John
> > >
> > >"Jeff" <zli@.pattonboggs.com> wrote in message
> > news:4b4501c37642$a62a3950$a501280a@.phx.gbl...
> > >> Hello,
> > >>
> > >> I setup a default mail profile. However, on the same
> > >> server, in the SQL Server Agent property window, the
> > mail
> > >> profile does not show any profile at all. If I manually
> > >> type in the default profile, it generates error message
> > >> stating that either there is no default mail client.
> > Thank
> > >> you for your help.
> > >>
> > >> Jeff
> > >
> > >.
> > >
> >=20