[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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
0
piaakit
Asked:
piaakit
  • 4
  • 3
3 Solutions
 
Paul JacksonSoftware EngineerCommented:
Absolutely it can share 4 applications using a database for each application
0
 
Jim HornMicrosoft 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
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
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 JacksonSoftware 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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now