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 the use of stored procedure?
How to find table changes in sql server?
Who is the owner of a schema in ms sql server?
What is the default schema of your login session in ms sql server?
What are the differences between union, intersect, and minus operators?
Explain how to integrate the ssrs reports in application?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
What new data source types were added in ssrs 2014?
Explain about Normalization?
What does it mean to normalize data?
Write SQL queries on Self Join and Inner Join.
what is difference between view and Dip.
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is RMS migrations?
Explain differences between web edition and business edition?