Two programs with separate SQL Databases

25 pts.
Tags:
Database
SQL
SQL Database
I have one program that uses an SQL database and I want to install a different program that also uses an SQL database on the same machine. Will this cause a problem? Why or why not?

Answer Wiki

Thanks. We'll let you know when a new response is added.

It is possible to run two different programs which use a sql database on thesame machine, yes. My question would be are you sure you have enough resources on that machine to handle the load? Also, do you have enough disk space for both? It would also be helpful to know what version of sql you are using.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Will the database servers run on that machine, or those applications are just clients connecting to remote databases ?
    69,835 pointsBadges:
    report
  • Cstanley
    I use SQL Server 8.0. We created a named service so that other applications of SQL Server could coexist under a separate service. Is this legit?
    25 pointsBadges:
    report
  • Cstanley
    It's on the same machine
    25 pointsBadges:
    report
  • carlosdl
    8.0 is sql 2000 right ? So you have the default instance, and a named instance. Yes, that is ok. You could have only one default insntace, but many named instances on the same machine, as long as resources are enough.
    69,835 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following