Re: Site Maintenence tasks

• Previous message: Robbie: "SMS 2003"
• Maybe in reply to: Jaye: "Re: Site Maintenence tasks"
• Next in thread: Evan [MSFT]: "Re: Site Maintenence tasks"
• Messages sorted by: [ date ] [ thread ]

Date: Thu, 3 Jun 2004 09:52:57 -0700

Wow, nothing but faulures to connect to sql server. If SMS_SQL_MONITOR is
not able to connect, then are your inboxes all backed up with files? Check
inboxes\despoolr.box\receive, inboxes\dataldr.box, inboxes\sinv.box,
inboxes\statmgr.box\statmsgs, for example. SMS polls inboxes every hour as a
backup in case the notification system of sql monintor isn't working, but
there would still be files backed up to some extent even so. Let me know
what you find.
You're in advanced security?

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jaye" <jaye.roberts@specializedloanservicing.com> wrote in message
news:OFYIuONSEHA.2000@TK2MSFTNGP11.phx.gbl...
> Here is my smsdbmon.log.
>
> "Evan [MSFT]" <esc@online.microsoft.com> wrote in message
> news:u34b9vLSEHA.3432@TK2MSFTNGP11.phx.gbl...
> > Please attach the log to your reply and we'll take a look at it.
> > -- 
> > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > "Jaye" <jaye.roberts@specializedloanservicing.com> wrote in message
> > news:%23VO%23gKASEHA.808@tk2msftngp13.phx.gbl...
> >> I found the log, it was on an unexpected drive.  Anyway, most of it
looks
> > ok
> >> to me but scattered here and there are failed logins...
> >>
> >> *** [28000][18456][Microsoft][ODBC SQL Server Driver][SQL Server]Login
> >> failed for user 'NT AUTHORITY\SYSTEM'.
> >>
> >> Since I have my SQL server and Site server on separate boxes, which NT
> >> AUTHORITY\SYSTEM is that refering to when it is attempting a login?  My
> > Site
> >> server computer account is already an administrator on the SQL server
and
> > an
> >> SA in SQL.
> >>
> >> ~Jaye
> >>
> >> "Evan [MSFT]" <esc@online.microsoft.com> wrote in message
> >> news:ubrOZb$REHA.2876@TK2MSFTNGP09.phx.gbl...
> >> > Enable logging for that component as follows. In admin ui, under
Tools
> >> > \
> >> > SMS
> >> > Service Manager,. right click and choose All Tasks \ "start sms
service
> >> > manager". Under Servers node, choose your remote sql server and
> > highlight
> >> > SMS_SQL_MONITOR_XXX. Right click the item in the right pane and
choose
> >> > "Logging". Check "logging enabled" and click ok. Then restart sql
> > monitor
> >> > service so it reads and uses the logging setting. Then see if any
> >> > errors
> >> > are
> >> > listed in smsdbmon.log, and do you see the statements referred to in
> >> > Eric's
> >> > previous mail.
> >> >
> >> > -- 
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> > "Tony Linville" <anonymous@discussions.microsoft.com> wrote in
message
> >> > news:CFCC1281-7E15-4952-84A8-FDFDAE0D9A0F@microsoft.com...
> >> >> I am having the exact thing happening on my server.  I have no task
> >> >> listed
> >> > and I do not have the smsdbmon.log file either.  I have my SQL on a
> >> > different server also.  I looked on the SQL server and my SMS server
> >> > for
> >> > the
> >> > log file.  I also stop and restarted the service on the sql server
but
> >> > nothing happened.  So any help would be great!
> >> >> Thanks Tony Linville
> >> >
> >> >
> >>
> >>
> >
> >
>
>
>

• Previous message: Robbie: "SMS 2003"
• Maybe in reply to: Jaye: "Re: Site Maintenence tasks"
• Next in thread: Evan [MSFT]: "Re: Site Maintenence tasks"
• Messages sorted by: [ date ] [ thread ]