Skip to main content


Showing posts from April, 2010

Modify local security policy to grant service rights

Specific rights must be granted to user accounts to allow the account to be used to run as a service. There are a number of possible methods. Method 1: Grant rights using Group Policy This can be achieved using group policy: Method 2: Grant rights using Security templates Similar to method 1 but using Security templates to change the permissions on system services.    1. Click Start, click Run, and then type MMC.    2. On the Console menu, click Add/Remove Snap-in.    3. Click Add.    4. Select the Security Configuration and Analysis snap-in, and then click Add.    5. Click Close, and then click OK.    6. In the MMC, right-click the Security Configuration and Analysis item, and then click Open Database.    7. Give a name for the database, and then browse to where you would like to store it.    8. When prompted, select a Security Template to import. For example, the "basicwk.inf" contains values fo

SQL 2005/2008 Ad hoc access to OLE DB provider has been denied

I have a previous post on enabling adhoc access for SQL 2000 ( ), SQL 2005 and 2008 are a little different. SQL 2005/2008 returns the following: SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online. To enable OpenRowset and OpenDatasource: Launch the "SQL Server 2005 Surface Area Configuration" tool. Click "Surface Area Configuration for Features" Select "Server Name > Database Engine > Ad Hox Remote Queries" Tick "Enable OPENROWSET and OPENDATASOU