Category: Security

Issue time11:29:00 am, by Tom Green Email 619432 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
Issue time10:53:00 am, by Tom Green Email 1656 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
Issue time05:12:00 am, by Tom Green Email 2519 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
Issue time07:34:00 am, by Tom Green Email 1757 views
Categories: SQL Server, Errors, Security
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 »

Leave a comment
October 2020
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31

Search

Email Subscription

Enter your email address:

Delivered by FeedBurner

Translate

Advertising









XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
Server Configuration More...
Errors More...
SQL Server More...
SSIS More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution