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

How does Report Builder support Analysis Services cubes?

136


What do you mean by SQL injection attack?

796


What are the features of Embedded SQL

855


What will happen if a column containing char type data is changed to the nchar data type?

797


explain different types of joins? : Sql server database administration

704






Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

806


How to find tables without indexes?

778


Does a server store data?

669


Is t sql the same as sql server?

728


What is the use of for clause?

768


what are the types of indexes? : Sql server database administration

791


What is sql server database?

668


What is use of attributehierarchyenabled? : sql server analysis services, ssas

794


What is de-normalization in sql database administration? Give examples?

713


how many triggers you can have on a table? : Sql server database administration

702