This article helps you resolve the problem that occurs when you use a protocol other than TCP/IP to connect to SQL Server on a port other than 1433.
Original product version: Visual C#
Original KB number: 307645
Symptoms
When you use a protocol other than Transmission Control Protocol/Internet Protocol (TCP/IP), SqlConnection.Open fails if you specify a port number other than 1433 to connect to an instance of SQL Server.
Resolution
To resolve this problem, use TCP/IP protocol, and include Server=ComputerName, PortNumber in the connection string.
Steps to reproduce the behavior
-
Start Visual Studio .NET.
-
Create a new Visual C# .NET Console Application project.
-
Make sure that your project contains a reference to the
System.Datanamespace, and add a reference to this namespace if it does not. -
Use the using statement on the
System,System.Data,System.Data.SqlClientnamespaces so that you are not required to qualify declarations in those namespaces later in your code.using System; using System.Data; using System.Data.SqlClient; -
Visual Studio creates a static class and an empty
Mainprocedure by default. Copy the following code, and paste it in the Code window:[!NOTE] You must change the
User ID<username>value and the password `` value to the correct values before you run this code. Make sure thatUser IDhas the appropriate permissions to perform this operation on the database.class Class1 { static void Main(string[] args) { string sConnectionString; sConnectionString = "User ID=<username>;Password =<strong password>;Initial Catalog=pubs;Data Source=myServer,1200"; SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); SqlDataAdapter daAuthors = new SqlDataAdapter("Select * From Authors", objConn); DataSet dsPubs = new DataSet("Pubs"); daAuthors.FillSchema(dsPubs, SchemaType.Source, "Authors"); daAuthors.Fill(dsPubs, "Authors"); daAuthors.MissingSchemaAction = MissingSchemaAction.AddWithKey; daAuthors.Fill(dsPubs, "Authors"); DataTable tblAuthors; tblAuthors = dsPubs.Tables["Authors"]; foreach (DataRow drCurrent in tblAuthors.Rows) { Console.WriteLine("{0} {1}", drCurrent["au_fname"].ToString(), drCurrent["au_lname"].ToString()); } Console.ReadLine(); } } -
Modify the
sConnectionStringstring as appropriate for your environment. -
Save your project.
-
On the Debug menu, click Start, and run your project to connect to the database.
Source: Microsoft Learn / IT Pro troubleshooting by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.
