Trouble Connecting to the security database


Author
Message
Greg McGuffey
Greg McGuffey
Strategic Support Team Member (3.4K reputation)
Group: Forum Members
Posts: 2K, Visits: 6.6K
I finally getting around to seeing how security works. It appears that I don't have it configured correctly to see the security tables, which are in a the StrataFrame db, which is on an instance of SQL Server 2005, while the app data is on the default instance, which is SQL Server 2000.



I setup a required datasource item with a key of 'security' for the security database and set the SecurityDataSourceKey='security'. However, I've obviously done something wrong, because it isn't finding my users. There is another required data source for my app data, with a blank key. This one is working, because when I login as admin, the app data is there.



What am I not getting?







GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Greg McGuffey - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Greg McGuffey - 18 Years Ago
Trent L. Taylor - 18 Years Ago
Greg McGuffey - 18 Years Ago
                         [quote]Will the DDT work with SQL Server 2000?[/quote] Yes, the DDT...
Trent L. Taylor - 18 Years Ago
                             OK, I did that, and it worked fine. My users, roles, permissions are...
Greg McGuffey - 18 Years Ago
                                 That is the security dialog works fine...still can't login as one of...
Greg McGuffey - 18 Years Ago
                                 But when you try to login with a user that is in your database, it...
Trent L. Taylor - 18 Years Ago
                                     Could you package up your SQL database and project...I think that is...
Trent L. Taylor - 18 Years Ago
                                         How much of it do you need? I'm converting a proprietary app, most of...
Greg McGuffey - 18 Years Ago
                                             Well...I thought you might be working with a test app since you are...
Trent L. Taylor - 18 Years Ago
                                                 Well, the app we need to use it on is complex. Rather than invent the...
Greg McGuffey - 18 Years Ago
                                                 ahhhh....it just dawned on me what you forgot to set. You do not have...
Trent L. Taylor - 18 Years Ago
                                                     As you suspected, this was not set.

I made both the same,...
Greg McGuffey - 18 Years Ago
                                                         Yes...set this in the role-based security editor, then set the...
Trent L. Taylor - 18 Years Ago
                                                         Wohoo! That was it. When set to the value in the security dialog,...
Greg McGuffey - 18 Years Ago
                                                             Good!:w00t: I will keep this in mind the next time I see these results...
Trent L. Taylor - 18 Years Ago
                                                                 Nope, pain teaches :hehe:
Greg McGuffey - 18 Years Ago
                                     [quote][b]Trent L. Taylor (11/07/2006)[/b][hr]But when you try to...
Greg McGuffey - 18 Years Ago
                                         Did you see my last post about packaging up your SQL database and...
Trent L. Taylor - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search