I've been trying to determine the best way to connect to an SQL database. When trying to connect to a remote server, it is easier. I simply create a user or group with read/write access to the database.
But if I wanted to setup the application to run off of SQL Express locally as a standard user how do I do that? The problem I am running into is that the user installing the software isn't neccesarily the user that will access the database on the local machine. So I can't simply give a specific user access to the database or folder location. What do I do without using SQL Authentication? The users can connect to the database, but can not read the data.
Thank you.
But if I wanted to setup the application to run off of SQL Express locally as a standard user how do I do that? The problem I am running into is that the user installing the software isn't neccesarily the user that will access the database on the local machine. So I can't simply give a specific user access to the database or folder location. What do I do without using SQL Authentication? The users can connect to the database, but can not read the data.
Thank you.
