From where can you change the default port?

Answer Posted / javed shaikh

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE
CLIENT
1. Close the ILLiad Client and any Administrative
tools (Customization Manager, User Manager, etc.).
2. On each ILLiad Client machine, go to the ILLiad
program group and open the Client Network Utility under the
Networking folder.
3. On the right, under the Enabled Protocols, you
should see TCP/IP. Select it and hit the Properties button.
4. The Network Protocol Default Value Setup dialog
will ask for the Default Port for SQL Server (it will most
likely be 1433). Changing this entry will change the port
that ILLiad connects to on the ILLiad/SQL Server.
5. Change the entry and hit OK to close.
6. Hit OK to close and save the changes

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to create trigger on views?

547


What number aggregate functions are accessible there in sql?

592


List out some of the requirements to set up a sql server failover cluster?

547


Can we use pragma autonomous_transaction in trigger?

543


What are translations and its use? : sql server analysis services, ssas

606






what is package and it uses and how can u call a package

1562


What are sp_configure commands and set commands?

564


Is it true that rules do not apply to data already existing in a database at the time the rule is created?

563


how to control the amount of free space in your index pages? : Sql server database administration

599


Define views.

595


Can We Use Data-grids For Our Report In Ssrs?

147


How much space does sql server 2016 take?

569


Explain what is the difference between a local and a global temporary table?

516


How to select an exiting database using mssql_select_db()?

509


Can we insert data if clustered index is disabled?

510