Manage Email Signatures Centrally - For All Users

frisotrip

Testing the new 7 version gives me this error. I have installed it on a 2008 SBS server, and build in sql server 2005.
When deploying sign.exe this error occurs in the logfile. Also tried it with version 5.5 also gives that message.

I have downloaded the sql file from this site.

thanx

Jesper Frier · Posted: Sun Sep 06, 2009 1:20 pm Post subject:

Hi Friso,

The SQL settings DB script is not yet updated.

Until we update the script, please use the default Access settings DB, or export from Access to SQL.
_________________
</Jesper> | Test Email Signature | Showcase |

frisotrip · Posted: Sun Sep 06, 2009 1:39 pm Post subject:

Jesper
I will try that.
Now i have another weird problem. Running "\\svr1friso\netlogon\sign.exe Provider=sqloledb;Data Source=SVR1FRISO\SBSMONITORING;Initial Catalog=EmailSignatures;User Id=Standard_User;Password=changemealso;" on the server it works, but on client pc's it takes his time to run, and after appr. 30 seconds it closes without an error but looking in the cockpit the is not there.

Any idea what this can be
thanx

Jesper Frier · Posted: Mon Sep 07, 2009 5:10 am Post subject:

Friso,

There are two things in your script you have to double check ...

- Data Source=SVR1FRISO\SBSMONITORING (the SQL Server name here)
- Catalog=EmailSignatures (default name in script is eMailSignatures)

Try and create a bat-file and execute this content:

frisotrip · Posted: Mon Sep 07, 2009 5:23 am Post subject:

Jesper

But why is it working on the server itself? When the script wasn't right it must not work on the server, but it did.

When i looked in the sql servername it says the name is svr1friso\sbsmonitoring, i think the server name of the sql server is right, because on the server it works. On client site it doesn't.

Jesper Frier · Posted: Mon Sep 07, 2009 5:44 am Post subject:

There are (as far as I know) only two reasons why users fail to run the SQL script:

Users cannot read the path to Sign.exe
Users might not have access to your settings database.

Re. 1: As you used the NETLOGON share, users do have execute permissions. Try and paste the path to Sign.exe in users explorer to see if they can see your server;

Bjarne Mess · Posted: Mon Sep 07, 2009 8:36 am Post subject:

Please note that the SQL script is not modified yet to the new version 7. Everything is still in beta, and there is a lot of unfinished stuff.