Category: Server Configuration

04/11/13

There is no default instance of SQL Server on the computer

Currently 3.72/5
1
2
3
4
5
i

11:51:00 am, by Tom Green

11309 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 »

Currently 3.72/5
1
2
3
4
5
i

Permalink

Create directories in SSIS tree for storing packages

Currently 3.57/5
1
2
3
4
5
i

05:51:00 pm, by Tom Green

5095 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 »

Tags: create directories in ssis , msdtssrvr.ini.xml

Currently 3.57/5
1
2
3
4
5
i

Permalink

Profile name is not valid

Currently 3.87/5
1
2
3
4
5
i

05:29:00 pm, by Tom Green

1770 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 »

Tags: profile name is not valid, sp_send_dbmail