Category: Server Configuration

Issue time11:51:00 am, by Tom Green Email 10973 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
Issue time05:51:00 pm, by Tom Green Email 4642 views
Categories: Server Configuration
Create MSDB directory for storing SSIS packages from multiple instances (located in the msdb database of each of the instance):   Go to C:\Program Files\Microsoft SQL Server\100\DTS\Binn\ folder (SQL Server 2008) and edit the MsDtsSrvr.ini.xml file… more »

Leave a comment
Issue time05:29:00 pm, by Tom Green Email 1631 views
Categories: Errors, Server Configuration
Problem   When trying to send emails from SQL Server using using the sp_send_dbmail stored procedure the following error can appear (on SQL Server 2005 or 2008):   EXECUTE msdb.dbo.sp_send_dbmail    @profile_name = 'PROFILE_NAME', -- Change This  … more »

Leave a comment
June 2023
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  


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