quesstion: How to Verify Connection Information to Microsoft SQL Server using SQLCMD? When you are trying to connect a MS SQL server, if the incorrect information is specified, the following error can occur during database creation or migration: Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [1231]. A simple […]
MS SQL
How to Change the Port Used by an MS SQL Server
Question: How to determine or configure the port used by a Microsoft SQL Server database instance? How to make the port number of a Microsoft SQL Server database instance static versus dynamic? Verify the TCP/IP Port Used by a MS SQL Server Instance 1. From the Microsoft SQL Server database server, launch the SQL Server […]