Examining event logs hangs Enterprise Manager

Anyone know a reason why trying to read the event logs hangs Enterprise Manager?
Do I have to read them threw Enterprise Manager?
Thanks,
Bryan HughesCheck to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.|||Originally posted by Pigeon
Check to see how large your logs are. If they are too big, it may just be taking a while for them to open up. You can also open them up in notepad.

Now for the $60,000 question, where do I find the SQL Server event logs...|||Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

blindman|||Originally posted by blindman
Probably the best thing to do is to start a new event log. This should allow your old log to open more quickly, or you can open and edit it through another application.

Normally a new event log is started only when you stop and restart SQL Server, but there is an SQL command that will do it as well. I make the command part of my weekly maintenance so that the log never grows to big.

No, I can't remember the command right now, but if you can't find it and nobody else posts it I'll look it up at my office tomorrow.

blindman

The command is : sp_cycle_errorlog

Default path where you would find the logs is the Logs directory in your MS SQL installation folder|||Were you talking about the event logs or the sql server logs ? If your sql server log is really big then will experience the "hang". If you don't know the location, just do a quick search on ERRORLOG.|||Thanks Enigma. Did you consult the Holy Book? ;)

blindman :cool:|||Nope .. but did see the code for sp_cycle_errorlog.
And found out an undocumented dbcc command (not there in the Holy Book)

dbcc errorlog|||Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman|||Both cycle the log.|||Originally posted by blindman
Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman
Well .. the code for the stored proc sp_cycle_errorlog is :

create procedure sp_cycle_errorlog -- 1997/06/24
as
if (not (is_srvrolemember('sysadmin') = 1)) -- Make sure that it is the SA executing this.
begin
raiserror(15247,-1,-1)
return(1)
end

dbcc errorlog
return (0)

So ultimately its dbcc errorlog that is recycling the logs|||Thanks for the help! You guys rock...|||Originally posted by blindman
Well, what does it do?

...and dude, I gotta tell ya... your Icon is FREAKIN ME OUT!

blindman

How can you see it if you're a blindman?

I thought you were answer questions from a brail monitor or something...

and DUDE...where's the dark planet?|||My seeing eye dog translates text from the screen into a series of binary woofs indicating the ASCII codes of the characters. And ever since Enigma changed his Icon, Fido keeps trying to bury my monitor in the back yard.

Bad DOG!

blindman|||The Dark Planet is a dark corner of the Milky Way Galaxy.

LOL :GRIN:

BTW if you want to know where I am from ... I am from Mumbai , India|||To paraphrase Churchill, do you contain a riddle wrapped in a mystery?|||Only thing I would say .. I am a puzzle in myself...

Ever growing Transaction logs

