connect to another server from a stored proc

I have a stored proc that receives the connection string detials like servername, dbname, tablename,userid, pwd as parameters. how do i connect to that particular database on that server with the userid and pwd details ?

thanks
D.found my answer..used OPENDATASOURCE.

thanks for anyone that tried.

Confused with FQDNs

Hi NG,
if i call a report with
http://servername/report everything works fine.
If i call the report with
http://servername.domain.com/report the report failed because he couldn't
find the datasource to the olap-cube.
I use win-auth on iis.
Any suggests?
FrankFrank Matthiesen wrote:
> Any suggests?
Solved...
frank