How to specify a port number in SQL Server connection string?

by

Use a comma to specify a port number with SQL Server:

mycomputer.test.xxx.com,1234

It’s not necessary to specify an instance name when specifying the port.

Lots more examples at http://www.connectionstrings.com/. It’s saved me a few times.

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. Export from SQL Server to Excel
  3. hide/remove header and footer
  4. How do I generate a random number for each row in a T-SQL select?
  5. Auto increment primary key in SQL Server Management Studio 2012
  6. SQL Server Linked Server Example Query
  7. Combine multiple results in a subquery into a single comma-separated value
  8. Infinite loop CTE with OPTION (maxrecursion 0)
  9. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  10. SQL Server: SELECT only the rows with MAX(DATE)
  11. Floor a date in SQL server
  12. PIVOT in sql 2005
  13. Atomic UPSERT in SQL Server 2005
  14. LEN function not including trailing spaces in SQL Server
  15. How FOR XML PATH(”) works when concatenating rows
  16. How to view transaction logs in SQL Server 2008 [closed]
  17. Scheduled run of stored procedure on SQL server
  18. SQL Server ORDER BY date and nulls last
  19. SSRS 2014 report deploy issue
  20. Best way to implement an audit trail in SQL Server?
  21. Set start value for column with autoincrement
  22. tsql returning a table from a function or store procedure
  23. How to update primary key
  24. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  25. Making an Entity Framework Model span multiple databases
  26. SQL Server 2008 Row Insert and Update timestamps
  27. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  28. SQL SERVER – Understanding how MIN(text) works
  29. How to convert text column to datetime in SQL
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment