Category: Security02/05/14
Problem
When executing queries using OPENROWSET statement, the following error can appear:
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this… more » Tags: opendatasource, openrowset
12/03/13
The following error is received when a user that is not sysadmin is trying to execute the xp_cmdshell stored procedure:
exec xp_cmdshell 'dir c:'
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
The EXECUTE permission was denied on the o… more » 10/03/13
Problem
When trying to create a login the following error appears:
USE [master]
GO
CREATE LOGIN [Domain\LoginName] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
Msg 15025, Level 16, State 2, Line 1
The server principal ?Domain\LoginName? alre… more » 01/04/13
Problem
Could not obtain information about Windows NT group/user 'DOMAIN_NAME\user_name', error code 0x5.
The above error can appear when users which are not members of sysadmin server role they try to:
- Execute a SQL job which is not ow… more » |
11:29:00 am, by 
