SQL Svr Agent Permissions Across Servers

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)

SQL Svr Agent Permissions Across Servers

Author

Topic

scottyc
Starting Member

2 Posts

Posted - 2006-08-08 : 17:44:48

Thanks in advance for the help.

I am new to multi-server environments and inherited ths problem right out of the block.
It appears to be a rights issue, as opposed to an application issue but I could be wrong.

I have a Cognos Application on Server 1 and a SQL Server Agent job that runs vbscript on Server Two that attempts to fire off one of the “Create Cubes pyi” jobs. This vbscript used to run on Server 1 but has now been moved to Server Two.

The job errors out with this error:
Executed as user: SERVER2\SYSTEM. Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: ActiveX component can't create object: 'CognosTransformer.Application.cer4' Error on Line 2. The step failed.

SERVER ONE – OLD WORKING CODE
strModelPath = "E:\Cognos\BI Applications\Shipments\PowerPlay Models\daily ship 4pm.pyi"
Set objTransApp = CreateObject("CognosTransformer.Application.cer4")
Set objModel = objTransApp.OpenModel (strModelPath,"impromptu","warehouse","creator")

objmodel.CreateMDCFiles
objmodel.close

Set objCube = Nothing
Set objModel = Nothing
Set objTransApp = Nothing

SERVER TWO – NEW NON-WORKING CODE
(Where “S2” is Server Name, “DATA” is mapped drive name)
strModelPath = "\\S2\DATA\Cognos\BI Applications\Shipments\PowerPlay Models\daily ship 4pm.pyi"
Set objTransApp = CreateObject("CognosTransformer.Application.cer4")
Set objModel = objTransApp.OpenModel (strModelPath,"kpark","wine","creator")

objmodel.CreateMDCFiles
objmodel.close

Set objCube = Nothing
Set objModel = Nothing
Set objTransApp = Nothing

Other Information:
Server 1 db startup in Administrator Account
Server 2 db and Agent Service startup in System Account
Agent Connection uses Windows Authentication.

Thanks in advance for the assist!

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2006-08-09 : 02:29:35

I suspect that there is something wrong with the CognosTransformer dll but to make sure you can create a .vbs-file with the same code you have here (you might want to comment out this line: objmodel.CreateMDCFiles), then save the file, right-click it and try to "Run as" several different accounts with different permissions and see what happens.

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-08-09 : 15:46:33

ScottyC,

The problem is that Server1 has a COM (ActiveX) library registered that Server2 doesn't. (It's whatever library/libraries that contain CognosTransformer).

You'll need to install whatever parts of Cognos you need to register that library on Server2.

Ken

scottyc
Starting Member

2 Posts

Posted - 2006-08-09 : 16:03:42

Thanks much Ken ... I'll pursue this possible solution!

Scott

Thanks in advance for the assist!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources