.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

WMI Event Watcher on a Clustered SQL Server

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

I have an SSIS package that uses the WMI Event Watcher task to watch the file system for a file to be dropped into a directory. When the file is dropped in the package processes that file.

This all worked well in dev and test. But when I move to production I have a problem. My produciton server is a cluster. I am attempting to watch a directory on a cluster drive. However, I am unable to get events triggered off that drive. THere are no errors the package starts up OK but when I drop a file into the watch directory nothing happens. If I configure the package to watch the C drive it works fine. So I am pretty sure something is different when watching a cluster drive.

The server is SQL 2008 on Windows Server 2008 R2 64-bit.

Here is my connection: \\servername Namespace: \root\cimv2

Here is my query: SELECT * FROM __instancecreationevent WITHIN 10 WHERE TargetInstance ISA 'Cim_DirectoryContainsFile' AND TargetInstance.GroupComponent='Win32_Directory.Name=V:\\\\FileTransfer'

Does anyone know what I should be doing differently?

Thanks in advance.

View Complete Post

More Related Resource Links

Team System: Team Foundation Server Event Service


Use the Team Foundation Server EventService to create and manage event subscriptions or create a Web service to receive and process events.

Brian A. Randell

MSDN Magazine May 2008

Closing Javascript Modal dialog window after server side event processing


Hello Friends..

Please tell me how to close Javascript ModelDoalog Window.. after Server Side event Processing .

Basically i want close window in  finally Block After sucessfulll Updation.

AMit..... InnocentInnocentInnocentInnocentInnocentInnocentInnocent

Triggering an event to occur within a VB.NET app if something is inserted into an SQL Server table

Let's say SQL Server is inserting arow within a table. Is there a way to let VB.NET know that an event was fired (being the inserting of the row within the table), without the need to query anything. Bascially having SQL Server tell the VB.NET app that an event was fired. It seems like it might be possible using CLR and the .NET framework integration wthin SQL Server, but I haven't found a sample program showing what I'm attempting. I understand that this topic covers SQL Server and VB.NET.  This need being for both and this forum only set for SQL Server, I thought I'd take the risk and post in this forum. Thank you in advance for any assistance.Newbie

Event 2436 - old application server cannote be crawled

DISCLAIMER:  I'm not a sharepoint admin...I inherited this after the former admin left...so be gentle. BACKGROUND:  We replaced at some point the original "application server" with a new one.  The old was called "fwmspapp" and the new is "fwmspapl"   I'm getting the following errors in the event logs on the new application server: Event Type: Warning Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2436 Date: 8/30/2010 Time: 9:50:03 AM User: N/A Computer: FWMSPAPL Description: The start address <sts3://fwmspapp:8270/contentdbid={083c7ae0-bc68-405e-a5e8-12eae72f1718}> cannot be crawled. Context: Application 'Search index file on the search server', Catalog 'Search' Details: The crawler could not communicate with the server. Check that the server is available and that the firewall access is configured correctly. (0x80041200) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Followed by:   Event Type: Error Event Source: Windows SharePoint Services 3 Search Event Category: Gatherer Event ID: 2424 Date: 8/30/2010 Time: 9:50:03 AM User: N/A Computer: FWMSPAPL Description: The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again. Context: Application 'Search'

get url from server and fire event

i want to open new window ,but i dont want to provide url link in script because i want to hide this link from user.so is there any method to get URL from server and fire event to open new window after cliking button which has some server logic on that basis serever return URL. 

SQL Server Event ID 17052: SQLServerAgent has terminated unexpectedly.

Hello All,       We are getting EventID17052 in one of our production server from last 3 months. SQL Server Agent is restarting on its own. As per threads about same issue I dig into the Jobs and processes running at that time in Server and I have found one job is causing this issue and Agent crash is happening same time that job is scheduled but not everyday. Server is running with SQL Server 2005 SP2 (Microsoft SQL Server 2005 - 9.00.3042.00 (X64)   Feb 10 2007 00:59:02   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition (64-bit) on Windows NT 6.0 (Build 6001: Service Pack 1) ).  Please let me  know is there any fix for this error and also let me know SP3 upgrade to SQL Server 2005 will help for it or not? I am also providing full error details from event viewer. The description for Event ID 17052 from source MSSQLSERVER cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer. If the event originated on another computer, the display information had to be saved with the event. The following information was included with the event: SQLServerAgent Monitor: SQLServerAgent has terminated unexpectedly. the message resource is present but the message is not found in t

not able to write log messages in event log on windows 2008 server

Hi, I am trying to write in Event Log on windows 2008 server with a windows service application. But I got this error: Service cannot be started. System.ComponentModel.Win32Exception: The parameter is incorrect at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type) at Siemens.SHS.Utilities.Common.LogManager.LogToEvent(String pLogName, String pSource, String logEntry, EventLogEntryType type) at Siemens.SHS.PEP.TaskCore.StartTask(String pPluginFilePath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.RecurseStart(String pPluginPath) at Siemens.SHS.PEP.TaskCore.StartTasks() at Siemens.SHS.PEP.PlugnExecute.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)How can I write to Event Log on x64 platform as Windows 2008 server?Any help appreciated, thanks in advance,Cigdem

Oracle clustered table to MS SQL Server 05 SSIS

Hi Guys, Can the SSIS deal with clustered Oracle tables? Moreoever, what are clustered tables compared to partitioned tables? I cant find much about it. (only sytax how to create them). Thanks, metalray

The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. S

