Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Connectivity   (RSS)
Wednesday, July 01, 2009 10:12 PM

When in doubt, Reboot!

I tend to get quite a bit of Kerberos related cases.  These are related across the box, from the Engine, to Reporting Services to just straight connectivity with custom applications.  I had one given to me yesterday because the engineer had
Posted by psssql | 0 Comments
Friday, February 13, 2009 4:16 PM

Searching for Duplicate SPN's got a little easier

We get a lot of calls related to Kerberos configuration, and I'm planning to write more about our experiences and troubleshooting techniques for these types of issues across the box (Engine, AS and RS). With Windows 2000/2003 SetSPN had only a few commands
Posted by psssql | 2 Comments
Tuesday, February 10, 2009 8:37 AM

How to troubleshoot leaked SqlConnection Objects (.NET 2.0) - Part 2

In the last post in this series, we looked at how we can determine that our Connection pool was exhausted. In this post I'm going to go a little deeper into the Internal connection itself and how we can verify if this is a closed or active connection.
Posted by psssql | 0 Comments
Thursday, February 05, 2009 8:54 PM

How to troubleshoot leaked SqlConnection objects (.NET 2.0) - Part 1

One of my colleagues, Kamil Sykora, compiled a document that goes through how to troubleshoot leaked SqlConnection objects (from a .NET 2.0 perspective).  It was a fairly large document, so I’m not going to post the whole thing.  I’m
Posted by psssql | 3 Comments
Wednesday, December 31, 2008 3:30 PM

SQL 2005 JDBC Driver and Database Mirroring

We ran into some interesting situations with the SQL 2005 JDBC Driver (v1.2) and it's use with failover partners. Take the following connection string: jdbc:sqlserver://myserver1;databaseName=AdventureWorks;failoverPartner=myserver2; In this connection
Posted by psssql | 2 Comments
Tuesday, November 18, 2008 11:57 PM

RSWindowsNegotiate and 401.1 Error when using RS 2008

While I was setting up one of my demos for SQL PASS, I starting hitting 401.1 errors.  I was setting up a SharePoint Intergrated setup with Reporting Services. I knew I had a distributed environment, so I accounted for my Kerberos configuration. 
Posted by psssql | 1 Comments
Wednesday, October 01, 2008 5:06 PM

TCP Chimney Offload – Possible Performance and Concurrency Impacts to SQL Server Workloads

TCP Chimney is enabled by default if you apply Windows Server 2003 Sp2.  This is an operating system feature that provides capability to offload TCP/IP packet processing from the processor to the network adapters and some other balancing options. 
Posted by psssql | 3 Comments
Friday, August 29, 2008 4:08 PM

How It Works: Creating An EndPoint Adds An Entry To SysLogins

My SQL Server does not have individual windows users established as separate logins.   Instead it has the Domain\SQLUsers group established as a WINDOWS GROUP login.  You can review your mappings using the following DMVs. select * from
Posted by psssql | 1 Comments
Filed under: ,
Tuesday, August 19, 2008 2:12 PM

Timeouts when connecting to Named Instances

When connecting to a SQL Named Instance, you may encounter a Timeout error when trying to connect to it if the client is Vista or Windows 2008 with the client Firewall enabled. This particular issue is only present if you are running the SQL 2008 Browser
Posted by psssql | 1 Comments
Friday, June 22, 2007 5:04 PM

How to configure Database mirroring for use with ODBC applications?

If you have an ODBC application that is connecting to a mirrored database and if The application uses a connection string without a database name ( for e.g: dsn=ssistest;uid=ssistest;pwd=*********) The DSN is configured to use SQL authentication with
Posted by psssql | 1 Comments
Attachment(s): Sampledts_screenshots.zip
 
Page view tracker