Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Agent Doesn't like Scripts?

Author  Topic 

fhtapia
Starting Member

9 Posts

Posted - 2005-08-10 : 02:52:29
I have a simple activeX script that writes to a file on another server, my previous box was windows 2000 std server and that's where this script came from. The new windows 2003 server has the same domain administrator starting the sql and agent service, but I continue to get the following error "cannot be run because the ActiveScripting subsystem failed to load. The job has been suspended"

If I create a DTS job, then the dts package runs, but I still cannot schedule it as I continue getting the error listed above. If I run the activex script from a .vbs it runs fine.

What new security restrictions does win2k3 have?

sukanthig
Starting Member

1 Post

Posted - 2006-01-03 : 15:27:57
Did you get it fixed? Can you give me details on the fix? Thanks.
Go to Top of Page

fhtapia
Starting Member

9 Posts

Posted - 2006-01-03 : 17:27:28
I have scheduled with my Boss a day where I'm going to call Microsoft in order to fix this problem. Of course I will post the results from that.
Go to Top of Page

DanVurich
Starting Member

1 Post

Posted - 2006-01-30 : 13:02:58
Check this in the Registry:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup]
"SQLPath"="C:\\Program Files\\Microsoft SQL Server\\80\\Tools"

In some cases the "s" at the end is missing. Microsoft says that it happens, occasionally, during the upgrade of an MSDE instance.
Go to Top of Page

fhtapia
Starting Member

9 Posts

Posted - 2006-01-30 : 14:14:06
Wow it is missing!... I have added the "S" and will schedule a reboot tonight to see if all is well
Go to Top of Page
   

- Advertisement -