.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

Databasemail error in clustered environment

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi. I'm having trouble getting DBmail to work on a SQL 2005 SP3 STD. (64-bit) installation. I've setup database mail with the wizard. I've tested sending an e-mail using telnet -> OK!   But when I try to send a test e-mail from the sql server management studio I the message is queued, and the Windows Event Viewer logs an error like this: *************************************** Event Type: Error Event Source: DatabaseMail Event Category: None Event ID: 0 Date:  27-08-2010 Time:  10:01:23 User:  N/A Computer: <My_servername> Description: 1) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException Message: There was an error on the connection. Reason: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified), connection parameters: Server Name: <My_servername>\<My_named_instance>, Database Name: msdb Data: System.Collections.ListDictionaryInternal TargetSite: Void OpenConnection(Microsoft.SqlServer.Management.Common.SqlConnectionInfo) HelpLink: NULL

View Complete Post

More Related Resource Links

Invalid object error on temp table on a particular environment

Hi, I am using a temp table in my sp. I have written the following tsql before and after using the temp table. IF OBJECT_ID('tempdb..##TEMP') IS NOT NULL DROP TABLE tempdb..##TEMP; Data will be inserted to the temp table consecutively using a cursor. I use SELECT * INTO tempdb..##TEMP FROM EXEC('query') to fill this temp table for the first time and INSERT INTO tempdb..##TEMP(<fields>) EXEC('query') for the remaining times. The SP is working fine in my laptop, but I am getting an Invalid Object error on this temp table name in the production server. Could anyone tell me the possible causes please? Thanks Sree

AjaxToolkit's CascadingDropDown control is throwing Method Error 404 in Hybrid system environment (

Hi Experts, We have an Asp.net web application, which is deployed in shared hosting environment. On shared hosting environment initial request to this web application is handled by Linux server and then based on the requested page the Linux server is redirecting request to web server on windows OS. Now, in our web application, we have used ajaxToolkit's CascadingDropDown control to populate three levels of categories. In the hybrid system described above, the CascadingDropDown control is throwing Method Error 404. I would appreciate if some body can guide on how to resolve this issue. The sample of code snap shot is mentioned below. ********************************************************************* Aspx file. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ <asp:DropDownList ID="ddlMajorLevelCategory" runat="server" Width="250px" ToolTip="Select Major Level Category" TabIndex="1"                            SkinID="h6BlueArial"> </asp:DropDownList>   <ajaxToolkit:CascadingDropDown ID="ccMajorCategory" runat="server" TargetControlID="ddlMajorLevelCategory" Category="M" PromptText=&qu

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

Unknown error - Site usage reports not displaying - 2007 environment


Please can you help out in this issue as this is something critical.  Thanks much in advance.


when user clicks site usage reports (site actions > site settings) displays error as unknown error, and user is admin for the site.


This is on particular site. This problem is only for one user and rest of the users able to get the reports when hits on site usage reports.


I have checked with user . he is getting same problem on other browsers as well.


as pat of investigation we have migrated this site to other environment and asked user to che

Upgrading clustered environment from sql 2005 to 2008




Can any one give me the best approach to upgrade a 4 node (a/a/a/p) clustered environment from sql 2005 on win server 2003  to sql 2008 on win server 2008 with minimum downtime.




The action 'Move to node SQLN1' did not complete. An error occured moving the clustered service or


Hello All,

We have two nodes clustered 2008 SQL server running 5 instances (one default instance and the rest named instances). The default instance failed over to node 2 and now I cannot fail it back to node 1 and keep getting the following error when I try to move the instance I get the following error in Failover Cluster Managemen:

" The action 'Move to node SQLNV1' did not complete. An error occurred moving the clustered services or application 'SQL Server (MSSQLSERVER)'. the operation failed because either the specified cluster node is not the owner of the group, or the node is not possible owner of the group"

Thanks in advance!



Error installing SP3 on sql 2005 Clustered Server


Hi, all.

Another sp3 installation problem. It is at least the 3rd in 2 years....

here is a portion of the installation Log.....

Can you help me?


=== Verbose logging started: 30/11/2010  23.37.37  Build type: SHIP UNICODE 3.01.4000.4042  Calling process: C:\UpdateTemp\hotfix.exe ===

MSI (c) (EC:8C) [23:37:37:461]: Resetting cached policy values

MSI (c) (EC:8C) [23:37:37:461]: Machine policy value 'Debug' is 0

MSI (c) (EC:8C) [23:37:37:461]: ******* RunEngine:

           ******* Product: {4B405911-A450-49CC-B755-399D8193EF0C}

           ******* Action: 

           ******* CommandLine: **********

MSI (c) (EC:8C) [23:37:37:461]: Client-side and UI is none or basic: Running entire install on the server.

MSI (c) (EC:8C) [23:37:37:461]: Grabbed execution mutex.

MSI (c) (EC:8C) [23:37:37:476]: Cloaking enabled.

MSI (c) (EC:8C) [23:37:37:476]: Attempting to enable all disabled priveleges before calling Install on Server

MSI (c) (EC:8C) [23:37:37:476]: Incrementing counter to disable shutdown. Counter after increment: 0

MSI (s) (20:00) [23:37:37:492]: Grabbed execution mutex.

MSI (s) (20:5C) [23:37:37:492]: Resetting cached policy value

Invalid Template error after deploying site definition to different environment



I have developed a custom site definition with some custom features and web parts.All Works fine in my development environment i.e site is being created with necessary features and lists. But when I copy the respective files and folders to Production environment and installed my custom features and also run the IISRESET command and click on Create button by selecting my site definition in template section, its giving "The template you have chosen is invalid or cannot be found" error. But a few days prior I have deployed a initial version of the same site definition with same features and every thing had worked fine. I am going crazy of this absurd behavior of SharePoint.its really annoying as it accepts the same definition a few days prior and gives unfriendly error afterwards. If anybody had solved this issue please share it to me to get out of this.



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=

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?????



Webmatrix error


When i try to do anything in webmatrix it shuts down.   i get this error in the log

pplication: WebMatrix.exe
Framework Version: v4.0.30319
Description: The application requested process termination through System.Environment.FailFast(string message).
Message: Unrecoverable system error.
   at System.Environment.FailFast(System.String)
   at MS.Internal.Invariant.FailFast(System.String, System.String)

Insert Error not helpful



I am using VS2010

When I try to updated or insert a record in my User table I am getting an error that does not make sense to me and I cannot figure out what is wrong.

Also, when I try to insert a new record I get a validation error saying that the Id is required. However it is an identity field in the db so it should not be necessary to send it to the server.

Could you please shed some light?


An error has occurred.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Web.UI.WebControls.EntityOperationException: An error has occurred.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. 

Stack Trace:

[EntityOperationException: An error has occurred.]
   Microsoft.Web.UI.WebControls.DomainDataSourceView.PerformCudOperation(ChangeSetEntry operation, Action`1 operationPerformingEvent, Action`1 operationPerformedEvent) +331
   Microsoft.Web.UI.WebControls.DomainDataSourceView.UpdateObject(Object oldEntity, O

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