473,513 Members | 2,291 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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.
Jul 23 '05 #1
1 1617
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" <JW********@satx.rr.com> wrote in message
news:RG******************@fe1.texas.rr.com...
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.

Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
7065
by: Douglas Harber | last post by:
If I have DB2 8.1 (FP5, I believe, but not relevant to my question...I hope) installed on my desktop, do I have what I need to connect to a remote DB2 server (also running 8.1 FP5) from my desktop...
10
3492
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
2
2213
by: Raja | last post by:
I am trying to access files in a remote server from my ASP.NET application, it is giving System.IO.FileNotFoundException error. I tried mapping that server location like "H:\ErrorLogs\error.log"...
5
1251
by: gemel | last post by:
I have a wireless networked peer-to-peer LAN and I can access web pages on the Internet. I have a development platform for ASP and I can access all pages on this machine by using the localhost...
3
2953
by: Baron | last post by:
an asp.net page on Machine A is trying to access files on several machines of different domains.. any 'good' method to do it without mapping drive in prior..... i've read something called...
0
1292
by: brian | last post by:
I am using the System.IO.Directory.GetDirectories class to do some file searching work. I am trying to access a networked drive from my local computer. The networked drive is actually located on...
1
1535
by: G.Fink.Nottle | last post by:
Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has...
0
1115
landy
by: landy | last post by:
Hi all! Here is my issue - I have a linux box set up as the server for the external webpage for my organization using apache/PHP to write the pages. I also use MySQL on this box for storing...
4
4200
by: Noy B | last post by:
Hi, I have developed a small application that is using a MSAccess DB. the problem is that it was developed on a machine where the application and the DB are both located. now it needs to be...
0
7177
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7394
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7559
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7542
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5701
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5100
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4756
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
811
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
470
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.