Error replication agent is not registered properly

We've been running transactional replication with updatable subscribers for
several months now. his morning we are seeing these errors in the LOG and
QUEUE READER logs.
You Receive Error Message: "The replication agent is not registered
properly. Rerun SQL Server setup.
Any ideas?
SQL Server 2000 SP3
Running the following command would likely resolve the issue:
"%ProgramFiles%\Microsoft SQL Server\80\COM\qrdrsvc.exe" -RegServer
Although I am curious to know if you have installed\uninstalled software
recently on the box that might have caused the problem in the first place.
-Raymond
"CAP" <abraxas1969@.hotmail.com> wrote in message
news:ehtb84P$FHA.740@.TK2MSFTNGP12.phx.gbl...
> We've been running transactional replication with updatable subscribers
> for
> several months now. his morning we are seeing these errors in the LOG and
> QUEUE READER logs.
>
> You Receive Error Message: "The replication agent is not registered
> properly. Rerun SQL Server setup.
>
> Any ideas?
> SQL Server 2000 SP3
>
|||Appreciate the info !
We are investigating if changes to either the OS or SQLServer itself are the
root cause of this problem. We are seeing that in addition to the queue
reader agent, these are also experiencing the same errors:
LOG READER agent
SNAPSHOT agent
DISTRIBUTION agent.
Does this means we also need to run the command below to register the above
agents as well or just 'qrdrsvc.exe' as you indicate?
==============
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
news:O2nEgfS$FHA.140@.TK2MSFTNGP12.phx.gbl...
> Running the following command would likely resolve the issue:
> "%ProgramFiles%\Microsoft SQL Server\80\COM\qrdrsvc.exe" -RegServer
> Although I am curious to know if you have installed\uninstalled software
> recently on the box that might have caused the problem in the first place.
> -Raymond
> "CAP" <abraxas1969@.hotmail.com> wrote in message
> news:ehtb84P$FHA.740@.TK2MSFTNGP12.phx.gbl...
>
|||This seems really strange, is this a clustered SQL Server instance or was
there a registry restore\repair on the box?
In any case, you can probably resolve the issue that you are seeing by
running the agent executables with the -RegServer parameter:
Snapshot agent - snapshot.exe
Logreader agent - logread.exe
Distribution agent - distrib.exe
If the problem is as extensive as it seems to be you may also need to
re-register the support dlls for the replication agents using regsvr32.exe.
Here is a list off the top of my head:
rinitcom.dll
repldp.dll
rdistcom.dll
-Raymond
"GuayacanSQL" <abraxas1969@.hotmail.com> wrote in message
news:eDajBto$FHA.3864@.TK2MSFTNGP12.phx.gbl...
> Appreciate the info !
>
> We are investigating if changes to either the OS or SQLServer itself are
> the root cause of this problem. We are seeing that in addition to the
> queue reader agent, these are also experiencing the same errors:
>
> LOG READER agent
> SNAPSHOT agent
> DISTRIBUTION agent.
>
> Does this means we also need to run the command below to register the
> above agents as well or just 'qrdrsvc.exe' as you indicate?
>
> ==============
> "Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
> news:O2nEgfS$FHA.140@.TK2MSFTNGP12.phx.gbl...
>
|||This is a 2-node clustered SQLServer environment. Word were are getting is
that an attempt to install a new named instance on the cluster failed
(reason unknown) and had to be uninstalled. We are seeing these errors right
after this happened.
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
news:%23wyI2D0$FHA.2736@.TK2MSFTNGP11.phx.gbl...
> This seems really strange, is this a clustered SQL Server instance or was
> there a registry restore\repair on the box?
> In any case, you can probably resolve the issue that you are seeing by
> running the agent executables with the -RegServer parameter:
> Snapshot agent - snapshot.exe
> Logreader agent - logread.exe
> Distribution agent - distrib.exe
> If the problem is as extensive as it seems to be you may also need to
> re-register the support dlls for the replication agents using
regsvr32.exe.[vbcol=seagreen]
> Here is a list off the top of my head:
> rinitcom.dll
> repldp.dll
> rdistcom.dll
> -Raymond
> "GuayacanSQL" <abraxas1969@.hotmail.com> wrote in message
> news:eDajBto$FHA.3864@.TK2MSFTNGP12.phx.gbl...
software[vbcol=seagreen]
subscribers
>
|||It was determined that uninstalling one of the SQL instances on the cluster
caused the replication agents to be unregistered. We executed the commands
below and all went well with the exception of the QUEUE READER agent. When
we attempt to register the queue reader agent with 'qrdrsvc.exe regserver'
we get this error:
===================
Microsoft SQL Server Replication Queue Reader Agent 8.00.760 Copyright (c)
2000 Microsoft Corporation
Server: SERVER1, Database distribution : ODBC Error:SQL Server does not
exist or access denied.
Unable to connect to Local Distributor
Queue Reader aborting
=======================
Is there something special about registering queue reader agent ?
"CAP" <abraxas1969@.hotmail.com> wrote in message
news:OcDiKc0$FHA.140@.TK2MSFTNGP12.phx.gbl...
> This is a 2-node clustered SQLServer environment. Word were are getting is
> that an attempt to install a new named instance on the cluster failed
> (reason unknown) and had to be uninstalled. We are seeing these errors
right[vbcol=seagreen]
> after this happened.
>
> "Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
> news:%23wyI2D0$FHA.2736@.TK2MSFTNGP11.phx.gbl...
was[vbcol=seagreen]
> regsvr32.exe.
are[vbcol=seagreen]
> software
> subscribers
LOG
>
|||That seems kind of strange as I didn't get any messages when I tried the
same on my machine. But if you can start the queue reader agent from
SEM\SQLServerAgent then I wouldn't worry too much about it.
-Raymond
"CAP" <abraxas1969@.hotmail.com> wrote in message
news:eLNoFckAGHA.1312@.TK2MSFTNGP09.phx.gbl...
> It was determined that uninstalling one of the SQL instances on the
> cluster
> caused the replication agents to be unregistered. We executed the commands
> below and all went well with the exception of the QUEUE READER agent.
> When
> we attempt to register the queue reader agent with
> 'qrdrsvc.exe -regserver'
> we get this error:
> ===================
> Microsoft SQL Server Replication Queue Reader Agent 8.00.760 Copyright (c)
> 2000 Microsoft Corporation
> Server: SERVER1, Database distribution : ODBC Error:SQL Server does not
> exist or access denied.
> Unable to connect to Local Distributor
> Queue Reader aborting
> =======================
> Is there something special about registering queue reader agent ?
>
> "CAP" <abraxas1969@.hotmail.com> wrote in message
> news:OcDiKc0$FHA.140@.TK2MSFTNGP12.phx.gbl...
> right
> was
> are
> LOG
>
|||I'm sorry. Can you please elaborate more on what you mean with
SEM\SQLServerAgent ? We are trying to start the queue reader agent from
Enterprise Manager and keep getting the error:
"The replication agent is not registered properly. Rerun SQL Server setup"
===================
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
news:OdN0KTmAGHA.204@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> That seems kind of strange as I didn't get any messages when I tried the
> same on my machine. But if you can start the queue reader agent from
> SEM\SQLServerAgent then I wouldn't worry too much about it.
> -Raymond
> "CAP" <abraxas1969@.hotmail.com> wrote in message
> news:eLNoFckAGHA.1312@.TK2MSFTNGP09.phx.gbl...
commands[vbcol=seagreen]
(c)[vbcol=seagreen]
by[vbcol=seagreen]
to[vbcol=seagreen]
itself[vbcol=seagreen]
the[vbcol=seagreen]
the[vbcol=seagreen]
Server\80\COM\qrdrsvc.exe" -RegServer[vbcol=seagreen]
first[vbcol=seagreen]
registered
>
|||Hi Mark,
When a replication agent is started through a SQL Server Agent job (which is
the same as starting a replication agent from SEM), SQL Server Agent will
activate the replication agent as a COM exe server rather than running it as
a regular executable. That is why I suspect that the COM registration
information for the replication agents was broken when you first reported
the problem. Now from what you have described, your SQL Server installation
was broken due to a clustered instance uninstall so a better course of
action is probably for you to reinstall SQL server rather than trying to fix
bits and pieces of it since nobody knows exactly what pieces are broken.
That said, it is still strange that running 'qrdrsvc.exe -regserver' didn't
return without errors for you (you would want to make sure that Word didn't
mangle the - for you...).
-Raymond
"CAP" <abraxas1969@.hotmail.com> wrote in message
news:u4%234FonAGHA.3872@.TK2MSFTNGP12.phx.gbl...
> I'm sorry. Can you please elaborate more on what you mean with
> SEM\SQLServerAgent ? We are trying to start the queue reader agent from
> Enterprise Manager and keep getting the error:
> "The replication agent is not registered properly. Rerun SQL Server setup"
> ===================
> "Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
> news:OdN0KTmAGHA.204@.TK2MSFTNGP15.phx.gbl...
> commands
> (c)
> by
> to
> itself
> the
> the
> Server\80\COM\qrdrsvc.exe" -RegServer
> first
> registered
>
|||In fact, this is what we are getting when running 'qrdrsvc.exe -regserver'
as a server administrator (with System Administrator role on the SQL server)
Microsoft SQL Server Replication Queue Reader Agent 8.00.760 Copyright (c)
2000 Microsoft Corporation
Server: SERVER1, Database distribution : ODBC Error:SQL Server does not
exist or access denied.
Unable to connect to Local Distributor
Queue Reader aborting
The process finished. Use CTRL+C to close this window.
=========================
"Raymond Mak [MSFT]" <rmak@.online.microsoft.com> wrote in message
news:%23USLY0nAGHA.516@.TK2MSFTNGP15.phx.gbl...
> Hi Mark,
> When a replication agent is started through a SQL Server Agent job (which
is
> the same as starting a replication agent from SEM), SQL Server Agent will
> activate the replication agent as a COM exe server rather than running it
as
> a regular executable. That is why I suspect that the COM registration
> information for the replication agents was broken when you first reported
> the problem. Now from what you have described, your SQL Server
installation
> was broken due to a clustered instance uninstall so a better course of
> action is probably for you to reinstall SQL server rather than trying to
fix
> bits and pieces of it since nobody knows exactly what pieces are broken.
> That said, it is still strange that running 'qrdrsvc.exe -regserver'
didn't
> return without errors for you (you would want to make sure that Word
didn't[vbcol=seagreen]
> mangle the - for you...).
> -Raymond
> "CAP" <abraxas1969@.hotmail.com> wrote in message
> news:u4%234FonAGHA.3872@.TK2MSFTNGP12.phx.gbl...
setup"[vbcol=seagreen]
the[vbcol=seagreen]
Copyright[vbcol=seagreen]
not[vbcol=seagreen]
failed[vbcol=seagreen]
errors[vbcol=seagreen]
seeing[vbcol=seagreen]
need[vbcol=seagreen]
to[vbcol=seagreen]
register[vbcol=seagreen]
message
>

Error on SP2 SQL2000 RS

An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
a.. Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
How do I fix this? The log entry looks like:
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing encryption
key
w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to GetSystemPermissions
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
GetPermissions:/Lockout
w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
GetPermissions:/Lockout/NTLM Lockout Trending Weekly
w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system
properties.
w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to GetSystemPermissions
w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
ResponseBufferSizeKb to default value of '64' KB because it was not
specified in Server system properties.
w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.TypeLoadException: Could not load type
Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
Microsoft.ReportingServices.Interfaces, Version=8.0.242.0, Culture=neutral,
PublicKeyToken=89845dcd8080cc91.
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
streamFactory)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --Strange. Are you running SP2? The only thing I can think of is to clear our
your ASP.NET temporary files folder
(C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
Also, be sure you only have one version of the Interfaces assembly around.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"almoendale" <no_spam@.nowhere.net> wrote in message
news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
> An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help
> a.. Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> How do I fix this? The log entry looks like:
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as user:
> NT AUTHORITY\NETWORK SERVICE
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
> encryption key
> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetPermissions:/Lockout
> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
> EnableIntegratedSecurity to 'True' as specified in Server system
> properties.
> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
> GetSystemPermissions
> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
> ResponseBufferSizeKb to default value of '64' KB because it was not
> specified in Server system properties.
> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details. --> System.TypeLoadException: Could not load type
> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --
>|||Brian:
I cleared out the ASP.net temp folder, no success. I have RS SP2 (do
*not* have W2K3 SP1), have attempted to re-apply RS SP2, which didn't help.
I am getting errors out of other web parts too on this WSS site (SP1 there
BTW). This box is a rather old dev crash box that may well need to be
rebuilt. it has everything but the kitchen sink so to speak: (Project
Server03, WSS, SQL RS, Maestro Beta, numerous custom web parts, etc.) Wish I
could just roll it back to about 2 weeks back when everything was working
ducky.
Interestingly the Samples all fail too.
I guess what bothers me most is the cryptic (bullet with a question
mark) nature of the error display:
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error
log for more details. (rsInternalError) Get Online Help
a.. ?
----
Microsoft Reporting Services
Alex
======================================================
Explanation
Internal errors are uncommon and may be difficult to diagnose. If you
get this error, you can look in trace logs for more information.
Note that if you renamed the computer that hosts the report server,
you may encounter internal errors related to the name change (specifically,
"A severe error occurred on the current command" error or "RPC server is not
listening"). If you renamed the computer, you can run the rsconfig utility
to update the system information that is stored by the report server.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message
news:urZJNJAgFHA.3584@.TK2MSFTNGP09.phx.gbl...
> Strange. Are you running SP2? The only thing I can think of is to clear
> our your ASP.NET temporary files folder
> (C:\windows\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files).
> Also, be sure you only have one version of the Interfaces assembly around.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "almoendale" <no_spam@.nowhere.net> wrote in message
> news:urkNxU%23fFHA.3232@.TK2MSFTNGP15.phx.gbl...
>> An internal error occurred on the report server. See the error log for
>> more details. (rsInternalError) Get Online Help
>> a.. Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> How do I fix this? The log entry looks like:
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Initializing crypto as
>> user: NT AUTHORITY\NETWORK SERVICE
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Exporting public key
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Performing sku validation
>> w3wp!crypto!270!07/03/2005-11:34:29:: i INFO: Importing existing
>> encryption key
>> w3wp!library!270!07/03/2005-11:34:29:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetPermissions:/Lockout
>> w3wp!library!fe0!07/03/2005-11:34:33:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetPermissions:/Lockout/NTLM Lockout Trending Weekly
>> w3wp!library!290!07/03/2005-11:34:37:: i INFO: Initializing
>> EnableIntegratedSecurity to 'True' as specified in Server system
>> properties.
>> w3wp!library!270!07/03/2005-11:34:37:: i INFO: Call to
>> GetSystemPermissions
>> w3wp!library!270!07/03/2005-11:34:47:: i INFO: Initializing
>> ResponseBufferSizeKb to default value of '64' KB because it was not
>> specified in Server system properties.
>> w3wp!webserver!270!07/03/2005-11:34:47:: e ERROR: Internal error:
>> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> w3wp!library!270!07/03/2005-11:34:47:: e ERROR: Throwing
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details., ;
>> Info:
>> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
>> An internal error occurred on the report server. See the error log for
>> more details. --> System.TypeLoadException: Could not load type
>> Microsoft.ReportingServices.Interfaces.IRenderStream from assembly
>> Microsoft.ReportingServices.Interfaces, Version=8.0.242.0,
>> Culture=neutral, PublicKeyToken=89845dcd8080cc91.
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
>> streamFactory)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
>> itemType)
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
>> at
>> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
>> -- End of inner exception stack trace --
>>
>sql

Error on replication

Hi,
when i try to run an push-replication on MS SQL 2000
i get the error "Log file is full" on the subscriber.
I tried to make this grow VERY much, but it doesnt help.
The table that fails has over 75000 posts, so maybe that is an issue.

The error occurs when i for the first time tries to sync it...

Any ideas?

// PeterTry breaking your task into smaller units of work.

You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

Good Luck,|||Well, the thing is... i only want to replicate this to a server, and not
run any scripts. Shouldnt MS-SQL handle this?

I tried the push-operation without the LARGE-table (75000 posts)
and it worked. So it has something to do with that.
Any more suggestions?

Please?!!

// Peter

Originally posted by Bruce A. Baasch
Try breaking your task into smaller units of work.

You would normally be using "BeginTrans" and "CommitTrans" to free up the log space in a program after a unit of work has been completed.

Good Luck,sql

Error occuring when seeking to backup of transaction log with no_truncate

Dear Group,
I had a database failure and tried to backup the last few
transactions in the log file using the no-truncate option
and it failed with the following error statement
"could not open fcb for invalid file ID 0 in database ..."
I am running SQL Server Enterprise Edition on Windows 2000
Server with SP 4 installed.
SQL Server has SP3 installed.
I have never seen this problem previously.
Just before I tried this operation I installed the latest
Windows Updates for Windows 2000.
Any thoughts.
David Watkins
MCT MCSE MCDBAAre you certain that this isn't SQL7? In SQL7, you couldn't do this is the mdf file was lost. If
this indeed is SQL2K, and the ldf files are healthy, I suggest you open a case with MS...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"david watkins" <dwatkins@.pacific.net.au> wrote in message
news:2023001c458e2$c09526f0$a401280a@.phx.gbl...
> Dear Group,
> I had a database failure and tried to backup the last few
> transactions in the log file using the no-truncate option
> and it failed with the following error statement
> "could not open fcb for invalid file ID 0 in database ..."
> I am running SQL Server Enterprise Edition on Windows 2000
> Server with SP 4 installed.
> SQL Server has SP3 installed.
> I have never seen this problem previously.
> Just before I tried this operation I installed the latest
> Windows Updates for Windows 2000.
> Any thoughts.
> David Watkins
> MCT MCSE MCDBA

error number 1612

I'm doing a reinstall of SQL 2005 Standard Edition but I get this cryptic error message in the installation log file when it tries to install Integration Services or Notification Services. How do I resolve this? I've spent countless hours un-installing and re-installing the product.I looked at the log file and the message says 'The installation source for this product is not available. Verify that the source exists and that you can access it.' It seems to be a problem with the Windows Installer. How do I fix this?|||

Someone else posted a similar problem in the past day. If you're not using the original media to do the reinstall, please try that. If you are, please post again and I'll find a Setup developer and get specific advice from him about this problem.

Paul

|||Thanks for replying, Paul. I am using the original media for the reinstall and I have submitted a more detailed post of this problem in this section under the subject heading 'Cannot install SSIS or Notification services'.

Error Messages in Log

I found the following message in my current SQL Server
log. Can anyone tell me what they mean? I'm using 2000
8.00.194 on NT 5.0 SP1. There were 16 of each message and
like message were grouped together.
DATE SOURCE MESSAGE
410735 D0 Module(UMS+000035D0)
(ProcessWorkRequests(class UmsWorkQueue *)+00000264)
4107382 C Module(UMS+0000382C)
(ThreadStartRoutine(void *)+000000BC)
77 E837CD Module(KERNEL32+000037CD)
(TlsSetValue+000000F0)
7800 BEA1 Module(MSVCRT+0000BEA1)
(_beginthread+000000CE)
The databases are poorly designed and are accessed by
several applications, some ColdFusion and others Java.Hi PJ,
Have you considered applying latest service pack to SQL Server 2000? There seems to be a number of known issues fixed in later service pack.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| Content-Class: urn:content-classes:message
| From: "PJ" <pdudeck@.rewardsplus.com>
| Sender: "PJ" <pdudeck@.rewardsplus.com>
| Subject: Error Messages in Log
| Date: Thu, 25 Sep 2003 10:16:45 -0700
| Lines: 18
| Message-ID: <044901c38388$cc095360$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcODiMwHKmS2Tz9qQViEMomO8fYbzQ==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308348
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I found the following message in my current SQL Server
| log. Can anyone tell me what they mean? I'm using 2000
| 8.00.194 on NT 5.0 SP1. There were 16 of each message and
| like message were grouped together.
|
| DATE SOURCE MESSAGE
| 410735 D0 Module(UMS+000035D0)
| (ProcessWorkRequests(class UmsWorkQueue *)+00000264)
| 4107382 C Module(UMS+0000382C)
| (ThreadStartRoutine(void *)+000000BC)
| 77 E837CD Module(KERNEL32+000037CD)
| (TlsSetValue+000000F0)
| 7800 BEA1 Module(MSVCRT+0000BEA1)
| (_beginthread+000000CE)
|
| The databases are poorly designed and are accessed by
| several applications, some ColdFusion and others Java.
|
|

Error messages in event log - bucket table 5

I keep getting this error in my event log:

Bucket 04944163, bucket table 5, EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f1e826d, P9 00000000, P10 NIL.

SQL server 2005, Windows 2003

I cannot find anything on the web or in help about this - any clues anyone?

What kind of app are you running- a Windows Service, Web Service, etc?|||

Bucket 04944163, bucket table 5, EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f1e826d, P9 00000000, P10 NIL.

This line is information about a crash that was uploaded to Microsoft Watson. Are you using SQL Server 2005 RTM Report Server in an ASP.NET App?

|||I am using SQL 2005 RTM within an ASP page. Our whole reporting server crashed witha refusal to display any reports this morning. No clues as to what was wrong, then it came up - no rhyme nor erason to it. Anyone have any ideas?

Error messages in event log - bucket table 5

I keep getting this error in my event log:

Bucket 04944163, bucket table 5, EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f1e826d, P9 00000000, P10 NIL.

SQL server 2005, Windows 2003

I cannot find anything on the web or in help about this - any clues anyone?

What kind of app are you running- a Windows Service, Web Service, etc?|||

Bucket 04944163, bucket table 5, EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 sqldumper_unknown_module.dll, P5 0.0.0.0, P6 00000000, P7 0, P8 0f1e826d, P9 00000000, P10 NIL.

This line is information about a crash that was uploaded to Microsoft Watson. Are you using SQL Server 2005 RTM Report Server in an ASP.NET App?

|||I am using SQL 2005 RTM within an ASP page. Our whole reporting server crashed witha refusal to display any reports this morning. No clues as to what was wrong, then it came up - no rhyme nor erason to it. Anyone have any ideas?

Error Messages

