Error when using msdb.dbo.sp_send_dbmail: SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for... » read more
Resolution: SSIS feature not installed on the database server. Install SSIS to fix the problem.
Setup Availability Replicas – Select Server Availability Databases – Select Database Availability Group Listeners – Select Listeners (optional) Note Two servers setup in Availability Group. One Primary and one Secondary. (Can have multiple Secondary) Secondary setup as read-only. Listener setup as the pointer. Connection string should point to listener. (Optional) On Primary Server, will display... » read more
There are 2 ways to deploy SSIS packages. #1 Directly from Visual Studio #2 From SQL Server Management Studio SQL Server Management Studio Create specific folders under SSISDB. To deploy a project deployment file that you created by building a project in the development environment, select Project deployment file and enter the path to the .ispac... » read more
Prior to SQL Server 2012 Availability Group, SQL Server 2008 uses Mirroring and Log Shipping. Database Mirroring Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. A copy of the database is created... » read more
Registering a server in SQL Server Management Studio allows you to store the server connection information for future connections.There are three ways to register a server in SQL Server Management Studio. Local instances of SQL Server are automatically registered during the first launch of Management Studio after its installation. You can also initiate the automatic... » read more
Displays the active server node: Whether the server is clustered:
Microsoft Windows Failover Clustering is a high-availability option designed to increase the uptime of SQL Server instances. A cluster includes two or more physical servers, called nodes; identical configuration is recommended. One is identified as the active node, on which a SQL Server instance is running the production workload, and the other is a passive... » read more