Connectivity

87 Topics

How It Works: SQL Server 2005 Connection and Task Assignments
First published on MSDN on Feb 12, 2008 I have talked about how connections and tasks get assigned as PASS and during many other mentoring opportunities.
mssql-support
Sep 09, 2025 Place SQL Server Support Blog
444Views
0likes
0Comments
Run SQL Server default instance on a non-standard TCP port. Tips for making app connectivity work
First published on MSDN on Mar 03, 2010 We know that with the default setup of SQL Server (SQL Server 2000/2005/2008), the ‘Default’ instance listens on TCP port 1433.
Krishnakumar_Rukmangathan
Feb 27, 2025 Place SQL Server Support Blog
6KViews
0likes
0Comments
Connection Timeouts in Multi-subnet Availability Group
First published on MSDN on Jun 03, 2014 THE DEFINITION One of the issues that generates a lot of call volume we see on the AlwaysOn team is dealing with connectivity issues to the availability group listener in multi-subnet environments.
mssql-support
Feb 18, 2025 Place SQL Server Support Blog
59KViews
0likes
2Comments
How to grant ReadServicePrincipalName and WriteServicePrincipalName rights to SQL Server service start-up account without using ADSDIEDIT tool.
First published on MSDN on Jan 06, 2010 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.
Krishnakumar_Rukmangathan
Jun 05, 2024 Place SQL Server Support Blog
6.5KViews
0likes
1Comment
The OLE DB provider "MSDASQL" for linked server " " supplied inconsistent metadata for a column.The column " " (compile-time ordinal 2) of object " " was reported to have a "DBCOLUMNFLAGS_ISLONG" of 0...
First published on MSDN on Jul 23, 2015 Applies To: SQL 2012 and above.
Krishnakumar_Rukmangathan
Feb 15, 2024 Place SQL Server Support Blog
36KViews
0likes
1Comment
Error 18056 can be unwanted noise in certain scenarios
First published on MSDN on May 05, 2010 I saw a lot of hits on the web when I searched for the Error message 18056 with State 29.
mssql-support
Jan 17, 2024 Place SQL Server Support Blog
2.8KViews
0likes
1Comment
Connecting to MySQL from SSIS
First published on MSDN on Mar 04, 2008 Update: See this follow-up post on writing data to MySQL.
SSIS-Team
Oct 18, 2023 Place SQL Server Integration Services (SSIS) Blog
60KViews
1like
2Comments
How to get unstuck when using SQL Aliases
First published on MSDN on Jun 05, 2015 I got a case recently where the customer had a SQL Alias setup but was having issues connecting to their application.
mssql-support
Sep 01, 2023 Place SQL Server Support Blog
4.2KViews
0likes
1Comment
Repeated login failures on an Azure SQL Virtual Machine
First published on MSDN on Mar 23, 2016 Lately, a user called in for support because he saw repeated failures like below, flooding the Windows event logs and errorlogs on Azure Virtual machines they have in their environment.
mssql-support
Jun 06, 2023 Place SQL Server Support Blog
1.3KViews
0likes
1Comment
How to get up and running with Oracle and Linked Servers
First published on MSDN on Jul 31, 2015 I have had more Linked Server cases that are setup for an Oracle database than any other non-SQL Server database in SQL.
mssql-support
May 25, 2023 Place SQL Server Support Blog
36KViews
2likes
2Comments