Solved

Microsoft SQL 2008 on 4 applications

Posted on 2014-04-10
8
213 Views
Last Modified: 2016-11-23
H all


       I have 4 application would like to install on the same window 2008 server, and 4 of the applications need to have SQL databases, just wonder if I install a MS SQL 2008 (not a express version),  can it share to all 4 applications ? If create 4 databases for each application ? The 4 applications is  what's up gold, solarwinds, enterprise security reporter from dell and ChangeAuditor from dell,

Keith
0
Comment
Question by:piaakit
  • 4
  • 3
8 Comments
 
LVL 29

Accepted Solution

by:
Paul Jackson earned 334 total points
Comment Utility
Absolutely it can share 4 applications using a database for each application
0
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 166 total points
Comment Utility
afaik there is no limitations on how many applications can connect to a server.
0
 

Author Comment

by:piaakit
Comment Utility
What about if I am using ms SQL 2008 R2 express, can I still use for 4 different applications ?
0
 
LVL 29

Expert Comment

by:Paul Jackson
Comment Utility
Yes no limit in express versions either, you are only limited by the resources of the server that the sql server is hosted on i.e. memory, cpu.
Impossible to know without load testing what those limits will be without load testing your applications and will depend on how many connections per application are expected during use.
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 

Author Comment

by:piaakit
Comment Utility
Is the max database size for ms SQL 2008 R2 express is 10G ?
0
 
LVL 29

Assisted Solution

by:Paul Jackson
Paul Jackson earned 334 total points
Comment Utility
Yes up to 10GB, be aware the cpu limit for express is 1 cpu and the memory limit is 1gb

see : http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.105).aspx
0
 

Author Comment

by:piaakit
Comment Utility
Just found out that the application I install do not support express version, I do need ms SQL 2008, just wonder there is no trial version for this right ?
0
 
LVL 29

Expert Comment

by:Paul Jackson
Comment Utility
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now