SQL Server Performance

Generic Script Resource

Discussion in 'SQL Server 2005 Clustering' started by gujsa01, Jan 29, 2008.

  1. gujsa01 New Member

    Hi,

    We have a Health Care app that is installed on SQL Server 2005 EE 654 bit Cluster with Windows 2003 R2 64bit. This app doesn't reconnect users upon failover. As a result I would like to use the "Generic Script" resource which will call a Windows Script Host script and reset our IIS server.
    I followed the following link: http://msdn2.microsoft.com/en-us/library/aa369319(VS.85).aspx
    I'm using VBScript option within and to test out I added the following script:
    Set ss = CreateObject("WScript.Shell")
    ss.run "NOTEPAD.EXE",1
    If I run this of a command prompt on each node, this just works fine, but If I were to embedd this in the Generic Script resource using wscript <script name>, the following error message pops:
    "An Error occured attempting to set the properties. The filename, directory name or volume label syntax is incorrect"
    Appreciate any help on this.

    Thanks
  2. satya Moderator

    I don't see its a SQL related problem and have you checked under VS 2005 based forums in thsi regard.

Share This Page