.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Effect of error logs

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hi, I just came across a situtation where one of my application is trying to connect SQL box and is failing because of permission. It is writing audit failure to the Error log file. Can anyone please explain what would be the effect of this continous writing to error log. Does it affect performance of SQL Server in any ways or if there is a way i can check.Regards, Deven ----------------------------------------- Please vote if you find any of my post helpful.

View Complete Post

More Related Resource Links

SQL Server 2008 R2 management studio throws an error when opening SQL Server Logs node

Hi all, I've installed SQL Server 2008 SP1 CU9 developer edition and SQL Server 2008 R2 Express side by side on my machine. When I try to open/expand SQL server logs node under Management on developer edition instance, I get the following error message: ********************************************************************************** TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ A severe error occurred on the current command.  The results, if any, should be discarded. (Microsoft SQL Server, Error: 0) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2789&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476 ********************************************************************************** The SQL Server Management Studio version is 10.50.1600.1 SQL Server 2008 SP1 CU9 version: 10.0.2789.0 SQL Server 2008 R2 express edition version: 10.50.1600.1 RTM   I don't get that error when expanding SQL Server Lo

Excel Services no refresh data & no error logs

Hi! I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs. Notice that if I try to refresh the workbook in Office Excel all works fine! I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result! The procedure I follow is: 1) create a new Excel file and create new data connection to the database (SQL Server 2008) 2) upload the file in the trusted file location 3) open the file in a web part and click on the "refresh all" button I used the same unattended account which I setup for this purpose with BCS and it works fine! I also try to set with PowerShell the Application ID created ("ES"): "set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES" with no result. I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem? I also tried to delete / re-create the application but the two IDs remains disequal! Have someone of you already worked with Excel Services and could give me any help? Thanx in advance, Elena

Microsoft .NET Framework NGEN v4.0.30319_X86 not started error in server logs.

Not sure what the correct etiquit is for this. The thread I asked my question in last Friday was previously closed by a moderator, and I suspect that is why it's not getting answered.  Since I posted, there have been enough other people with the same issue posting to push it into the popular thread list. So I'm starting a new thread.  (Not sure what would be a better procedure.) Original thread is here: http://social.msdn.microsoft.com/Forums/en-US/netfxsetup/thread/4cb39c00-b038-45b2-bf38-2016a906570e Here was my question: This service was installed in a recent auto update on my SBS 2003 server and it was installed with automatic startup.  But it just starts up and shuts right back down.  The same occurs on my XP dev machines. Because of that my daily server report is showing: Auto-started Services Not Running Service Name Microsoft .NET Framework NGEN v4.0.30319_X86 Total auto-started services not running: 1 In normal conditions, these services should be running. For details, it is recommended that you review errors in the Event log related to the service.   It's a annoyance to have that in the daily server reports.  (I want to see all green items) Since starting up and immediately shutting down, appears to be the normal behavior for this service. (That's also what it does on XP. And the .net 4 full installation verifies as being

Database Mail Error Logs


I am New To Work With C#.I need To Retrieve The All Error Log In SQL Server.I Had Done All The Logs Except Database Mail Error Log. I need an An Help for How To Retrieving The Database Mail Error Log through C# Coding.



Catastrophic failure Error - Correlation ID not found in ULS logs


Hi all

I'm having a problem in sharepoint when trying to create a new site from a custom template - I am getting the below error:

Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))


Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: [long hex code]


However when I look in the ULS logs there is no mention of this correlation ID. I have turned the logs up to Verbose on everything, then reproduced the error, and still I can't find the error. Is it possible that this error is coming from another subsystem like ASP or IIS? I have looked in the IIS logs and can find the HTTP requests but nothing to do with why the error occurs.

Any help would be appreciated - I feel like if I could find the correlation ID I could at least start to work out what the error is!

Many thanks


Getting an error while restoring logs in LOG SHIPPING environment



I'm working with SQL SERVER 2005 SP2.

I have a working and a steady environment of LOG SHIPPING for quite a while.

Yesterday, the Restore job of the LOG SHIPPING in the DR server failed with the locking error (the log starts from the last line and goes up):

05:02:38.34  *** Error: The log backup file 'C:\database\LogShipping\20100927021501.trn' was verified but could not be applied to secondary database ''
05:02:37.42  *** Error

how to track errors or logs if getting error on SSIS Package deployement


Is there any way using which i can trace error if getting difficulty in deploying SSIS Package. doest it generates any log , plz assist 

Thanks in advance,

Amitesh Srivastva

error in sql logs



    i see error in sql server logs which says

Login failed for user 'domain\user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors.

any suggestions


Problem Analysing SSRS 2008 R2 Error Logs