We are experiencing an ongoing transaction log problem
that is driving us crazy. I would appreciate any help you
can provide.
We are currently running an application from a company
called Aelita that collects event log data from our
servers and stores them in an SQL 200 database on a
Windows 2000 server. Our database is currently 160 GB in
size with approximately 140 million records. The system
only has five users who during the day only generate
reports on security and incidents from the event logs in
the database. They can not manipulat the data. They have
been told to stay out of the database until further
notice.
Here's the problem: the transaction logs grow
continuously until they get over 300GB in size and fill up
the partition they are on. There are no users on the
system, no data being collected and no reports being
generated. In theory, there should be no transactions
being porocessed except for any built in SQL processes
that are running. I've run performance monitor against
that database and can see that we are averaging between
300 and 400 transactions per second on the database during
the day. These transactions are filling up the transaction
logs everyday. I can't figure out what is running and
generating the transaction logs.
I've run the profiler in EM, but can't seem to get good
data out of it. I see a number of begin/commit
transactions associated with an OBjectName "Ghost", but I
have no idea what that is or if that is even the problem.
I can't tell which process is running out of control and
causing the problem. The problem continues after shutting
down SQL or rebooting the server. I need to figure out
what is running and stop it.
Because of on going problems, we have shut down the Aelita
application from collecting data. Normally the data is
collected during the night. We haven't collected data for
a couple of weeks while we attempt to solve our problem.
config:
Windows 2000 SP4
SQL 2000 SP 3
IBM server - four processors
4 GB RAM
three 400GB data partitions located on an IBM Shark SANDave,
Take a look to see if you have any scheduled jobs running that may be
causing the transactions such as a reindexing job etc. You should be able
to tell thru sp_who2 what spid is running and then use DBCC INPUTBUFFER to
see what it is doing. Profiler should be able to tell as well but I suspect
you don't have the right event classes selected. Chec sp:completed, batch
completed and rpc completed to get a start. If your not doing regular log
backups you may want to think about setting it to Simple recovery mode as
well.
--
Andrew J. Kelly
SQL Server MVP
"dave" <anonymous@.discussions.microsoft.com> wrote in message
news:017701c3c97b$ee765a40$a101280a@.phx.gbl...
> We are experiencing an ongoing transaction log problem
> that is driving us crazy. I would appreciate any help you
> can provide.
> We are currently running an application from a company
> called Aelita that collects event log data from our
> servers and stores them in an SQL 200 database on a
> Windows 2000 server. Our database is currently 160 GB in
> size with approximately 140 million records. The system
> only has five users who during the day only generate
> reports on security and incidents from the event logs in
> the database. They can not manipulat the data. They have
> been told to stay out of the database until further
> notice.
> Here's the problem: the transaction logs grow
> continuously until they get over 300GB in size and fill up
> the partition they are on. There are no users on the
> system, no data being collected and no reports being
> generated. In theory, there should be no transactions
> being porocessed except for any built in SQL processes
> that are running. I've run performance monitor against
> that database and can see that we are averaging between
> 300 and 400 transactions per second on the database during
> the day. These transactions are filling up the transaction
> logs everyday. I can't figure out what is running and
> generating the transaction logs.
> I've run the profiler in EM, but can't seem to get good
> data out of it. I see a number of begin/commit
> transactions associated with an OBjectName "Ghost", but I
> have no idea what that is or if that is even the problem.
> I can't tell which process is running out of control and
> causing the problem. The problem continues after shutting
> down SQL or rebooting the server. I need to figure out
> what is running and stop it.
> Because of on going problems, we have shut down the Aelita
> application from collecting data. Normally the data is
> collected during the night. We haven't collected data for
> a couple of weeks while we attempt to solve our problem.
> config:
> Windows 2000 SP4
> SQL 2000 SP 3
> IBM server - four processors
> 4 GB RAM
> three 400GB data partitions located on an IBM Shark SAN
>

Event Log SQL 2000 on windows 2003

My Event log is getting filled with SQL event logs of login - how do I turn
this off?
EM, right-click your server, properties, security setting.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lindsay Keith" <keith@.highintegritysolutions.com> wrote in message
news:10nsqcjj2g5ph39@.corp.supernews.com...
> My Event log is getting filled with SQL event logs of login - how do I turn this off?
>
>
|||Lindsay,
Right click on the server in enterprise manager, click on the security
tab, then change the audit level to whatever you desire. I recommend you
leave it at Failure for a production system as a minimum, but I
personally prefer to log all activity.
You can change the event log size in Event Viewer, and you can tell it
to write over old log records so it doesn't fill up. I usually expand
mine to at least 10MB.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Lindsay Keith wrote:
> My Event log is getting filled with SQL event logs of login - how do I turn
> this off?
>
>

Event Log SQL 2000 on windows 2003

My Event log is getting filled with SQL event logs of login - how do I turn
this off?EM, right-click your server, properties, security setting.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lindsay Keith" <keith@.highintegritysolutions.com> wrote in message
news:10nsqcjj2g5ph39@.corp.supernews.com...
> My Event log is getting filled with SQL event logs of login - how do I tur
n this off?
>
>|||Lindsay,
Right click on the server in enterprise manager, click on the security
tab, then change the audit level to whatever you desire. I recommend you
leave it at Failure for a production system as a minimum, but I
personally prefer to log all activity.
You can change the event log size in Event Viewer, and you can tell it
to write over old log records so it doesn't fill up. I usually expand
mine to at least 10MB.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Lindsay Keith wrote:
> My Event log is getting filled with SQL event logs of login - how do I tur
n
> this off?
>
>

Event Log SQL 2000 on windows 2003

My Event log is getting filled with SQL event logs of login - how do I turn
this off?EM, right-click your server, properties, security setting.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Lindsay Keith" <keith@.highintegritysolutions.com> wrote in message
news:10nsqcjj2g5ph39@.corp.supernews.com...
> My Event log is getting filled with SQL event logs of login - how do I turn this off?
>
>|||Lindsay,
Right click on the server in enterprise manager, click on the security
tab, then change the audit level to whatever you desire. I recommend you
leave it at Failure for a production system as a minimum, but I
personally prefer to log all activity.
You can change the event log size in Event Viewer, and you can tell it
to write over old log records so it doesn't fill up. I usually expand
mine to at least 10MB.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Lindsay Keith wrote:
> My Event log is getting filled with SQL event logs of login - how do I turn
> this off?
>
>

