473,672 Members | 2,666 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 1624
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********@sat x.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
7075
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 machine? I assume, perhaps naively, that all the parts are there but I've spent several hours trying to grasp how to go about accessing the remote server. Specifically, I'm trying to create and populate databases on the remote server from...
10
3521
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 databases who would like to share their data using this visualization tool but do not want to import their data into the Oracle server back-end.
2
2222
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" still it gives error. I tried even giving the server name and directory like "\\server_name\\Directory\\file.log" still it gives file not found exception. Does anyone help me fix this. Thanks
5
1255
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 address. However, if I try to access the development machine from another client on the LAN then I fail to access the server. The IIS on the server is set for Anonymous Access. Any clues please? Regards
3
2967
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 impersonate; but it use PInvoke, which I don't like using personally any good solution? thanks!!!
0
1305
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 a novel file server that I get access to when I log into our network. All users have access to this file when they log into our network. When I run my program I keep getting an error saying 'Can't find part of the file path' Are there maybe...
1
1549
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 implemented their own replication process to ensure the 2 databases are in sync. However, there is no clustering with virtual IP addresses implemented. So to an external client/db, it is 2 identical databases with the same name on 2 distinct...
0
1122
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 data to be displayed in some of the webpages. However, I have another 2003 server set up as an intranet that uses MS Sharepoint as a way for scheduling, document storage, etc. what I want to be able to do his get some information from within...
4
4219
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 change that the application will be able to run on any other machine (using \\ syntax on the run command- not a problem) using the DB located on a static-different machine. for this purpose I need to create a Remote Connection from my
0
8423
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8948
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8852
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8701
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7482
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5725
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4447
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2098
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
1843
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.