Patching SQL Server 2005 on a cluster failed with ‘Data source name not found and no default driver specified’. What caused it for a reader and the fix.
SQL SERVER – Cannot initialize the data source object of OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server
Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 showed up only from the client machine. Here is why and the fix.
SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())
A connection error on a named instance that works by port but not by name. What SQL Browser answers on UDP 1434, and why local tests prove nothing.
Network Packet Size: When a Bigger Packet Helps Large Results
Test network packet size on a specific SQL Server connection, verify the negotiated value, and compare large-result performance carefully.
SQL Server – Understanding Connection Timeouts and Query Timeouts
Understanding connection timeouts and query timeouts in SQL Server: how they differ, why they get confused, and where to look when one hits.
SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached
A client changed one setting, restarted and nobody could connect: the maximum number of 1 user connections has already been reached. Here is how we got in.
SQL SERVER – Patch Upgrade – Failed to connect to server. Error: 0x80070422
A client’s SQL Server 2008 R2 SP2 patch failed, and the setup logs showed Failed to connect to server, Error: 0x80070422. Here is how we traced and fixed it.