Category: Server Configuration

Issue time05:51:00 pm, by Email 32626 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 »

Issue time05:51:00 pm, by Email 8581 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 and edit the MsDtsSrvr.ini.xml file: <?xml version=… more »

Leave a comment
Issue time05:29:00 pm, by Email 39799 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 »

March 2019
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:



XML Feeds

DBA Blog

Latest posts

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


Which database platform do you use?

View Results

Powered by b2evolution