Hello, I have a node of 2 servers of Win 2008 R2 Enterprise and trying to install a 2nd instance in a SQL 2008 R2 Cluster. I had SQL_INSTANCE2 previously installed that I removed from the two nodes. Now when I attempt to install it again from scratch, in setup GUI where I specify the SQL Server Network Name and enter the previously entered name "Server02", I get a failure in the setup with the following error message: "The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. Specify a different failover cluster instance name." How do I fix this problem, I don't want to enter a new name like "Server03" in order to proceed with the setup, because when I do enter "Server03" the setup does continue without an error message. So what am I missing? Do I have to ask the DNS administrator to see if there's an A record for "Server03" and have him delete it so that the setup works? Or the fix is by doing something else? I would appreciate any help. Thank you  

Can't remove instance from clustered server

Hi ,

I'm using SQL Server 2008 and I have on Active-Active Cluster on
a Windows Server2008.

I have one SQL instance on that Server. The other node I had SSAs wich I want to uninstall and be with another instance of SQL.
I had SSIS has a clsutered here also.

I unistalled the SSAS and made Prepare SQL to Cluster intallation on Node 1 (that already had one SQL instance).

When I tried to Complete the SQL Failover clustered installation I cannot reach the instance and after a few atteps I cannot connect with SSIS on this clustered.

I cannot remove the SQL instance from ADD/Remove Programs because it gives me the error that this instance is used has a cluster.

So this is what I want to do:

-Remove the instancethat says that is clustered but I can't see the cluster on Failover Clustered Administration.
-Setup SSIS as a clustered service on the instance that was previous installed(I can reach the SSIS editing SQL Agent Job but I can't connect through Database Engine.Through the Agent all the packages are unreacheable but visible.)

I already See that I can't add features to a clustered installation but I read that it's possible to Add SSis if I stop both nodes. How can I stop both nodes to install SSIS.

Event receiver deployment on remote server


I have created an EventReceiver using visual studio 2010. Tested on test server and it works ok.

Now I have tried to deploy to production server. Created package.wsp and deployed on the site.

I might add that I can see in the Central Administration / Solution Management that solution is deployed.

After that I have activated feature. All went OK. But the custom validation in the receiver does not work. It looks like its not deployed well.

Is there enything that should be done to activate EventReceiver on remote server?


Does SQL Server has the similar function just like Trace Event 10104 for hash join in Oracle?


My question is  how can SQL server display the  information about the buckets when doing the hash join just like the function of Trace Event 10104 in Oracle.By the way ,In Oracle ,the Event 10104 event dumps hash join statistics .
The buckets message what i needed is similar as the following,that is to say ,it must contains the information about buckets .
01 ### Hash table ### 
02 # NOTE: The calculated number of rows in non-empty buckets may be smaller 
03 # than the true number. 
04 Number of buckets with 0 rows: 16373 
05 Number of buckets with 1 rows: 0 
06 Number of buckets with 2 rows: 0 
07 Number of buckets with 3 rows: 1

dont show JS hidden row after server event fired


Hi all,

i designed a gridview named outergrid and within that GV i designed a innerGrid, when the user click on expand button from the outergrid then the inner grid have to show. Now im doing some row filter works using JS, let us assume i have 5 rows in outergrid after filtered first 2 rows will be hiden so now 3 rows displaying, when user clicks on the expand button then im calling RowCommand Event of outergrid now the child grid has populated but the problem is 2 hiden rows(on outergrid) are now visible, how to make these hiden rows not to show while populate innergrid.

Changing Clustered SQL Server 2005 Default Server Collation


We are attempting to change the default collation of an SQL Server 2005 Clustered environment. We have created an "unattended install" script to perform this, and have modified it several times as errors have arisen repeatedly. The last time, however, we used the following script:


We are running this script from the primary (Active) node of the cluster. We did notice that the bootstrap logs created from this final execution did include logs from both nodes. When I look in the Summary.txt file, it tells me that Setup succeeded with the installation. After the script executed, we rolled the cluster from primary to secondary, and rebooted the primary node. We then rolled the cluster back to the primary, and rebooted the secondary node. Once that was complete, we cycled the SQL Server service from the SQL Configuration Manager. After all those steps, we opened SSMS client to look at the properties of master, and the collation was still CI_AI.

We are losing valuable time in

Office.sharPoint.Server Event ID: 6482 Could not load file or Assembly


Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server Shared Services
Event ID: 6483
Date:  4/16/2009
Time:  2:41:10 PM
User:  N/A
Computer: JPFS02
Application synchronization failed for Microsoft.Office.Server.Administration.UserProfileService.

Reason: Could not load file or assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

Techinal Support Details:
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.Server.Search, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c'
   at Microsoft.Office.Server.UserProfiles.SRPSite.SynchronizeManagedPropertyMappings()
   at Microsoft.Office.Server.UserProfiles.SRPSite._Init(ServerContext serverContext)
   at Microsoft.Office.Server.UserProfiles.SRPSite..ctor(ServerContext serverContext)
   at Microsoft.Office.Server.Administration.UserProfileApplication.get_ProfileSiteCache()
   at Microsoft.Office.Server.Administration.UserProfileApplication.Synchronize()<

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

SQL Server does not detect new clustered SAN Drive


I just joined this organization as a SQL Developer/DBA and manage some of the servers there. One of the applications has a dedicated Win 2003 server for Production running SQL Server 2005 on an Active/Passive Cluster. We requested the storage team for a new SAN Drive be included to the existing cluster so that the daily backups be routed to that Drive (G:) allowing the application enough space on the Data Drive (E:).

The storage team successfully assigned the new SAN Drive to both the clusters after a re-scan. The new drive was available to the OS either to the Active Node (Node 1) or to the Passive Node (Node 2) after failover. But somehow, SQL Server does not recognize this drive as part of its resources and so I am not able to route my backups to the new drive (G :).

Below are the configurations of the cluster.

The server has three Groups in Cluster Administrator as Cluster Group. Group 0 and Group 1.

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