Can someone please explain (or provide code template) how to login to SQL Server using SQL Server (not integrated) security in a Silverlight RIA application, where the client module would have to obtain the login & password from the user, then this would get passed to the Server App, I assume to then construct the connection string before the Server connection is initiated.
I have SQL Sever 2008 R2, & using current Telerik OpenAccess. Constructing the connection string is easy in the constructor of the back-end EntityModel. What is hard is how to pass the login & password from the client to the server first, to construct this.
Thanks.
Phil
I have SQL Sever 2008 R2, & using current Telerik OpenAccess. Constructing the connection string is easy in the constructor of the back-end EntityModel. What is hard is how to pass the login & password from the client to the server first, to construct this.
Thanks.
Phil