Microsoft SQL 2008 on 4 applications

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
piaakitAsked:
Who is Participating?
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
Absolutely it can share 4 applications using a database for each application
0
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
afaik there is no limitations on how many applications can connect to a server.
0
 
piaakitAuthor Commented:
What about if I am using ms SQL 2008 R2 express, can I still use for 4 different applications ?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Paul JacksonSoftware EngineerCommented:
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
 
piaakitAuthor Commented:
Is the max database size for ms SQL 2008 R2 express is 10G ?
0
 
Paul JacksonConnect With a Mentor Software EngineerCommented:
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
 
piaakitAuthor Commented:
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
 
Paul JacksonSoftware EngineerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.