Security Concerns with SQL Server 2008

In SQL Server 2008 the local Administrators group of a Windows server is no longer automatically given access to a SQL Server instance installed on that Windows server.

Keep this in mind when installing SQL Sentry for use with SQL Server 2008. Adding the service account to the local Administrators group for the SQL Sentry database server does not automatically grant the service user access to the SQL Sentry database by default with SQL Server 2008 and up. Given that the service user does need dbo access to the SQL Sentry database, it may be necessary to add the user or group to SQL Server security manually.

Have more questions? Submit a request


Please sign in to leave a comment.