[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Correct connection string to remote server

Posted on 2006-07-06
3
Medium Priority
?
218 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 2000 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

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

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

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month18 days, 2 hours left to enroll

830 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