Issue time11:29:00 am, by Tom Green Email 999695 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 time09:18:00 am, by Tom Green Email 18036 views
Categories: SSAS, Errors
Problem When trying to restore a SSAS database cube from a backup file, the following error appears: The following system error occurred:  The file exists. (Microsoft SQL Server 2005 Analysis Services) Solution I encountered this error in two diff… more »

Leave a comment
Issue time06:28:00 am, by Tom Green Email 16211 views
Categories: SQL Server, Performance & Tunning
<p>To specify multiple values for LIKE or NOT LIKE column filter you must simply press enter after you have typed the first value. Another textbox will be automatically shown under the first one, giving you the possibility to insert multiple filte… more »

Leave a comment
Issue time10:48:00 am, by Tom Green Email 12951 views
Categories: SQL Server, Errors
Problem After a Sql Server restart, the service failed to start giving the following error messages:   Error: 26049, Severity: 16, State: 1. Server local connection provider failed to listen on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. Error: 0x5 Error: 1… more »

Leave a comment
Issue time11:51:00 am, by Tom Green Email 11273 views
Categories: SSIS, Errors, Server Configuration
Problem When trying to browse the SSIS packages from Management Studio the following error can apera: The SQL Server specified in Integration Services service configuration is not present or is not available. This might occur when there is no default… more »

Leave a comment
July 2024
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      


Email Subscription

Enter your email address:

Delivered by FeedBurner



XML Feeds

DBA Blog

Latest posts

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


Which database platform do you use?

View Results

Powered by b2evolution