September 11, 2007 at 3:17 pm
I have an application which is connected to a Sql Server Express. I want to switch over to Windows Authentication, but sql server express won't let standard users (ie non admin's) to connect to the database. The app is installed on a very large number of PC's so I can't go from site to site and create user logins for the pc's.
I have dabbled with user instances, but that doesn't seem to be working either. It says the user login fails. I have thought about using application roles.
What is the best way to handle this situation?
September 23, 2007 at 10:25 pm
Take a look at your permissions on the database. There should be no reason that SQL Express would arbitrarily disallow non-admins from connecting to the database, unless this is a corporate policy for this app and has been intentionally set up to do so. You can grant login to a Windows user or group, and assign permissions for database objects to that user/group.
hth
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply