SSIS Service fails with error "Access denied" at startup

Recently I got an issue where we were unable to start the SQL Server Integration Services(SSIS) service and was failing with the error of “Access Denied”. If you do a default installation then the SSIS service runs under NT AUTHORITY\Network Service. Symptoms Occassionaly you will also see the folowing error inside System Events DCOM got…


Indications that we are leaking connections

We get a lot of queries from developers around the following error while they are using ADO.NET "Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached." Most of the times this is an…

1

SSL in Microsoft SQL Server JDBC 1.2 driver

One of the major difference between Microsoft JDBC Driver 1.1 and Driver 1.2 is its feature for SSL. If you want to connect to SQL Server 2005 using SSL then you can do this today with the driver. The process to get this done is documented in the help section . This post, is going…