Before a user can connect to a RDP session they will need to be made a member of the Remote Desktop Users Groups this is found under control […]
Adding a parameter to the Report
We add parameters to reports to be able to dynamically fetch very selective data from the underlying database. Sometimes parameters are used for controlling the behaviour of a […]
Loading data from Excel AcquireConnection Error
[Excel Source [108]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager “Excel Connection Manager” failed with error code 0xC0209303. There may be error […]
SQL Server Replication Series – Fixing “Cannot Drop Distribution Database” Error
When removing replication using the wizard, you may encounter the following error message: Msg 21122, Level 16, State 1, Procedure sp_dropdistributiondb …Cannot drop the distribution database ‘distribution’ because […]
SQL Server Replication Series Part 1
Introduction and Concepts This blog is the first in a series on the topic of SQL Server replication. The topics are the same for the most part for […]