Connect to other Server without SA role

Hi Guys,

I need to connect to other sQL Server in other server machine.

But there is security policy in the company that doesn't allow us to use:
linked server method.

I'm thinking about using opendatasource method, but the problem is to use opendatasource we need to have Server Role as Sysadmin. And it's also now allowed.

Is there any method or function that doesn't require sysadmin nor linked server?

Please help. Thanks.
softblessAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AmmarRCommented:
to connect to a sql server you dont need linked server nor sysadmin

all you need to have is a valid login in the sql server thats is in at the public group of the server.

using sql management studio you can connect to it.

and for transferring data you can use the import export wizards
---

but if your aim is to  Select from Databases on Multiple MSSql Servers, then linked server is your solution.

and regarding opendatasource

there are few configurations that you ned to make but for permission issues, Any user can execute OPENDATASOURCE. The permissions that are used to connect to the remote server are determined from the connection string.

more details
http://msdn.microsoft.com/en-us/library/ms179856.aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
softblessAuthor Commented:
thanx
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.