Data BI Visuals

Microsoft released SQL Server vNext as a platform for windows and Linux. Check the below video to know the installation process of SQL Server vNext.

If you want to use the transaction option in SSIS, then you have to consider about MSDTC. It is nothing but Distributed Transaction Coordinator. It has to be started before you perform the transaction option. Transaction option – Required, Supported (Default) & Not Supported. In case, if you are not consider MSDTC whether running or not, you will get an error message while executing the package. Error: 0xC001401A at Package: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B “The Transaction Manager is not available.”. The DTC transaction failed to start. This could occur because the MSDTC Service is not running. How to start the MSDTC, There two ways to start service, 1. Windows + R and type dcomcnfg and go to local DTC click properties. Make sure to setup same as below image. 2. Check the DTC service in services.msc

When you  get below error message, “Alter failed for server ‘’ The execute permission was denied on the object ‘xp_instance_regwrite’, database ‘mssqlsystemresource’, schema ‘sys’. (Microsoft SQL Server, Error:229)” If you are login as SQL Server authentication mode and trying to change the server authentication mode in the server properties. Solution: How to avoid this error, if you want to change the server authentication mode to Windows authentication, first you have to login as windows authentication and then go to server properties and change the mode. Make sure always login as windows authentication mode to change the server authentication mode properties.

Creating database mail profile and account is same in all the cases, the only difference is SMTP connection details.   To configure database mail using office 365 Mail, then follow the below details Smtp Server:  smtp.office365.com   Port:  587 (Microsoft recommending us to use 587, it will support 25 also but some of the time, it may block)