Whao, it works finally with localhost

Thanks all for your help and time.

Don't worry by data I bring about server or connections all local and prepared for this try.

Thanks again

Julio

here u have

select * FROM OPENROWSET('MSDASQL', 'DRIVER={SQL Server};SERVER=192.168.145.14;UID=greenadmin;PWD=kakariki', take2.dbo.greenlight_students)

I'm got this error:

Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access this provider through a linked server.

Arvind and Every body thanks for your help but I will more specific.

I have a table (tableA) in the database A this table, needs to be update every day with...

The tables are in the same server but the user can't have grant to select. I need to log as a diferent user but I don't know how to do...