Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between a stored procedure and a user defined function?
Determine when to use stored procedure to complete sql server tasks?
Why are you getting errors when creating a new odbc dsn?
Can binary strings be converted into numeric or float data types?
can a table be moved to different filegroup? : Sql server administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is 1nf 2nf?
What is the purpose of sql profiler in sql server? : sql server database administration
What are transactions and its controls?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is the difference in accessing db between sql server vs sql azure?
Tell me what is sql profiler?
What is the default schema of your login session in ms sql server?
What are the differences between ms sql server & oracle?
What does it mean to be in union?
