Job fails but no info on why

I'm running a maintenance plan and the job the does the integrity checks
fails, but in the job history log it gives no useful information as to why.
I can guess that there's something wrong with a relationship, index, or
missing data for the relationship, but this is a big db and it would be nice
if its going to fail, it could at least tell me why. For example, when
running a DTS, it there's an integrity issue, it will fail and tell me why.
Is there a stored procedure I can run that would list any issues that would
make this job fail? Any other advise?
Thanks.
moondaddy@.nospam.nospamIn Enterprise Manager, right click on the Maintenance plan (not the job) and
select 'Maintenance plan history' from the context menu.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"moondaddy" <moondaddy@.nospam.nospam> wrote in message
news:OsYC7GHuFHA.1252@.TK2MSFTNGP09.phx.gbl...
I'm running a maintenance plan and the job the does the integrity checks
fails, but in the job history log it gives no useful information as to why.
I can guess that there's something wrong with a relationship, index, or
missing data for the relationship, but this is a big db and it would be nice
if its going to fail, it could at least tell me why. For example, when
running a DTS, it there's an integrity issue, it will fail and tell me why.
Is there a stored procedure I can run that would list any issues that would
make this job fail? Any other advise?
Thanks.
moondaddy@.nospam.nospam|||Look on the job steps under the advanced tab, you are able to put a log
file directory / file name in here to monitor the activity performed by
the job process.
HTH, Jens Suessmeyer.|||Thanks.
moondaddy@.nospam.nospam
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126623715.659637.295900@.z14g2000cwz.googlegroups.com...
> Look on the job steps under the advanced tab, you are able to put a log
> file directory / file name in here to monitor the activity performed by
> the job process.
>
> HTH, Jens Suessmeyer.
>|||Thanks. that gave me the clue I needed.
moondaddy@.nospam.nospam
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:u7OpsOHuFHA.1472@.TK2MSFTNGP15.phx.gbl...
> In Enterprise Manager, right click on the Maintenance plan (not the job)
> and
> select 'Maintenance plan history' from the context menu.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "moondaddy" <moondaddy@.nospam.nospam> wrote in message
> news:OsYC7GHuFHA.1252@.TK2MSFTNGP09.phx.gbl...
> I'm running a maintenance plan and the job the does the integrity checks
> fails, but in the job history log it gives no useful information as to
> why.
> I can guess that there's something wrong with a relationship, index, or
> missing data for the relationship, but this is a big db and it would be
> nice
> if its going to fail, it could at least tell me why. For example, when
> running a DTS, it there's an integrity issue, it will fail and tell me
> why.
> Is there a stored procedure I can run that would list any issues that
> would
> make this job fail? Any other advise?
> Thanks.
> --
> moondaddy@.nospam.nospam
>
>

JDBC not connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection."
Can anyone please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...498a5488bc6539
*****************************************
Check the SQL Server. Make sure it allows SQL Server authentication in
additioin to Windows. The sign on account you are using does not relate to
an LDAP/Windows account.
"jaimoon patel via SQLMonster.com" wrote:

> Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
> At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
> " A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection."
> Can anyone please help
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse...498a5488bc6539
> *****************************************
>
|||Thanks for that it done the trick.
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...l-server/18028
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...b6c0b692a3d2fd
*****************************************

JDBC not connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
for user SA, Reason: Not associated with a trusted SQL Server
connection."
Can anyone please help
*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=aac5053ac6484cf3b7498a5488bc6539
*****************************************Check the SQL Server. Make sure it allows SQL Server authentication in
additioin to Windows. The sign on account you are using does not relate to
an LDAP/Windows account.
"jaimoon patel via SQLMonster.com" wrote:
> Installing Integrity Server on MS Server 2003 but having problems when Specifing the Database, prior to this install i've already installed JDBC driver on this server version 3.
> At this stage of install of the Integrity Server its trying to connect to the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is sitting in the same Domain. An Error appears
> " A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection."
> Can anyone please help
> *****************************************
> * This message was posted via http://www.sqlmonster.com
> *
> * Report spam or abuse by clicking the following URL:
> * http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=aac5053ac6484cf3b7498a5488bc6539
> *****************************************
>|||Thanks for that it done the trick.
*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/18028
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse.aspx?aid=d2ed3d96862543fdbfb6c0b692a3d2fd
*****************************************

JDBC not connecting to SQL Server

Installing Integrity Server on MS Server 2003 but having problems when Speci
fing the Database, prior to this install i've already installed JDBC driver
on this server version 3.
At this stage of install of the Integrity Server its trying to connect to th
e SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which is
sitting in the same Domain. An Error appears
" A problem was encountered when trying to connect to the database JDBC.
[Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login fa
illed
for user SA, Reason: Not associated with a trusted SQL Server
connection."
Can anyone please help
****************************************
*
* This message was posted via http://www.droptable.com
*
* Report spam or abuse by clicking the following URL:
* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=aac5053ac6484cf3b7498a5488bc6539[/u
rl]
****************************************
*Check the SQL Server. Make sure it allows SQL Server authentication in
additioin to Windows. The sign on account you are using does not relate to
an LDAP/Windows account.
"jaimoon patel via droptable.com" wrote:

> Installing Integrity Server on MS Server 2003 but having problems when Spe
cifing the Database, prior to this install i've already installed JDBC drive
r on this server version 3.
> At this stage of install of the Integrity Server its trying to connect to
the SQL Server (SQL Enterprise Manager V8 with SP3 on MS Server 2003)which i
s sitting in the same Domain. An Error appears
> " A problem was encountered when trying to connect to the database JDBC.
> [Microsoft][SQL Server 2000 driver for JDBC][SQL Server]Login
failled
> for user SA, Reason: Not associated with a trusted SQL Server
> connection."
> Can anyone please help
> ****************************************
*
> * This message was posted via http://www.droptable.com
> *
> * Report spam or abuse by clicking the following URL:
> * [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=aac5053ac6484cf3b7498a5488bc6539[
/url]
> ****************************************
*
>|||Thanks for that it done the trick.
****************************************
*
* A copy of the whole thread can be found at:
* http://www.droptable.com/Uwe/Forum...ql-server/18028
*
* Report spam or abuse by clicking the following URL:
* [url]http://www.droptable.com/Uwe/Abuse.aspx?aid=d2ed3d96862543fdbfb6c0b692a3d2fd[/u
rl]
****************************************
*