Category: Server Configuration

Issue time11:51:00 am, by Tom Green Email 10638 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 4136 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 1365 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
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