Query across two server with different logins

Posted on 2012-08-23
Last Modified: 2012-08-23
Wanting to see if anyone knew if it were possible to query across two servers with DIFFERENT logins?

One server is windows and the other has specific un/pw?

Right now, depending from where I execute, I get login failed.

(Linked Servers is not an option)
Question by:EricLynnWright
    LVL 13

    Accepted Solution

    LVL 3

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    upgrade Vcenter to V6 10 48
    Using Case  in sql queries 17 50
    Record open by another user 6 24
    Barracuda Bsckup Server 690 6 48
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now