September 1, 2011 at 3:12 am
I have an .NET 1.1 application that uses MSDE SP4 on XP SP3. When I install and use the application with a local Admin account it runs fine.
As soon as I switch to a user account that has restricted access the application goes into slow mode and everything takes a very long time to happen.
ANy ideas?
September 5, 2011 at 3:04 am
There are lots of rights that need to be applied to the service account if it is not local admin. The main problem is finding a full list of these in one place. The SQL FineBuild reference manual does have this for SQL 2005 and above, and they probably also apply to SQL 2000. (The FineBuild security model is built around not needing local admin access for the service account or the DBA, and assigning the rights needed for these roles to work correctly.)
However, SQL 2000 does have hardcoded checks in it for local administrator rights, so even if you do apply all the rights that SQL 2005 needs to run OK then SQL 2000 may still not run as you wish. You will just have to try this and see.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply