I've got a SQL Server 2008 R2 Express database that we're going to be using for an application we're re-writing. Currently we're using entity framework 4.2 to access it, but the connection string uses SSPI, so (as I understand it) that means it's using the currently logged in user. I thought I had that fixed, but apparently I don't. I want to make it so that all users properly logged into their Windows account will be able to do normal CRUD operations as well as run user defined stored procedures, in that SQL Express database. How do I accomplish that?
Never mind, I've asked this question already.
Connect with me on LinkedIn