Manage Email Signatures Centrally - For All Users

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

When I click Actions/Deploy Signatures/For Individual Users, no users show up in the dialog. How do I get users in there.

Jesper Frier · Posted: Tue Apr 22, 2008 5:20 pm Post subject:

First time users run Sign.exe, users are listed.

Following our Best Practice Deployment Guide, you can get all users listed without setting any default signatures.
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

So you are saying I need to get those through actually starting a deployment? I'm not sure I like that. I'd like to see a different approach to that in the future.

Jesper Frier · Posted: Tue Apr 22, 2008 5:45 pm Post subject:

Then select For all or For Groups and then change to individual settings afterwords.

Or please explain what you want to archive with individual settings? Then I might come up with another idea ...
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

I just want to be able to apply a signature to a set of users by selecting them from AD. Not sure what archiving means here.
I did what you suggested and I tried running this just from the command line and I get a blank message box that pops up with nothing in it. Will that happen once I put this in the login script.

Jesper Frier · Posted: Tue Apr 22, 2008 6:01 pm Post subject:

Did you complete the setup Wizard? Then you have eMailSignature.bat in the netshare you chose for your settings DB.

If not, then learn how to get started here ...
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

I did go through that, and I ran the deployment guide from Cockpit to make sure I have the right database string. I'm testing so I don't have it in a share quite yet. The command I'm running is:

C:\>start c:\sign.exe Provider=sqloledb;Data Source=VBSQLN01;Initial Catalog=eMailSignature;User Id=XXXXX;Password=XXXXX;

The messagebox that pops up shows a Red X and nothing else. I DO see myself now in the Cockpit, but I don't want users to see that messagebox. Doesn't seem to me moving to a network share would fix that.

Jesper Frier · Posted: Tue Apr 22, 2008 7:06 pm Post subject:

Only you can execute Sign.exe on C:. This is why you get the red X ... :shock:

Instead move Sign.exe to a location where users can execute it, e.g.:

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

Tried it both ways and I still get a Red X. Users won't have write access to the Netlogon directory, just read and execute. I tried running this from command prompt, directly from the Run line. I created a .cmd file with the full command to run "start \\banet03\netlogon\sign.exe Provider=sqloledb;Data Source=VBSQLN01;Initial Catalog=eMailSignature;User Id=XXXXX;Password=XXXXX; and still no luck. Any ideas?

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

I think I figured this out. I had my settings database using Integrated Security for testing and then I wanted to push this out using a authenticated user. It looks like it barfs on that because when I try it with integrated it works. Problem is users won't be able to use integrated and will use SQL Authentication with just reader permissions. Is there any way around this?

Jesper Frier

The permissions needed for SQL Authentication are described here:

SQL 2000 Server

SQL 2005 Server (open and view script)
_________________
</Jesper> | Test Email Signature | Showcase |

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

I did actually what's in that document and when I try and run, I still get the Red X

Command I'm running is:
start \\banet03\netlogon\sign.exe Provider=sqloledb;Data Source=VBSQLN01;Initial Catalog=eMailSignature;User Id=XXXXX;Password=XXXXX;

I've verified connection the the databse using both SQL user accounts.

ddyson · Just can't stay away Joined: 28 Mar 2008 Posts: 23

I really need an answer on this as it's preventing us from pushing this out. Is there anything that we can do try and find out why this Red X is popping up? Is there any debug mode we can use with sign.exe to get some feedback? I've verified that our connection string works through multiple SQL tools and I can read all the database tables. It seems to work using integrated security without any problem, but not using SQL Auth. I checked the SQL box and it's giving an error:

Login failed for user 'WebApp'.

Again, I can login fine using SQL Server Management Studio with the userid and password.

Jesper Frier · Posted: Thu Apr 24, 2008 10:04 am Post subject: Debug client

Either users cannot access Sign.exe or your settings DB. Cannot think of any other reason ...

Please debug client and post log ...

Suggestions

Use our SQL Statement for SQL 2005.
Try with NETLOGON in capital letters ...

Code:

start \\banet03\NETLOGON\sign.exe Provider=sqloledb;Data Source=VBSQLN01;Initial Catalog=eMailSignature;User Id=XXXXX;Password=XXXXX;
Can users open in explorer?

Code:

\\banet03\NETLOGON\

Code:

\\banet03\netlogon\
Connect to default settings.mdb?

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