View Complete Post
Could some one let me know why the following error is happening and resolution for this. This problem exists in SQL Server 2005 which has specific hotfix. But we are currently using SQL Server 2008. Following are the error details,
LogName : Application
Source : SQLSERVERAGENT
Event ID : 318
Level : Error
Task Category : Alert Engine
Message : Unable to read local eventlog (reason: The event log file has changed between read operations).
Note: Immediately after this error there is a Warning message saying "Successfully re-opened the local eventlog - NOTE: Some events may have been missed."
We didn't face this problem before but suddenly we are seeing this issue quite often on some of our SQL Instances.
Until recently this worked ok, however now on one of the 2 nodes if I fail over SQL all of the services start, on the other node, Sql Server Agent & Analysis Services will not come on line. I have checked some of the other links suggestiing fixes but
they dont seem to apply. On the Node where it fails you get an error 53 for the server agent the Analysis Services fails with Generic service 'Analysis Services' could not be brought online (with error '1060') during an attempt to open the service. Possible
causes include: the service is either not installed or the specified service name is invalid.
attached is the details from the Sql Log
2011-04-06 13:13:32.05 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )
2011-04-06 13:13:32.05 Server (c) Microsoft Corporation.
2011-04-06 13:13:32.05 Server All rights reserved.
2011-04-06 13:13:32.05 Server Server process ID is 4744.
2011-04-06 13:13:32.05 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R610'.
I just implemented basic URL rewriting to change a page from, for example, /member.aspx?id=123 to /member.aspx/erik. That works and I'm happy with it. However, I am now getting an error message that states "the connectionstring property has not been initialized". Normally, I've been storing the connectionstring in web.config, and I access it with:
Dim Connect As SqlConnection = New SqlConnectionDim ConnectString As StringConnectString = ConfigurationManager.AppSettings("linktomysite")Connect.ConnectionString = ConnectStringConnect.Open()
This is what I do on every other page of the site and it works fine. The only way it will work on the page where I'm URL re-writing, however, is if I replace "ConfigurationManager.AppSettings("linktomysite")" with the actual connection string itself. For security reasons, obviously I would prefer to keep that info out of the page. What can I do?
Hi ! I have scheduled a job in sql server 2008 to send birthday e-mails. I run the script and it looks wroking but in agent schedule it doesn't. I am getting the below error; what is the problem?
Now I know that I won't be sending viewstate and eventvalidation in my ajax calls and that I will only want to send the actual form fields for efficiency purposes but I will need to know the answer to this question, to inform the more junior members of the team and my manager, so if anyone has any answers they are most welcome.
I have a simple form as follows
<form id="form1" runat="server"> <p>Field1: <