I have a very simple SSRS 2008 R2 report in Sharepoint 2010 with embedded data source and data set connections. When I edited the deployed report within Report Builder 3.0 launched within Sharepoint 2010.
2.4.2) The query executed fine within the data set component of this report returning data.
2.4.3) On clicking on the run button I get the following error; -
"For more information about this error navigate to the report server on the local server machine, or enable remote errors
Log on failed. Ensure the user name and password are correct. (rsLogonFailed)
The report server has encountered a configuration error. Logon failed for the unattended execution account. (rsServerConfigurationError)"

I have been viewing the Execution log as follows; -

SELECT * FROM ReportServer.Dbo.ExecutionLogStorage ORDER BY LogEntryID DESC

I understand that I should get more information from; -

C:\Program Files\Microsoft SQL Server\MSRS10_50.<my instance name>\Reporting Services\logFiles\<today's log file>

But I don't know what my search criteria within this log file is. Can any body help?

I am currently looking at; - http://technet.micros

IsapiModule Error 500 Issue


I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:


CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"


Handling 404 page not found with Error page



      How do i handle 404 page not found?

Inserting personal error message in ValidationSummary



I am creating a web form that requires a lot of validation. I use many of the validation control in asp.net already like RequiredFieldValidator and CompareValidator. 

My Problem: after my custom validation for the value entered return an error message, and I pressed enter key when the field is empty, my custom error message is overlapped by my ValidationSummary. 

Setting my custom error to visible = false on button click also does not seem to work as it requires for me to enter the value first.

This made me think, is there a way to insert my custom validation inside the ValidationSummary as an error message like for other validation control?

Thanks in advance

Sys.Net.WebServiceFailedException: The server method '' failed with the following error:



Let's say we have 2 time consuming functions, aaa and aaa1 inside a aspx page.

        public static string aaa(int i)
            return i.ToString();

        public static string aaa1(int i)
            return i.ToString();



        <asp:ScriptManager ID="ScriptManager1" runat="server" EnablePageMethods="true">
        <span id="displayspan"></span>
        <br />
        <input type="button" value=

animate effect work but the render items are messed up.


Hi all,

     I have a very unique problem, humm i think. I am using a jquery effect that animate bounce effect, i have a line in my javascript pageLoad function $("#UserBrowserInfoDIV").show('bounce'); - the effects run smoothly but what it does is mess up the bolded text in the div. I have try the items inside the div without bolding and it works fine and no render problem but when bolded the text that are bolded is quite messed up, and barely readable.

Please let me know is there anything else i can do i really would like use this effect.

P.S all the effect have the same render problem, and i am using ie8 under compatibility mode.





Jscript error: Object does not support property or method


 Hi, i have little knowledge on javascript but i need to use this code get from somewhere for a jquery to work.

I face this "Jscript runtime error: Object does not support property or method" whenever im trying to run this page.

In my experience, im get this error msg 9 out of 10 times i use javascript in my system.

Im using Microsoft Visual web developer 2008, i wonder if this is related to my problem, i not sure there is anything i need to add as reference or update anything.

But anyway, in short, i just couldn't use javascript code when using this development tool because of this sort of error.

Anyway, it happen that last time i tried use the same type of jquery code in another project and it seems to work well without an error.

But now when im try to use it again in this recent project i created, it come out with this error and i have no idea how to solve it even look through google and this forum.

It doesn't really seems like its the code problem itself although im not sure, because any javascript code just couldn't work.

So below is my code that i need to use.

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" ></script>
<script type="text/javascript" src=&quo

Type or namespace error.


A couple of days ago I started getting an unusual behavior when compiling Website projects. I have referenced class libraries added to my bin folder that are also correctely referenced in using statements in my aspx.cs code behind. When I compile, I get the 

Error 4 The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?) C:\Dev\Fiscal_Portal\Implementation\FMS Portal Site_new\App_Code\BLL\DataTables.cs 1 7 C:\...\FMS Portal Site_new\

The type or namespace name 'CommonClassLibrary' could not be found (are you missing a using directive or an assembly reference?)

error message that would typically be received when the dll has not been added as a reference or added in a using statement.

I can eliminate the error by adding an


HTTP Error 403 - Forbidden


(VB Express website directed me to ASP.NET Web Services which in turn redirected me to this forum).

 Hopefully someone can help me here...... 

I am using VIsual Web Developer and downloaded the small business application to use as a starting point to help my wife get a website up for her small business. When I load the application, I can F5 and it runs fine but as soon as I make any modification to the app and hit F5, I get the HTTP Error 403 - Forbidden when it tries to show the website.

I notice a pop up that occurs when I run that allows me to choose the link for my app and it displays correctly (I close the webpage that has the error on it).

This seems like a pain, is there a setting I'm missing - I would think that this should "just work".

What's up?????



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend