Category: Server Configuration

Issue time05:51:00 pm, by tom.green Email 30725 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 »

3 comments
Issue time05:51:00 pm, by tom.green Email 7319 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 tom.green Email 35034 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 »

15 comments
October 2017
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:

Translate

Advertising











XML Feeds

DBA Blog

Latest posts

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

Poll

Which database platform do you use?

View Results

Powered by b2evolution