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 are the basic functions for master, msdb, model, tempdb databases?
What is equi join with example?
What are views in ms sql server?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is the sql case statement used for?
What are security principals used in sql server 2005?
What is triggers and stored procedures?
How do you make a trace?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is multi-statement table-value user-defined function?
What is a trigger in sql server?
Mention the uses of stored procedures.
what is a correlated sub-query? : Sql server database administration
How can we use ConnectorJ JDBC Driver with MS SQL?
