MS SQL Server Management studion Express 2008 r2 connection with Liferay 6.2

Hi
First brief description
1) I am using Liferay 6.2.
2) I want to connect with MS SQL Server Management Studio Express 2008 r2 (This is similar to MS SQL Server but with  lots of limitations).

Error: That I got was
IOExcpetion: refuse to connect.


Now the solution is
1) Configuration of MS SQL Server connection in portal-ext.properties file

   

      jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver

      jdbc.default.url=jdbc:jtds:sqlserver://localhost:1433/lportal

      jdbc.default.username=sa (this is default login name )

      jdbc.default.password=your password

    
The main thing is we have to change the port of tcp/ip to 1433 the default port of MS SQL Server Management Studio Express 2008 r2.
Start menu of windows then

 

1. MS SQL Server 2008 r2 -> configuration tool -> SQL Server configuration manager -> yes(pop up)

  then on extreme left select there is a tree structure then

2. SQL Server network configuration -> Protocols for sql server -> rt click on tcp/ip and enable it

3. Double click on tcp/ip then one pop up will display

4. Select IP Adrees tab, lots of IPAdress block you can see and inside this block you can see one label IP Address value having different values. You have to check which IP Adress having value 127.0.0.1 then change its tcp port value to 1433.

5. Some time tcp port is not enable so please enable and also makes ip4 and all ip tcp port value

is 1433(default port of sql server express 2008 r2).

Hence try to connect, this time this will work.
Thanks
asif aftab