the problem has been solved.but the linked server created in one login canot seen on another login.why this is hapening

Thanks A lot

thanks yaar thanks a lot.its done

THANKS ITS TESTED SUCCESSFULLY.THE PROVIDER NEEDS TO BE REGISETRED THANKS GUYS

THANKS A LOT:-)

when i did this the linked server is created successfully,but when i test the connection

error is cmg as

test connection to linked server failed

the ole db provider "sql server" has not...

actually if we are crating a linked server eith script

EXEC sp_addlinkedserver 'Server1', N'SQL Server'

how u come toknow to which server in the network is geting connected ?we need to give...

Recovery mode is full and database is accesable .only thing i mising those transactioins.is it posible?\