Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iceblizzard
Starting Member
17 Posts |
 Posted - 2007-01-08 : 00:32:06
|
| Hello SQL Gurus,Just some sort of ques on what to do. See, if I have 2 computers, e.g PC1 and PC2. Now if I installed SQL Server 2005 in PC1 and I want PC2 to access SQL Server in PC1, what am I going to do? Well, I asked this since we used only 1 DB and it is in PC1, now when we run our system in PC2, all records that is coming from PC2 will be stored to PC1 SQL Server DB. Please Help....! Thanx!-------------------Real Programmer dont documentIf its hard to write Thenits easy to undertand.End If |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-08 : 00:40:52
|
| Use Linked Server.Peter LarssonHelsingborg, Sweden |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-01-08 : 00:44:22
|
if you just want to execute some queries by hand, install the SQL Server 2005 client tools (SSMS and friends) on PC2. then you can connect to any sql server 2000 or 2005 instance on the network, including PC1. There's a free version called SSMS Express you can get here: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796if you want to connect to the PC1 instance from app code, then you have a choice of many code libraries that support connections to sql server, such as SqlClient in the .net framework. which one you choose depends on the technology you use to write your app (managed code, native code, java, etc).EDIT: i get it now. after reading Peso's reply i think i misunderstood your question. 
www.elsasoft.org |
|
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-08 : 00:45:55
|
quote:
Originally posted by iceblizzard
Hello SQL Gurus, Now if I installed SQL Server 2005 in PC1 and I want PC2 to access SQL Server in PC1, -------------------Real Programmer dont documentIf its hard to write Thenits easy to undertand.End If
I thinks what he need is he want to access PC1 from PC2. he need to install workstation components which comes with SQL 2005 and use SQL Management Studio to access PC1 from PC2.Madhu |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-08 : 02:44:51
|
| Alternatively if you APPLICATION is running on PC2 it just needs a connection to PC1 to be able to retreive the data that it needs.Kristen |
|
|
|
|
|
|
|
|
How To Do This...Please