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
What is log ldf?
List out the different types of locks available in sql server?
How can you control the amount of free space in your index pages?
How do you rename a table in sql server?
What is report snapshot?
What is the command to change the recovery model?
How to get the definition of a stored procedure back?
What do you understand by a view?
What is normalization of database?
What do you understand by a view? What does the with check option clause for a view do?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How to drop an existing stored procedure in ms sql server?
How can you tell if a database object is invalid?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Explain a checkpoint?