I need help with the following error messages found in my Error Log
2003-11-12 09:34:51.17 spid276 Getpage: bstat=0x9, sstat=0x4000, cach
2003-11-12 09:34:51.17 spid276 pageno is/should be: objid is/should be
2003-11-12 09:34:51.17 spid276 (1:25328)/(1:25328) 0/44297864
2003-11-12 09:34:51.17 spid276 ... IAM indicates that page is allocated to this objec
2003-11-12 09:34:51.18 spid276 Error: 605, Severity: 21, State:
2003-11-12 09:34:51.18 spid276 Attempt to fetch logical page (1:25328) in database 'tempdb' belongs to object '0', not to object '#tblMaxSourceDate___________________________________________________________________________________________________000100000544'.
2003-11-12 09:37:19.12 spid262 Error: 823, Severity: 24, State:
2003-11-12 09:37:19.12 spid262 I/O error (bad page ID) detected during read at offset 0x00000000bc4000 in file 'x:\mssql2000\MSSQL\data\tempdb.mdf'.
Here is what has been done so far. This is on a clustered server. We have replaced both the controllers and the backplane in the shared drive array. We have also completely turned off write cacheing on the controllers. We have also stopped services so that tempdb would be recreated when we started back up, hoping to get rid of the errors that way. The only thing I can now guess is that one of the drives in the striped array must have some bad sectors. These errors have been occuring sporadically for over a week. Sometimes Error 625 is sprinkled in with the above errors. I am at a loss
Can anyone think of anything else that I might be missing?From google, these two errors are most probabily disk
problems. Check the disk of tempdb resides.
>--Original Message--
>I need help with the following error messages found in my
Error Log.
>2003-11-12 09:34:51.17 spid276 Getpage: bstat=0x9,
sstat=0x4000, cache
>2003-11-12 09:34:51.17 spid276 pageno is/should be:
objid is/should be:
>2003-11-12 09:34:51.17 spid276 (1:25328)/(1:25328)
0/442978642
>2003-11-12 09:34:51.17 spid276 ... IAM indicates that
page is allocated to this object
>2003-11-12 09:34:51.18 spid276 Error: 605, Severity:
21, State: 1
>2003-11-12 09:34:51.18 spid276 Attempt to fetch logical
page (1:25328) in database 'tempdb' belongs to object '0',
not to
object '#tblMaxSourceDate__________________________________
___________________________________________________________
______000100000544'..
>2003-11-12 09:37:19.12 spid262 Error: 823, Severity:
24, State: 2
>2003-11-12 09:37:19.12 spid262 I/O error (bad page ID)
detected during read at offset 0x00000000bc4000 in
file 'x:\mssql2000\MSSQL\data\tempdb.mdf'..
>
>Here is what has been done so far. This is on a
clustered server. We have replaced both the controllers
and the backplane in the shared drive array. We have also
completely turned off write cacheing on the controllers.
We have also stopped services so that tempdb would be
recreated when we started back up, hoping to get rid of
the errors that way. The only thing I can now guess is
that one of the drives in the striped array must have some
bad sectors. These errors have been occuring sporadically
for over a week. Sometimes Error 625 is sprinkled in with
the above errors. I am at a loss.
>Can anyone think of anything else that I might be missing?
>.
>

Error Message: Failed to initialize Distributed COM

Here is the full message from the Event Log.

Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

Any ideas as to how to troubleshoot or solve this?

Thanks!

What are you doing when you get this error?

Mike

|||

Attempting to run a check database from Act 2007 diagnostics.

Error Message with seemingly no effect!

Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
Jonas
Possibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>

Error Message with seemingly no effect!

Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lo
t of option in that dialog are
sp_configure parameters.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.
phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever
.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>

Error Message with seemingly no effect!

Below is 2 lines from my error log.
These 2 lines occure every now and then. There seem to be no system in the
occurence and it doesnt seem to have any effect on the server what so ever.
But if someone knew why and what to do in order to get rid of them?
- 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
- 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
Thanks.
Regards
JonasPossibly someone right-clicking the server in EM and select properties. A lot of option in that dialog are
sp_configure parameters.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jonas Larsen" <Jonas.Larsen@.Alcan.com> wrote in message news:eLKtg6neEHA.1656@.TK2MSFTNGP09.phx.gbl...
> Below is 2 lines from my error log.
> These 2 lines occure every now and then. There seem to be no system in the
> occurence and it doesnt seem to have any effect on the server what so ever.
> But if someone knew why and what to do in order to get rid of them?
> - 2004-08-05 09:30:51.01 spid84 Error: 15457, Severity: 0, State: 1
> - 2004-08-05 09:30:51.01 spid84 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> Thanks.
> Regards
> Jonas
>

Error message trying to log into Report Manager

I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
Standard or whatever comes with SBS Premium.
I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
Reporting Services in this instance using the default config during the
installation.
When I try to connect to Reporting Services with SSMS on the local
machine using Windows Authentication logged in as Administrator I get
the following error:
Cannot connect to SERVER\MSGPSBM
Additional Information:
Unable to connect to the remote server (System)
No connection could be made because the target machine actively refused
it (System)
When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
Error Unable to connect to the remote server. message
I can log into the database engine just fine.
What am I doing wrong?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/20/2007 10:45:44 AMHello,
When you use SQL Server Reporting Services Configuration Manager can you log
to SSRS service?
If so check which of the points are marked on red. All of them should be
green or blue (if no active).
This is the first step to recognize where is the problem.
I suppose it could be a problem with accounts (Windows Services Account or
IIS Application Pool Account)
Best Regards,
Radoslaw Lebkowski
Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal w
wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
>I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> Standard or whatever comes with SBS Premium.
> I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
> Reporting Services in this instance using the default config during the
> installation.
> When I try to connect to Reporting Services with SSMS on the local
> machine using Windows Authentication logged in as Administrator I get
> the following error:
> Cannot connect to SERVER\MSGPSBM
> Additional Information:
> Unable to connect to the remote server (System)
> No connection could be made because the target machine actively refused
> it (System)
> When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> Error Unable to connect to the remote server. message
> I can log into the database engine just fine.
> What am I doing wrong?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 12/20/2007 10:45:44 AM|||All are green except:
Encryption Keys - Blue
Initialization - gray
Email Settings - yellow
Execution Account - yellow
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 8:37:59 AM
Radoslaw Lebkowski wrote:
> Hello,
> When you use SQL Server Reporting Services Configuration Manager can
> you log to SSRS service?
> If so check which of the points are marked on red. All of them should
> be green or blue (if no active).
> This is the first step to recognize where is the problem.
> I suppose it could be a problem with accounts (Windows Services
> Account or IIS Application Pool Account)
> Best Regards,
> Radoslaw Lebkowski
>
>
> Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal
> w wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
> > I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> > Standard or whatever comes with SBS Premium.
> >
> > I installed SQL as a named instance (SERVER\MSGPSBM) and also
> > installed Reporting Services in this instance using the default
> > config during the installation.
> >
> > When I try to connect to Reporting Services with SSMS on the local
> > machine using Windows Authentication logged in as Administrator I
> > get the following error:
> >
> > Cannot connect to SERVER\MSGPSBM
> > Additional Information:
> > Unable to connect to the remote server (System)
> > No connection could be made because the target machine actively
> > refused it (System)
> >
> > When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> > Error Unable to connect to the remote server. message
> >
> > I can log into the database engine just fine.
> >
> > What am I doing wrong?
> > -- Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 12/20/2007 10:45:44 AM|||I'm still learning.
My Report Server had been configured to use SSL. I turned that off and
now it works.
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 9:17:34 AM
Japheth Nolt wrote:
> All are green except:
> Encryption Keys - Blue
> Initialization - gray
> Email Settings - yellow
> Execution Account - yellow

Error message showing the log file for database is full

Hi,
I am working with a sql server 2000 database where it says the log file for the database accounting is full. It also says to back up the transaction log for the database to free up some log space.
My question is:
1) Is is necessary to make a transaction log backup on a regular basis?
2) Is there any chance of corrupting the database by trying this process? At present due to shortage of space there is no backup of the production database.
Thanks in advance> 1) Is is necessary to make a transaction log backup on a regular basis?
We cannot dictate your backup strategy, only you can. I prefer to do both database as well as log backups, in
general. If you don't want to do regular log backups, just set the recovery model to simple! Read about
recovery models in books online.
> 2) Is there any chance of corrupting the database by trying this process? At present due to shortage of
space there is no backup of the > production database.
What do you mean by "trying this process". If you specify what that mean, we can probably comment on that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <John@.discussions.microsoft.com> wrote in message
news:A5765959-98BD-4995-8401-6AC07B5A4311@.microsoft.com...
> Hi,
> I am working with a sql server 2000 database where it says the log file for the database accounting is full.
It also says to back up the transaction log for the database to free up some log space.
> My question is:
> 1) Is is necessary to make a transaction log backup on a regular basis?
> 2) Is there any chance of corrupting the database by trying this process? At present due to shortage of
space there is no backup of the production database.
> Thanks in advance

Error message showing the log file for database is full

Hi,
I am working with a sql server 2000 database where it says the log file for the database accounting is full. It also says to back up the transaction log for the database to free up some log space.
My question is:
1) Is is necessary to make a transaction log backup on a regular basis?
2) Is there any chance of corrupting the database by trying this process? At present due to shortage of space there is no backup of the production database.
Thanks in advance
> 1) Is is necessary to make a transaction log backup on a regular basis?
We cannot dictate your backup strategy, only you can. I prefer to do both database as well as log backups, in
general. If you don't want to do regular log backups, just set the recovery model to simple! Read about
recovery models in books online.

> 2) Is there any chance of corrupting the database by trying this process? At present due to shortage of
space there is no backup of the > production database.
What do you mean by "trying this process". If you specify what that mean, we can probably comment on that.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <John@.discussions.microsoft.com> wrote in message
news:A5765959-98BD-4995-8401-6AC07B5A4311@.microsoft.com...
> Hi,
> I am working with a sql server 2000 database where it says the log file for the database accounting is full.
It also says to back up the transaction log for the database to free up some log space.
> My question is:
> 1) Is is necessary to make a transaction log backup on a regular basis?
> 2) Is there any chance of corrupting the database by trying this process? At present due to shortage of
space there is no backup of the production database.
> Thanks in advance

Error message showing the log file for database is full

Hi,
I am working with a sql server 2000 database where it says the log file for
the database accounting is full. It also says to back up the transaction lo
g for the database to free up some log space.
My question is:
1) Is is necessary to make a transaction log backup on a regular basis?
2) Is there any chance of corrupting the database by trying this process? At
present due to shortage of space there is no backup of the production datab
ase.
Thanks in advance> 1) Is is necessary to make a transaction log backup on a regular basis?
We cannot dictate your backup strategy, only you can. I prefer to do both da
tabase as well as log backups, in
general. If you don't want to do regular log backups, just set the recovery
model to simple! Read about
recovery models in books online.

> 2) Is there any chance of corrupting the database by trying this process? At prese
nt due to shortage of
space there is no backup of the > production database.
What do you mean by "trying this process". If you specify what that mean, we
can probably comment on that.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John" <John@.discussions.microsoft.com> wrote in message
news:A5765959-98BD-4995-8401-6AC07B5A4311@.microsoft.com...
> Hi,
> I am working with a sql server 2000 database where it says the log file for the da
tabase accounting is full.
It also says to back up the transaction log for the database to free up some log space.[vbco
l=seagreen]
> My question is:
> 1) Is is necessary to make a transaction log backup on a regular basis?
> 2) Is there any chance of corrupting the database by trying this process? At prese
nt due to shortage of[/vbcol]
space there is no backup of the production database.
> Thanks in advance

error message not being logged to windows event log

Hi,
I am trying to get a message (#18453 - Login succeeded for use '%ls%'. Conn
ection: Trusted) to the windows event log. It's severity is 14 and it is al
ready checked off as a logged event, but it is not being logged. Is this a
bug or is there something e
lse I need to configure?
Regards
ALogin messages are handled differently in terms of
configuring with sp_altermessage. To log all of your logins
to the event log, open Enterprise Manager, right click on
the server and select properties. On the security tab, set
the audit level to all. This will log success and failed
logins to the event log.
-Sue
On Sun, 21 Mar 2004 11:06:07 -0800, "anon"
<anonymous@.discussions.microsoft.com> wrote:

>Hi,
>I am trying to get a message (#18453 - Login succeeded for use '%ls%'. Connection:
Trusted) to the windows event log. It's severity is 14 and it is already checked o
ff as a logged event, but it is not being logged. Is this a bug or is there somethi
ng
else I need to configure?
>Regards
>A|||Hi Sue,
I have done that but still it is not being logged. My log in consists of me
opening a new window in Query Analyzer and logging in with a SQL Server log
in and password, not through Windows authentication, though I don't think th
is would matter...
Is there anything I'm missing here?
Regards,
A|||Did you restart SQL Server after changing the audit logins
setting?
-Sue
On Mon, 22 Mar 2004 15:46:08 -0800, "anon"
<anonymous@.discussions.microsoft.com> wrote:

>Hi Sue,
>I have done that but still it is not being logged. My log in consists of m
e opening a new window in Query Analyzer and logging in with a SQL Server lo
gin and password, not through Windows authentication, though I don't think t
his would matter...
>Is there anything I'm missing here?
>Regards,
>A|||Thank you Sue. That worked.|||Sue Hoegemeier <Sue_H@.nomail.please> wrote:
> On Mon, 22 Mar 2004 15:46:08 -0800, "anon"
> <anonymous@.discussions.microsoft.com> wrote:
I'm no expert in SQL/MSDE, far from it. But from what I've (remembered of
what) I've read, I thought the login audit logging only went to file
LOGS\ERRORLOG and not to the Event Log.
Anyway that's the behaviour I see here: AuditLevel=3 and I get entries in
the ERRORLOG but nothing apparent in the Event Log. I'm not using SQL
authentication so the entries are of the form:
2004-03-19 21:39:25.81 logon Login succeeded for user 'DOM\usr'.
Connection: Trusted.
and if I try sa not using the correct password I get:
2004-03-23 16:33:57.51 logon Login failed for user 'sa'.
I may well be wrong on the non logging to the Event Log...but check the
contents of ERRORLOG anyway to see if the logging is occuring there.
> Did you restart SQL Server after changing the audit logins
> setting?
>
Or maybe that has solved it already...
--
Alan J. McFarlane
http://homepage.ntlworld.com/alanjmcf/
Please follow-up in the newsgroup for the benefit of all.|||Anon restarted SQL Server after making the changes which
solved the problem.
Logging to the Windows event log is enabled by default for
SQL Server. The auditing is logged to the SQL Server error
log and the Windows Application event log if you haven't
changed the default settings. You can find more information
on this in books online under startup options.
-Sue
On Tue, 23 Mar 2004 16:44:50 -0000, "Alan J. McFarlane"
<alanjmcf@.yahoo.com.INVALID> wrote:

>Sue Hoegemeier <Sue_H@.nomail.please> wrote:
>I'm no expert in SQL/MSDE, far from it. But from what I've (remembered of
>what) I've read, I thought the login audit logging only went to file
>LOGS\ERRORLOG and not to the Event Log.
>Anyway that's the behaviour I see here: AuditLevel=3 and I get entries in
>the ERRORLOG but nothing apparent in the Event Log. I'm not using SQL
>authentication so the entries are of the form:
> 2004-03-19 21:39:25.81 logon Login succeeded for user 'DOM\usr'.
>Connection: Trusted.
>and if I try sa not using the correct password I get:
> 2004-03-23 16:33:57.51 logon Login failed for user 'sa'.
>I may well be wrong on the non logging to the Event Log...but check the
>contents of ERRORLOG anyway to see if the logging is occuring there.
>
>Or maybe that has solved it already...|||Sue Hoegemeier <Sue_H@.nomail.please> wrote:
> Anon restarted SQL Server after making the changes which
> solved the problem.
> Logging to the Windows event log is enabled by default for
> SQL Server. The auditing is logged to the SQL Server error
> log and the Windows Application event log if you haven't
> changed the default settings. You can find more information
> on this in books online under startup options.
>
Ah ha, shows that I truly don't know much on this subject.
Interestingly my MSDE appears to be started with -sINSTANCE
and -d... -e... -l..., but no -n, hmm. I think I better talk to the folks
who created the installer for it, to see what odd way they have configured
it...
--
Alan J. McFarlane
http://homepage.ntlworld.com/alanjmcf/
Please follow-up in the newsgroup for the benefit of all.|||One other thought...are any events from anything being
logged to your application event log? Could be that your log
has a max size with no overwriting and it is filled up. You
could try manually clearing the log and see if that makes a
difference as well.
-Sue
On Wed, 24 Mar 2004 11:59:17 -0000, "Alan J. McFarlane"
<alanjmcf@.yahoo.com.INVALID> wrote:

>Sue Hoegemeier <Sue_H@.nomail.please> wrote:
>Ah ha, shows that I truly don't know much on this subject.
>Interestingly my MSDE appears to be started with -sINSTANCE
>and -d... -e... -l..., but no -n, hmm. I think I better talk to the folks
>who created the installer for it, to see what odd way they have configured
>it...|||Sue Hoegemeier <Sue_H@.nomail.please> wrote:
> On Tue, 23 Mar 2004 16:44:50 -0000, "Alan J. McFarlane"
> <alanjmcf@.yahoo.com.INVALID> wrote:
I've had a look back through the documents I had read, to see what gave me
this impression.
In http://msdn.microsoft.com/library/e.../SecNetch13.asp
there is no mention of the logging going to the Event Log, only to "SQL log
files". That would be it...
Note, I can see nowhere in the SQL documentation that describes how to set
AuditLevel in the Registry. People will continue to be drawn to that .Net
page to learn how to enable login auditing without using Enterprise Manager
and without working out what SQL-DMO is and how to use it
For instance the only mention of "AuditLevel" in the 'Books Online' index is
a page in the SQL-DMO section.
> Anon restarted SQL Server after making the changes which
> solved the problem.
> Logging to the Windows event log is enabled by default for
> SQL Server. The auditing is logged to the SQL Server error
> log and the Windows Application event log if you haven't
> changed the default settings. You can find more information
> on this in books online under startup options.
>
--
Alan J. McFarlane
http://homepage.ntlworld.com/alanjmcf/
Please follow-up in the newsgroup for the benefit of all.

error message not being logged to windows event log

Hi,
I am trying to get a message (#18453 - Login succeeded for use '%ls%'. Conn
ection: Trusted) to the windows event log. It's severity is 14 and it is al
ready checked off as a logged event, but it is not being logged. Is this a
bug or is there something e
lse I need to configure?
Regards
AThe login messages are (for some reason) handles differently from the other
messages. EM, right-click your server, properties, Security tab.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:4669ADC2-F0E4-48B5-BC66-77F95B76CEBE@.microsoft.com...
> Hi,
> I am trying to get a message (#18453 - Login succeeded for use '%ls%'.
Connection: Trusted) to the windows event log. It's severity is 14 and it
is already checked off as a logged event, but it is not being logged. Is
this a bug or is there something else I need to configure?
> Regards
> A
>|||Tibor,
I don't quite understand what you're saying. I have located the error messa
ge by right clicking on the server, choosing Manage SQL Server Messages, the
n to the Edit Message window, and the option to Always write to Windows even
tlog is checked on. But st
ill, it is not being recorded in the event log when I log on through Query A
nalyzer for example.
Regards,
A|||Tibor is saying that there is a different mechanism to have logins logged to
the eventlog. Checking the box in Manage SQL Server Messages does NOT work.
You have to use Enterprise Manager, right click your server, choose
Properties, and then go to the Securities Tab. There you will see a radio
button under Audit Level; you can choose one of the following:
None
Success
Failure
All
If you choose "Success" you will get a message in the Eventlog for every
successful login.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"anon" <anonymous@.discussions.microsoft.com> wrote in message
news:7224910B-6005-43B3-9B18-019809B4697F@.microsoft.com...
> Tibor,
> I don't quite understand what you're saying. I have located the error
message by right clicking on the server, choosing Manage SQL Server
Messages, then to the Edit Message window, and the option to Always write to
Windows eventlog is checked on. But still, it is not being recorded in the
event log when I log on through Query Analyzer for example.
> Regards,
> A
>|||Thank you Kalen. It's now working.

Error message in the log file

Every night I get the following error message in the SQL log file
Error: 7105, Severity: 22, State: 6
Page (1:2021785), slot 1 for text, ntext, or image node does not exist..
I get it 10 times between 04:00:05 and 04:03:30 and also at random during
daytime.
I want to know what causes the error so I have tried capturing almost
everything going on on the server through profiler but nothing seems togo on
in the database when the error message occurs.
There are no scheduled jobs on the server at between 03.30 and 04.30.
The server is running SQL 2000 sp 3.
I am now looking for all kind of hints that can help me find what is causing
the error, so all thoughts and ideas are welcome.
/Jaana> Every night I get the following error message in the SQL log file
> Error: 7105, Severity: 22, State: 6
> Page (1:2021785), slot 1 for text, ntext, or image node does not exist..
> I get it 10 times between 04:00:05 and 04:03:30 and also at random during
> daytime.
Have you tried running DBCC CHECKDB?
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
The reply is from MS (Took it from old posting from groups)
" This problem might be caused if the application's distributed transaction
timeout causes the DTC manager to abort the transaction.
To work around the problem, eliminate the cause of the timeouts or
increase the timeout value.
In addition, could you please check what operation resulted in the error?
Was there the 'select' statement using nolock hint or tablock hint? "
Thanks
Hari
MCDBA
"Jaana" <jaana.lehtonen@.banverket.se> wrote in message
news:#tvANZE$DHA.3668@.TK2MSFTNGP09.phx.gbl...
> Every night I get the following error message in the SQL log file
> Error: 7105, Severity: 22, State: 6
> Page (1:2021785), slot 1 for text, ntext, or image node does not exist..
> I get it 10 times between 04:00:05 and 04:03:30 and also at random during
> daytime.
> I want to know what causes the error so I have tried capturing almost
> everything going on on the server through profiler but nothing seems togo
on
> in the database when the error message occurs.
> There are no scheduled jobs on the server at between 03.30 and 04.30.
> The server is running SQL 2000 sp 3.
> I am now looking for all kind of hints that can help me find what is
causing
> the error, so all thoughts and ideas are welcome.
> /Jaana
>
>