We help IT Professionals succeed at work.

Two databases two sign-ins

154 Views
Last Modified: 2010-03-19
If I have a database on one server that I log in with windows authentification and have tables on another server where I have a secured log on and password, my question is will I be able to use the tables from the secured database in a stored procedure in the unsecured database?
Comment
Watch Question

Yes.

You just create a linked server and hard code the login details into it.

Linked server are pretty slow though.

Look up sp_addlinkedserver


Author

Commented:
Is that the only way??  And are you saying if I don't then I cannot use the tables in the secured database if I am in the unsecured database?
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:

You can also use the OPENQUERY, OPENDATASOURCE or OPENROWSET functions to open tables or file that are not on your current server.>>>>>>> It still has to be a linke server - correct?
OPENQUERY is the only one that actually uses a previously defined linked server name.

The other two do not use a previously defined linked server name. They use the same mechanism anyway though.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.