Interested to Buy Any Domain ? << Click Here >> for more details...
From where can you change the default port?
- 3 Answers
- 6996 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / javed shaikh
HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE
SERVER
1. Open the Microsoft SQL Server Enterprise Manager.
2. Right-click on your server instance (you may have
to expand the server groups).
3. Choose Properties.
4. Under the General tab, click the button
labeled "Network Configuration". The SQL Server Network
Utility will be displayed.
5. On the right, under the Enabled Protocols, you
should see TCP/IP. Select it and hit the Properties button.
6. 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 SQL Server listens on. Make the change and hit OK to
close the dialog.
7. Hit Apply on the SQL Server Network Utility screen,
then OK.
8. The system will tell you that the changes are
saved, but that they will not take effect until you stop
and restart the SQL Server service. Hit OK.
9. Hit OK to close the Properties dialog.
10. Right-click on your server instance again, and
choose to stop the SQL Server service.
11. Once it has stopped, right-click and choose to
start the SQL Server service. Restarting it will now use
the new port.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / guest
From the Network Utility TCP/IP properties ?> Port
number.both on client and the server.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Can a cursor be updated? If yes, how you can protect which columns are updated?
Name three of the features managed by the surface area configuration tool? : sql server security
What is indexed view? How to create it?
What do you mean by the term 'normalization'?
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?
what is call by value & call by reference ?
What are explicit and implicit transactions?
What is transcation?Plz give One example?
How many levels of sp nesting are possible?
What is the difference between osql and query analyzer?
How can your resolve deadlocks?
4 Answers IBM, IMS, Iron Mountain, NuWare,
How to change location of errorlog in SQL?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
