I am using SQL Server 2008. I have to access our company portal database which is maintained by a third party.
They had given me login details. Please explain how to connect to their database. I can't post the link here
You should be able to use the linked servers feature for this.
It is used to:
Configure a linked server to enable the SQL Server Database Engine to execute commands against OLE DB data sources outside of the instance of SQL Server.