Accessing SQL Server Databases from Networked PC

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Jim Richards

    Accessing SQL Server Databases from Networked PC

    Hello all. I have just built another PC (New PC)and have it connected to my
    Original PC via a LAN. I have my SQL Server 2000 installed on the Original
    PC. Both PCs use WinXP Pro OS. I believe I now have to install the Client
    Tools on the New PC but after that, how do I access the SQL Server that is
    on the Original PC. The SQL Server is setup with mixed (both Windows
    Authentication and SQL Server Authentication) . Just how do I use the SQL
    Query Analyzer that I just installed on the New PC to connect to and
    retreive data from the SQL Databases which are on the Original PC? Thanks
    in advance for any help, Jim.


  • Jim Richards

    #2
    Re: Accessing SQL Server Databases from Networked PC

    Hello all. Dissregard this request for assistance as I was able to figure it
    out. I can now connect the New PC to the SQL Server in the Original PC,
    write my query and the results are displayed on the New PC over the Network.
    Have a good day. Jim.

    "Jim Richards" <JWRichards@sat x.rr.com> wrote in message
    news:RGoOd.3825 9$uA.22293@fe1. texas.rr.com...[color=blue]
    > Hello all. I have just built another PC (New PC)and have it connected to
    > my Original PC via a LAN. I have my SQL Server 2000 installed on the
    > Original PC. Both PCs use WinXP Pro OS. I believe I now have to install
    > the Client Tools on the New PC but after that, how do I access the SQL
    > Server that is on the Original PC. The SQL Server is setup with mixed
    > (both Windows Authentication and SQL Server Authentication) . Just how do I
    > use the SQL Query Analyzer that I just installed on the New PC to connect
    > to and retreive data from the SQL Databases which are on the Original PC?
    > Thanks in advance for any help, Jim.
    >[/color]


    Comment

    Working...