January 17, 2008 at 3:40 am
Hi,
I wondered if anyone can help me with a difficultly we have been experiencing for something.
Our company sells a desktop application that requires MSDE/Express to be installed on each PC along with our application.
Most organisations that purchase our software install the our application and MSDE/SQL Express as an administrator account and as a consequence users do not have access to the local SQL Server because they are not trusted users (we only use Windows authentication).
At the moment we workaround the problem by executing a bat file that adds runs the SQL commands to add a login and grant database access.
Is there a way to install MSDE/SQL Express so that all profiles on the local PC are given logins ?
How do other folk distribute MSDE / SQL Express across to each PC within a department.
Many thanks
David
January 17, 2008 at 6:54 am
If you have not other user group as the default (administrators,Users,...) It's already possible to create the login on the groups.
January 17, 2008 at 7:13 am
Many thanks for your help
Would it be possible to grant a login to 'BUILTIN\Users' within the installation itself or would I have to execute a batch file after SQL Express has installed?
Regards
David
January 17, 2008 at 11:14 pm
I think you need to create a batch and execute them after the installation.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply