StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » RBS (Strataframe) database on a separate server

RBS (Strataframe) database on a separate server

Jeff Pagley — Mon, 06 Apr 2009 17:31:58 GMT

Hi SF Team,

How do I setup the DB connections in my app to point to the RBS (Strataframe) database on a different server than my user database. Right now what I am doing is the following which is a connection string which points to the same server for both databases.

builder.DataSource = MyDataSource

builder.InitialCatalog = MyDataBase

builder.UserID = "sa"

builder.Password = MyPassword

DataLayer.DataSources.Add(New SqlDataSourceItem("", builder.ConnectionString))

Thanks,

Jeff

RE: RBS (Strataframe) database on a separate server

Edhy Rijo — Mon, 06 Apr 2009 17:31:58 GMT

Also Charles Thomas Blankenship posted a detail document on how to setup the RBS on a separate database, check out this link: [url=]http://forum.strataframe.net/FindPost14216.aspx[/url]

RE: RBS (Strataframe) database on a separate server

Greg McGuffey — Mon, 06 Apr 2009 14:59:13 GMT

Jeff,

The SecurityDataSourceKey and the SetSecurityKeyAndVectorForUserAuthentication are [b]not[/b] the same thing.

The SecurityDataSourceKey is a key that is used to access a data source that contains the security tables/views used by RBS. The key is a string. If you look at the properties of a BO in the designer of that BO, you'll notice a DataSourceKey property. This is set to the key of the DataSource the BO will use to interact with the data. The SecurityBasics.SecurityDataSourceKey is simply used to set this property on the RBS BOs that provide data for the various RBS features.

The security key and vector is a string that is used to generate a key and vector that is used to encrypt the information within the Data column in the user table (SFSUsers). You set this in InitiApp() and it [b]must[/b] match what has been set as the security key in the security project (see "[i]Specifying the Encryption Key for User Data[/i]" in help) if you want to distribute any user data set at design time.

So, since they are both just strings, they [i]could[/i] be the set to the same string, but they are not the same thing and I'd likely not use the same string.

RE: RBS (Strataframe) database on a separate server

Jeff Pagley — Mon, 06 Apr 2009 14:39:16 GMT

Thank you Greg for the prompt response. In looking into this further, what I also found was the following where the "MyEncryptionKey" value is what I used for the datasource key which matches my Security Key when I created my RBS project.

builderRBS.DataSource = MyDatabaseServer

builderRBS.InitialCatalog = "StrataFrame"

builderRBS.UserID = "sa"

builderRBS.Password = saPassword

DataLayer.DataSources.Add(New SqlDataSourceItem("MyEncryptionKey", builderRBS.ConnectionString))

SecurityBasics.SetSecurityKeyAndVectorForUserAuthentication("MyEncryptionKey")

The .SetSecurityKeyAndVectorForUserAuthentication sets my database connection and provides the security key to the RBS system. I believe all I have to do now is change the .DataSource value and it should enable me to accomplish what I want orginally wanted. Is this correct?

Jeff

RE: RBS (Strataframe) database on a separate server

Greg McGuffey — Mon, 06 Apr 2009 14:13:35 GMT

There are two things you need to do differently when the security data is not in the same database as the rest of the app:

1. Make sure the key of the datasource that access the security tables differs from the key used by the rest of the app. The default key is an empty string (""). This is typically used for the main data source. You need to use a different one for the security datasource:

[codesnippet]DataLayer.DataSources.Add(New SqlDataSourceItem("security", builder.ConnectionString))[/codesnippet]

The key is set to "security" in the line above.

2. Let the framework know that the security data is accessible via this datasource, by setting the SecurityDataSourceKey to the key you used when creating the data source for security:

[codesnippet]SecurityBasics.SecurityDataSourceKey = "security"[/codesnippet]

Both of these are typically done the the SetDataSources method in AppMain.vb (program.cs).