Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

From where can you change the default port?

Question Posted / javed shaikh

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


Please Help Members By Posting Answers For Below Questions

How do I trace a query in sql server?

900

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2157

How to sort the query output with order by clauses in ms sql server?

983

What is difference between materialized view and view?

877

When is the use of update_statistics command?

950

Is the primary key column of a table an index in ms sql server?

918

What is the process of normalization?

1054

Explain the commands in sql server?

967

What are the new features in sql server 2016?

929

What is command parameter in ssrs?

153

What are trace flags and mention a few common trace flags used with sql server?

1036

Why I am getting this error when dropping a database in ms sql server?

1021

What is the difference between clustered index and primary key?

869

What is the user of Primary key?

922

What are sql servers used for?

980