You can try out this solution. This code works even on sared hosting

http://dev-doc.blogspot.com/2012/08/ms-sql-2008-client-ip-address-on-shared.html