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

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:







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:







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

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

Edhy Rijo