Skutten
August 16th, 2005, 09:37 AM
Ok so currently we have to set our firewall to low otherwise MS SQL Manager is blocked when trying to export stuff. Anyone know the port used for this program?
MishY
August 16th, 2005, 12:49 PM
I haven't used their software but the standard MSSQL port is 1433
Have just had a look on the SQL Manager website and see that you can change the standard port their software uses:
Q:
I can access my server via an alternative port. I have searched for a setting in MS SQL Manager to alter the connection port, but have not yet been able to locate this. How would I go about altering this port?
A:
To connect to server on alternative port you can do the following:
Run SQL Server Client Network Utility (WINDOWS\\SYSTEM32\\cliconfig.exe) on client computer where MS SQL Manager runs.
Go to the second (Alias) tab of the Utility.
Add a new server alias and set server name, port number and TCP/IP as Network library.
Use the server alias name as host name on Database Registration Info dialog of MS SQL Manager.