Event Log and SQL Server Agent

Hi Helper,
When I boot me server up, I always get an alert that says at least one
service or driver failed. I checked all of the logs in the event viewer.
The error is in the Application log. When I look at the properties of the
error I get a dialog box that has the description "Unable to read the
eventlog (Reason: The event log has changed between read operations). The
Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID is
318.
How do I resolve this problem? What can I do to prevent getting this Alert
message and get this fixed?
Thanks,
KeithThat's nothing to worry about.
That message isn't the service failing to start, have a look in Event Viewer
(System). This is more likely to contain the service that's failing.
HTH
Ryan Waight, MCDBA, MCSE
"Keith Norris" <klnorris@.comcast.net> wrote in message
news:naqdna69F685MjaiRVn-gg@.comcast.com...
> Hi Helper,
> When I boot me server up, I always get an alert that says at least one
> service or driver failed. I checked all of the logs in the event viewer.
> The error is in the Application log. When I look at the properties of the
> error I get a dialog box that has the description "Unable to read the
> eventlog (Reason: The event log has changed between read operations). The
> Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID
is
> 318.
> How do I resolve this problem? What can I do to prevent getting this
Alert
> message and get this fixed?
> Thanks,
> Keith
>|||There are no errors in the event viewer (System). There are only warnings
or information. There are no errors in the other event viewers either such
as Directory Service, DNS Server, File Replication Service, Service, or
Security. There are only messages of type Information and Warning. The
original message I describe below is of type Error with an X in a red
circle. Isn't it only the error messages rather than the information and
warning messages that cause the alerts? I do not want the Alert Message
saying at least on service or driver failed on boot up. I hope this
provides you with additional information to help me solve the problem. I'm
new to networking and database administration.
Thanks,
Keith
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:OH$E06TpDHA.3844@.tk2msftngp13.phx.gbl...
> That's nothing to worry about.
> That message isn't the service failing to start, have a look in Event
Viewer
> (System). This is more likely to contain the service that's failing.
>
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "Keith Norris" <klnorris@.comcast.net> wrote in message
> news:naqdna69F685MjaiRVn-gg@.comcast.com...
> > Hi Helper,
> >
> > When I boot me server up, I always get an alert that says at least one
> > service or driver failed. I checked all of the logs in the event
viewer.
> > The error is in the Application log. When I look at the properties of
the
> > error I get a dialog box that has the description "Unable to read the
> > eventlog (Reason: The event log has changed between read operations).
The
> > Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event ID
> is
> > 318.
> >
> > How do I resolve this problem? What can I do to prevent getting this
> Alert
> > message and get this fixed?
> >
> > Thanks,
> > Keith
> >
> >
>|||We can ensure it's not SQL Server causing the 'Service Failed to Start
message' in the following manner.
In Control Services :-
Set the startup of SQLServerAgent and MSSQLServer to Manual
Stop both services
Clear all 3 Event Logs.
Reboot the Server.
The SQL Services are now not trying to start, if the Service didn't start
message appears it definalty hasn't come from SQL.
Alternitavly, Control Panel / Servcies.
Look at every service, ensure those with a Startup Type of AutoMatic are
all Status = Started.
If you have any Automatic starters that are not Started -- bingo...
HTH
Ryan Waight, MCDBA, MCSE
"Keith Norris" <klnorris@.comcast.net> wrote in message
news:gPKdnVEvmuxEIjaiRVn-jw@.comcast.com...
> There are no errors in the event viewer (System). There are only warnings
> or information. There are no errors in the other event viewers either
such
> as Directory Service, DNS Server, File Replication Service, Service, or
> Security. There are only messages of type Information and Warning. The
> original message I describe below is of type Error with an X in a red
> circle. Isn't it only the error messages rather than the information and
> warning messages that cause the alerts? I do not want the Alert Message
> saying at least on service or driver failed on boot up. I hope this
> provides you with additional information to help me solve the problem.
I'm
> new to networking and database administration.
> Thanks,
> Keith
> "Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
> news:OH$E06TpDHA.3844@.tk2msftngp13.phx.gbl...
> > That's nothing to worry about.
> >
> > That message isn't the service failing to start, have a look in Event
> Viewer
> > (System). This is more likely to contain the service that's failing.
> >
> >
> > --
> > HTH
> > Ryan Waight, MCDBA, MCSE
> >
> > "Keith Norris" <klnorris@.comcast.net> wrote in message
> > news:naqdna69F685MjaiRVn-gg@.comcast.com...
> > > Hi Helper,
> > >
> > > When I boot me server up, I always get an alert that says at least one
> > > service or driver failed. I checked all of the logs in the event
> viewer.
> > > The error is in the Application log. When I look at the properties of
> the
> > > error I get a dialog box that has the description "Unable to read the
> > > eventlog (Reason: The event log has changed between read operations).
> The
> > > Source is SQLSERVERAGENT, the Category is Alert Engine, and the Event
ID
> > is
> > > 318.
> > >
> > > How do I resolve this problem? What can I do to prevent getting this
> > Alert
> > > message and get this fixed?
> > >
> > > Thanks,
> > > Keith
> > >
> > >
> >
> >
>

event ID for windows (trusted) authentication and failed ones as well?

Hello there
I am wondering what I should look for, in the events logs (I have the
security audit enabled to log to event logs) for successful and not
successful connections using windows authentication ?
does anybody know ?If successful or not and if using Windows or SQL logins,
they all log to the application event log under the same
event id of 17055
-Sue
On Mon, 24 Apr 2006 12:44:27 -0600, "Simo Sentissi"
<msentissi@.rightnow.com> wrote:

>Hello there
>I am wondering what I should look for, in the events logs (I have the
>security audit enabled to log to event logs) for successful and not
>successful connections using windows authentication ?
>does anybody know ?
>

Event ID 851 in SQL2005 - what to do?

Hi,
when trying to shrink a transaction log file in SQL2005 we receive every few
minutes (for 4 hours now) the following Information in the event logs and th
e
shrink does not complete.
--
Type: Information
ID: 851
Source: MSSQLSERVER
Text (English translation follows): Das Betriebssystem hat den Fehler
1450(Nicht genügend Systemressourcen, um den angeforderten Dienst
auszuführen.) an SQL Server zurückgegeben. Dieser Fehler ist bei einem
Schreiben am Offset 0x000007c3ca3e00 in der Datei mit dem Handle 0x000008E4
aufgetreten. üblicherweise ist dies ein tempor?rer Zustand, und der Server
mit SQL Server versucht immer wieder, diesen Vorgang zu wiederholen. Wenn de
r
Zustand weiterhin besteht, muss sofort etwas unternommen werden, um das
Problem zu beheben.
--
In English (free translation): The operating System returned Error 1450 (not
enough system resources for executing the service) to the SQL server during
write at offset ... in file with handle ...This is mostly temporary and SQL
server tries again to repeat the operation. If this error continues to happe
n
you have to take actions immediately to resolve the problem.
--
The executed query is:
BACKUP LOG accountings TO
DISK='e:\mssql\BACKUP\accountings\transa
kt_200705210928.bak'
DBCC SHRINKFILE ('accountings_Protokoll',5120) WITH NO_INFOMSGS
go
Any ideas what action to take?
Regards
--StefanHi Stefan
"Stefan Funk" wrote:

> Hi,
> when trying to shrink a transaction log file in SQL2005 we receive every f
ew
> minutes (for 4 hours now) the following Information in the event logs and
the
> shrink does not complete.
> --
> Type: Information
> ID: 851
> Source: MSSQLSERVER
> Text (English translation follows): Das Betriebssystem hat den Fehler
> 1450(Nicht genügend Systemressourcen, um den angeforderten Dienst
> auszuführen.) an SQL Server zurückgegeben. Dieser Fehler ist bei einem
> Schreiben am Offset 0x000007c3ca3e00 in der Datei mit dem Handle 0x000008E
4
> aufgetreten. üblicherweise ist dies ein tempor?rer Zustand, und der Serv
er
> mit SQL Server versucht immer wieder, diesen Vorgang zu wiederholen. Wenn
der
> Zustand weiterhin besteht, muss sofort etwas unternommen werden, um das
> Problem zu beheben.
> --
> In English (free translation): The operating System returned Error 1450 (n
ot
> enough system resources for executing the service) to the SQL server durin
g
> write at offset ... in file with handle ...This is mostly temporary and S
QL
> server tries again to repeat the operation. If this error continues to hap
pen
> you have to take actions immediately to resolve the problem.
> --
> The executed query is:
> BACKUP LOG accountings TO
> DISK='e:\mssql\BACKUP\accountings\transa
kt_200705210928.bak'
> DBCC SHRINKFILE ('accountings_Protokoll',5120) WITH NO_INFOMSGS
> go
> Any ideas what action to take?
> Regards
> --Stefan
Have you looked at the what is in the SQL Server Error log? Can you backup
the database and then shrink the file manually as two separate batches?
John|||"John Bell" wrote:
> Hi Stefan
> Have you looked at the what is in the SQL Server Error log? Can you backup
> the database and then shrink the file manually as two separate batches?
> John
Hi John,
the backup did not succeed but stalled at some 8MB with running endlessly
and not consuming disk space. I put the database in single user mode, run
"backup log with truncate_only", then shrinked the log file, finally
performed a full backup of course.
The database is running again now. But the eventlog entries are still not
clear to me...
Thanks anyway
--Stefan|||Hi Stefan
"Stefan Funk" wrote:

> "John Bell" wrote:
> Hi John,
> the backup did not succeed but stalled at some 8MB with running endlessly
> and not consuming disk space. I put the database in single user mode, run
> "backup log with truncate_only", then shrinked the log file, finally
> performed a full backup of course.
> The database is running again now. But the eventlog entries are still not
> clear to me...
> Thanks anyway
> --Stefan
Have you checked that you haven't run out of resources such as memory?
Although nothing seems to relate to SQL 2005 there are some articles on this
error see http://tinyurl.com/yuwak5
Failing that you may want to call PSS if it happens again.
John

Event ID 851 in SQL2005 - what to do?

Hi,
when trying to shrink a transaction log file in SQL2005 we receive every few
minutes (for 4 hours now) the following Information in the event logs and the
shrink does not complete.
Type: Information
ID: 851
Source: MSSQLSERVER
Text (English translation follows): Das Betriebssystem hat den Fehler
1450(Nicht genügend Systemressourcen, um den angeforderten Dienst
auszuführen.) an SQL Server zurückgegeben. Dieser Fehler ist bei einem
Schreiben am Offset 0x000007c3ca3e00 in der Datei mit dem Handle 0x000008E4
aufgetreten. üblicherweise ist dies ein tempor?rer Zustand, und der Server
mit SQL Server versucht immer wieder, diesen Vorgang zu wiederholen. Wenn der
Zustand weiterhin besteht, muss sofort etwas unternommen werden, um das
Problem zu beheben.
In English (free translation): The operating System returned Error 1450 (not
enough system resources for executing the service) to the SQL server during
write at offset ... in file with handle ...This is mostly temporary and SQL
server tries again to repeat the operation. If this error continues to happen
you have to take actions immediately to resolve the problem.
The executed query is:
BACKUP LOG accountings TO
DISK='e:\mssql\BACKUP\accountings\transakt_2007052 10928.bak'
DBCC SHRINKFILE ('accountings_Protokoll',5120) WITH NO_INFOMSGS
go
Any ideas what action to take?
Regards
--Stefan
Hi Stefan
"Stefan Funk" wrote:

> Hi,
> when trying to shrink a transaction log file in SQL2005 we receive every few
> minutes (for 4 hours now) the following Information in the event logs and the
> shrink does not complete.
> --
> Type: Information
> ID: 851
> Source: MSSQLSERVER
> Text (English translation follows): Das Betriebssystem hat den Fehler
> 1450(Nicht genügend Systemressourcen, um den angeforderten Dienst
> auszuführen.) an SQL Server zurückgegeben. Dieser Fehler ist bei einem
> Schreiben am Offset 0x000007c3ca3e00 in der Datei mit dem Handle 0x000008E4
> aufgetreten. üblicherweise ist dies ein tempor?rer Zustand, und der Server
> mit SQL Server versucht immer wieder, diesen Vorgang zu wiederholen. Wenn der
> Zustand weiterhin besteht, muss sofort etwas unternommen werden, um das
> Problem zu beheben.
> --
> In English (free translation): The operating System returned Error 1450 (not
> enough system resources for executing the service) to the SQL server during
> write at offset ... in file with handle ...This is mostly temporary and SQL
> server tries again to repeat the operation. If this error continues to happen
> you have to take actions immediately to resolve the problem.
> --
> The executed query is:
> BACKUP LOG accountings TO
> DISK='e:\mssql\BACKUP\accountings\transakt_2007052 10928.bak'
> DBCC SHRINKFILE ('accountings_Protokoll',5120) WITH NO_INFOMSGS
> go
> Any ideas what action to take?
> Regards
> --Stefan
Have you looked at the what is in the SQL Server Error log? Can you backup
the database and then shrink the file manually as two separate batches?
John
|||"John Bell" wrote:
> Hi Stefan
> Have you looked at the what is in the SQL Server Error log? Can you backup
> the database and then shrink the file manually as two separate batches?
> John
Hi John,
the backup did not succeed but stalled at some 8MB with running endlessly
and not consuming disk space. I put the database in single user mode, run
"backup log with truncate_only", then shrinked the log file, finally
performed a full backup of course.
The database is running again now. But the eventlog entries are still not
clear to me...
Thanks anyway
--Stefan
|||Hi Stefan
"Stefan Funk" wrote:

