| Reply To Message: |
| Posted By |
n/a on 10/5/2001 8:10:00 PM |
| Subject: |
Low Privilege User account for SQL 7 |
| Message: |
Hi All,
I'm trying to secure a SQL Server using the SQL Server Server Security Checklist I printed from your site. I'm having a lot problems with SQL Server 7 when a low privilege User account is used for SQL Server services. I'm running Windows NT 4.0 Server with SP6a as a Stand Alone with SQL Server 7 with SP3. I've created a Windows User account that has permission to:
1) Full Control to C:\MSSQL7
2) Full Control to SQL database files
3) Logon as a Service
4) Full Control the following Registry keys: HKLM\Software\Microsoft\MSSQLServer
HKLM\Software\Microsoft\WindowsNT\CurrentVersion\Perlib
HKLM\System\CurrentControlSet\Services\MSSQLServer
After assigning the above permission, SQL cannot execute the scheduled DTS package that I've created. What other permission(s) do I need to have access to in order for SQL to execute the DTS packages? |
|