Solved

Correct connection string to remote server

Posted on 2006-07-06
3
208 Views
Last Modified: 2010-04-16
I know this is a very simple question, but I can't seem to find the answer.

I have a program running on machine A, which contains a MS SQL Server database.  I have another machine, machine B, running the same program.  I want to have machine B access the database on machine A.  What do I replace the Server=(local) with in the connection string?

Thanks for your help in advance.
0
Comment
Question by:rmmarsh
3 Comments
 
LVL 96

Accepted Solution

by:
Bob Learned earned 500 total points
ID: 17051370
The machine name or IP address.

Bob
0
 
LVL 28

Expert Comment

by:2266180
ID: 17051379
I don't know about that Server thing, but in my connection strings I use "data source" with the machine name (as refered from the workgroup/domain)
0
 

Author Comment

by:rmmarsh
ID: 17051607
Thank you... that's what I thought it was, but wasn't sure.
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# Offline Apllication 5 70
Web Form VB.Net  import CSV 4 36
Service Controller 1 23
updating order of the rows, N+1 query issue, C#, asp.net, MVC, SQL Server 3 25
Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
Article by: Ivo
C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

776 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