> "John Bell" wrote:
> Hi John,
> the backup did not succeed but stalled at some 8MB with running endlessly
> and not consuming disk space. I put the database in single user mode, run
> "backup log with truncate_only", then shrinked the log file, finally
> performed a full backup of course.
> The database is running again now. But the eventlog entries are still not
> clear to me...
> Thanks anyway
> --Stefan
Have you checked that you haven't run out of resources such as memory?
Although nothing seems to relate to SQL 2005 there are some articles on this
error see http://tinyurl.com/yuwak5
Failing that you may want to call PSS if it happens again.
John

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.
Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/default...b;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>
|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/default...b;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
from[vbcol=seagreen]
have
> Error
>

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/defaul...kb;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/defaul...kb;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
from[vbcol=seagreen]
have[vbcol=seagreen]
> Error
>

Event ID 19011 Error 8335

I am getting this Warning in my Event logs and can find no reference from
any source. I find lots of references to Error 8344. The SQL user is a
member of the Local Administrators group as referenced in Q830215. I have
also seen statement that indicate this is benign. The contents of the Error
box are:
SuperSocket info: (SpnRegister) : Error 8335.
Thanks in advance for any help.Monty,
This is related to Kerberos. A little more information is available at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
Russell Fields
"Monty" <montysl@.nospam.hotmail.com> wrote in message
news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> I am getting this Warning in my Event logs and can find no reference from
> any source. I find lots of references to Error 8344. The SQL user is a
> member of the Local Administrators group as referenced in Q830215. I have
> also seen statement that indicate this is benign. The contents of the
Error
> box are:
> SuperSocket info: (SpnRegister) : Error 8335.
>
> Thanks in advance for any help.
>|||Thanks for your help Russell. In carefully reviewing the doc on the link and
comparing to my situation, I find that I meet the criteria in all instances
and still the error. I also notice that the specific error mentioned is 8344
about which there is a LOT of information available, just not 8335.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:%23biGioNcEHA.3580@.TK2MSFTNGP11.phx.gbl...
> Monty,
> This is related to Kerberos. A little more information is available at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;811889
> Russell Fields
> "Monty" <montysl@.nospam.hotmail.com> wrote in message
> news:O6dcIXNcEHA.3792@.TK2MSFTNGP09.phx.gbl...
> > I am getting this Warning in my Event logs and can find no reference
from
> > any source. I find lots of references to Error 8344. The SQL user is a
> > member of the Local Administrators group as referenced in Q830215. I
have
> > also seen statement that indicate this is benign. The contents of the
> Error
> > box are:
> > SuperSocket info: (SpnRegister) : Error 8335.
> >
> >
> >
> > Thanks in advance for any help.
> >
> >
>

Event ID 107 Problem

Hi,

I'm having problem with getting rid of the schedule and Delivery Processor error I'm currently seeing in the event logs. Can someone help me out here? error below:

Domain\Servername : F Schedule and Delivery Processor_107_E: Schedule and Delivery Processor cannot connect to the report server database.

Help!!!!!!

Make sure your have database connections set up correctly. Redo the "database connection" panel in the config tool.|||

I have this problem too, but it is because I uninstalled SQL Server and Reporting Services from this machine. I just have this ghost left and complaining - how do I get rid of the "Schedule & Delivery Processor"?

Thanks

Hans

|||You shouldn't get an error like that if RS windows service is removed. Check if SQL reporting services is really removed in service control manager.