Thursday, January 31, 2008

Change the port on which Microsoft Sql Server Express Edition

When I was trying database connectivity with java..
In the connection string I used the default port number 1433 since i had not changed anty default settings while installing the server.But that gave me theexception:

Exception:"DataSource Not found"

So i tried to find out on which port server was running but since i donno why on earth ,netstat was not showing sqlserver.exe as an active process even when it was visible in task manager.

Therefore the need to change the port arised....

Steps to change the port:

1.First make sure that TCP is enabled for the server(read my earlier post)
2.Open programs>SQLServer 2005>SQLServerConfigurationManager.
3.On the left pane click network configurations>protocols
4.on the right pane ,right click on Tcp
5.Select properties
6.Select IpAddress tab.
7.In IPAll pane enter any port no in the textbox next to TCP Port.

No comments: