www.skelta.com
Home      Members   Calendar   Who's On

Welcome Guest ( Login | Register )
      

Home » Skelta Workflow Net » Skelta Workflow Net » Application Development » connection strings


connection stringsExpand / Collapse
Author
Message
Posted Monday, February 20, 2006
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Skelta Workflow/BPM Net
Last Login: Friday, November 17, 2006
Posts: 5, Visits: 50
In WorkflowNET.Config.Xml, there are many connection strings. How can I protected them? Is it possible to encrypt them?

One solution is to use trusted connection (Integrated Security=SSPI). But in this case I need to setup Skelta services to be running under custom account. Also a web part of Skelta is using the same configuration file as main Skelta service, so the web part is running under different account.

So both accounts need to have access to SkeltaTemp and I must to setup permissions on this folder. What to do, if it's not possible (in client's environment) to setup any persmissions anywhere in %SYSTEM%\Temp\ ? Is it possible to move Skelta temporary folder to Program Files\Skelta\Workflow.NET\ (like .NET) ?
Post #43
Posted Monday, February 20, 2006
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Friday, February 22, 2008
Posts: 25, Visits: 61
Its simple. You can return connection string from a method by developing a class implementing IDBConnectionString interface.

Class implementing IDBConnectionString Interface:

This interface can be used to secure the connection string configuration in Workflow.NET configfile <datasource type="sql server" class="" assembly="" param= ""><%CustomData%></datasource>. Custom data can be passed to the interface method by setting the inner text for the datasource node.

Using this the connection strings can be moved from the configuration file to dll in order to enhance security.

Four implementation code samples available in <programfiles>\Skelta\Workflow.NET\Doc\SkeltaHelp.chm file.

Skelta Workflow.NET 2004 R2 Help -> About Skelta Workflow.NET 2004 R2 -> What is new in Skelta Workflow.NET 2004 R2.
Feature 6: Class implementing IDBConnectionString Interface

Moderator

Post #44
Posted Monday, February 20, 2006
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Skelta Workflow/BPM Net
Last Login: Friday, November 17, 2006
Posts: 5, Visits: 50
Yes, it works. Now I can encrypt my connection string in registry.
Thank you
Post #45
Posted Monday, February 20, 2006
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Skelta Workflow/BPM Net
Last Login: Friday, November 17, 2006
Posts: 5, Visits: 50
Does support XmlResourceHandler this syntax? I tried it and I got an error:
[NullReferenceException: Object reference not set to an instance of an object.]
ResourceHandler.XMLResource.Initialize() +1930
Workflow.NET.ActionsData.InitializeResourceHandler() +347
Workflow.NET.Web.ActivityControl.ActivityControl.InitializeActionsData(String ApplicationName, String WorkflowName) +735

And what about a DatabaseContentHandler? In sample config file for the DatabaseContentHandler, the connectionString is XML attribute of the element <data source .../>.
Post #46
Posted Wednesday, March 01, 2006
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: Friday, February 22, 2008
Posts: 25, Visits: 61
Please refer to the response posted for your earlier post (http://www.skelta.com/forum/Topic40-17-1.aspx)

Thanks

Moderator

Post #48
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
-
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.

All times are GMT -5:00, Time now is 3:44am

 
Execution: 0.141.12 queries.Compression Enabled.

Copyright © 2002 - 2007 Skelta Software. All rights reserved. Tel: 1 (703) 229-6732 | Email:sales@skelta.com
Skelta - A BPM Workflow Software Company