You may see weird behavior when using the SSIS Object Model from an ASP.NET application

SSIS comes along with a rich set of application programming interfaces (APIs) for programming the Integration Services object model. You can extend packages by writing components that become available within SSIS Designer to provide custom functionality in a package. You can create, configure, and run packages programmatically from your own applications. The SSIS object model…

1

Testing SQL Connectivity with Machine Account

Many times during troubleshooting SQL Server Connectivity, we face the challenge to test our connectivity with the Machine accounts. For instance say you have a service running under local system or network service account and that makes a connection to SQL Server. In such scenario it will connect in the context of Machine Account. In…


“SSPI handshake failed” could result when the security event log has reached the maximum log size

I see a lot of issues related to SQL Server connectivity. One common error I see in the SQL Server logs is the SSPI error. Logon Error: 17806, Severity: 20, State: 2. Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT:192.168.0.5] Logon Error:…

1

SQL Server Query Performance when running query from a Windows 2008 Server

Recently I faced two cases in which we can see slow query performance when we run a SQL Server query from a Windows Server 2008 client machine. The query takes more time to complete when we run it from a Win2K8 machine as compared to a Win2K3 or WinXP machine. To test this we opened…

2