Is it possible to pass information into the SQL Server relational engine via the connection string in the same way as it can be done for Analysis Services?
I need to generate a user context for a forms authentication application (i.e. no windows user accounts).
SSAS allows you to pass in a list of database roles or a customdata parameter on the connection string. These can be used inside the database in lieu of a windows identity. I am wondering if there are equivalent parameters available for the SQL connection
I guess that I could create SQL logins from each of the forms users with a system generated password and then pass the uid and password on the connection string but this seems unnecessarily complicated. Andrew Wiles - www.it-workplace.com - MDX made simple
View Complete Post