INFORMATICS

I am trying to connect to a Microsoft SQL 2008 or another server which is not on port 1433. How do I indicate a different port number when connecting to the server using SQL Management Studio?

In SQL Server Configuration Manager. Go to Sql Native Client Configuration, Select Client Protocols, Right Click on TCP/IP and set your default port there.

to connect to sql, enter the server address and then enter the port number after the comma    SQLSERVER\InstanceName,portnumber   -    SQL\InstSQL, 1025

look for sql server processes and find port

netstat -a -b

When running a script like ./Test.ps1 the script is expected to be in the current working directory (.).

Depending on the environment from which you're executing that statement the working directory may not be what you expect, though.

Here are some commands that allow you to determine the current working directory when run the same way as your script:

$PWD.Path
(Get-Location).Path
(Resolve-Path '.').Path

There are basically 3 ways to deal with the issue:

• Specify the path to your PowerShell script relative to the current working directory.

• Change the current working directory to the location of the PowerShell script:

  Push-Location 'C:\temp\folder'
  .\Test.ps1
  Pop-Location

• Run the PowerShell script with its full path:

  & 'C:\temp\folder\Test.ps1'

  If the executable's filename, path, or pathname doesn't contain spaces, using the call (&) operator is optional. Otherwise, the call operator is required.