Manage Email Signatures Centrally - For All Users

robert.connor · Just can't stay away Joined: 13 Feb 2008 Posts: 40

Hi
Please can you advise. I am trying to deploy the signature but despite best efforts have not been able to make the sign.exe run properly.
The situation is thus:
We are using cockpit ver 5.0
MDB Data base installed on a clustered share. we are using the cluster name as a pointer e.g \\clustername\shareddirectory\sign.exe. Within this folder are all the files including the settings database.
Withing Group Policy Management under user configuration\policies\windows settings\scripts there is our logon script. This script is labelled Script name Sign.exe Script parameter "Nothing entered". Browsing this location takes you to our Sysvol where all the files are located.

Tthe problem is that the script is not being found by the clients The error received by the clients is"No settings Database can be located. Please write the connection string as a command parameter when running sign.exe. \\location\sign.exe [connectionstring].

The Batch file points to start \\clustername\emailsigneturedirectory\sign.exe provider=microsoft.jet.OLEDB.4.0;Data
Source=\\clustername\\emailsignaturedirectory\settings.mdb
I have tried various options such as changing the path to the physical node name rather than the cluster name to no avail.

I really hope someone can help me here as I want to get the signature deployed by next week. The problem may be staring me in the face and glaringly obvious so my apologies, but any help wopuld be greatly appreciated.

Beast Regards

Dave Culley · Posted: Fri Aug 22, 2008 9:28 am Post subject:

Hi,

I have just noticed that the path name seems to be spelt incorrectly

"The Batch file points to start \\clustername\emailsigneturedirectory\sign.exe provider=microsoft.jet.OLEDB.4.0;Data
Source=\\clustername\\emailsignaturedirectory\settings.mdb"

you have 2 different spelling of 'emailsignaturedirectory'

Could this be the error?

Thanks

robert.connor · Just can't stay away Joined: 13 Feb 2008 Posts: 40

Hi Dave

Thanks for your reply. No that was just a typo in the request and used as an example. The actual location is \\Clustername\eMailsignature for both.
I have just logged on to another machine and received the error highlighted above about the 'No settings database can be located etc' followed by the error 'Object variable or with block variable not set' So it it the location that is still the problem.

Many thanks

Dave Culley · Posted: Fri Aug 22, 2008 11:26 am Post subject:

This looks OK, have you tried running this command from the run box of your PC? If it works OK this way then it must be an issue with the way your machine handles .bat files

Please go to Start- Run, then copy the string into this box and let me know the outcome

Jesper Frier · Posted: Fri Aug 22, 2008 11:33 am Post subject:

One additional comment ... If you completed the set-up Wizard, you have eMailSignature.bat located in \\clustername\\emailsignaturedirectory\.

Please execute this string and check Help -> Diagnostics to see it works.

This might give you an idea where to troubleshoot ... Wink

_________________
</Jesper> | Test Email Signature | Showcase |

robert.connor · Just can't stay away Joined: 13 Feb 2008 Posts: 40

Hi Guys

I can confirm that it will run from the RUN CMD but I am unable to see any Diagnostics in the cockpit as the application continually crashes with every attempt to open it. (I have seen that from previous posts I may need to reinstall the application as it may be corruptd)
In the meantime the deployment guide is saying that in order for signatures to be deployed to other users the location needs to be \\ourdomaincontroller\NETLOGON\sign.exe provider=Microsoft.jet.4.OLEDB.4.0;Data Source=\\Clustername\eMailsignature\settings.mdb? I have tried to set this path up but it then fails with an error.

Thanks

Jesper Frier · Posted: Sat Aug 23, 2008 6:51 am Post subject:

Please let me know if I am wrong:

You installed Cockpit on desktop PC.
You have copied Sign.exe to \\ourdomaincontroller\NETLOGON\
You have settings DB on \\Clustername\eMailsignature\
You execute this script and get an error:

Code:

start \\ourdomaincontroller\NETLOGON\sign.exe Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Clustername\eMailsignature\settings.mdb

Troubleshooting

Can you see settings.mdb when pasting this sting in Windows Explorer; \\Clustername\eMailsignature\?
Can you see Sign.exe when pasting this sting in Windows Explorer; \\ourdomaincontroller\NETLOGON\?
Please let me know which error you get running the script.

Next step is troubleshooting Cockpit crashing ...
_________________
</Jesper> | Test Email Signature | Showcase |