sql server default ports

sql server default portsMS SQL server shutdowngodaddy hosting MS SQL server configurationasp net image uploadclient server communicationbackup sql databasesql server agent backupThe shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005sql server free spaceASP.net monitor server Sql server cpu utilisationMS SQL server service packAsp.net Interview Questions for 2 years or 3 years experianceMS SQL server mirroring remove end points master keyOLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactionsConnection PoolingMS SQL server Transaction commit rollbackOLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this sessionMS SQL server 2005 attach databse without ldf fileAsp.net Create Folder On ServerHow to set default browserGridview select emailLinq to SqlAsp.net delete file file on Server C#.net and VB.net codecliconfgUnable To Connect To The Remote ServerServerTransfer vs ResponseRedirecttransactionaspnet development server failed to start listening on portms sql slowIIS backup Disaster action plan
sql server default ports kick it on DotNetKicks.com

 SQL server default instance listen on port number 1433. You can tell SQL server not to listen on this port and listen to another port.

Open SQL server configuration manager, find your instance and follow below steps as shown in figure. MS SQL server default port is 1433.



 
   After changing the default port settings you need to restart the instance.

To let your application talk to sql server on updated port, you need to do little modification at connection string (server=IPaddress,port number)

e.g.
 
 connectionString = "server=192.168.1.1,1477;user=sa;password=pass;database=aspnetdb"

If you want not alter your application configuration settings stored inside web.config file or in application itself,
you need to reroute the trafic from 1433 to update port 1477 using Sql server client network utility (Cliconfg)
you can refer http://www.revenmerchantservices.com/post/2010/01/05/cliconfg.aspx

Execute Netstat -an command from command prompt to know how communication is set betwwen your server and client

Satalaj


 



 

Tags:

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
Satalaj More+

I'm Satalaj.