We sometimes run into scenarios where an application or a windows service running under Local System Account needs to connect to SQL Server and encounter authentication Errors/issues with SQL Server. In SQL Developer support team, we have worked on customer...

In this blog I will discuss about how to consume a Web Service in the Script Task of a SSIS package. To consume web methods in SSIS script task you need to follow the following steps: Create a Proxy Class of a Published Web Service ...

Today I am trying to cover a common issue that we face while trying to connect to a remote SSIS service. Sometimes, it happens that when you try to connect to SSIS using SSMS on the machine where SSIS is running and it connects just fine. ...

Last week I thought I should migrate my SQL CE 3.5 sample applications connecting and opening a Sql Compact Edition Database from Windows Server 2003 to Windows 7. In fact, I tried migrating them both to Win 7 and Win 2008 R2 and straight away ran into...

When you try to develop an SSIS package in x64 Environment in BIDS that connects to a Oracle Database, you will invariably run into connectivity issues if the installed Oracle Client tools version is 10.2.0.1 (x86). You will obviously need to install...

A lot of customer has asked me a common question : How should I expect my connections to behave if I don’t close it properly in the code. Though it is highly recommended to close the connection in your code itself and not depend on any other ways...

I hope you probably know how to fix below different authentication related errors that can occur while connecting to SQL Server with Windows Integrated Authentication. 1. Login failed for user '( null) '. Reason: Not associated with a trusted...