sql server default ports

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:

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 2005ASP.net monitor server sql server free spaceSql server cpu utilisation

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.
 

I'm Satalaj.