Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

connect to DB via SQL Mgr Express

question folks, anyone have a write up on connecting to the Eminentware DB? our SCOM engineer is indicating that the DB is alerting OUT OF SPACE...so our DBAs went proactive on me and tried to increase the DB Size and received a exceed your licensed limit of 4096 MB per DB...Bueller?!

Find more posts tagged with

Accepted answers

All comments

solarwinds-admin

SQL Server 2005 Express Edition has a maximum database size of 4GB.

If the database is not corrupted as a result of being out-of-space, the options are:

In-place upgrade to SQL Server 2008 R2 Express Edition, which will increase the max database size to 10GB.
Upgrade the Extension Pack to v1.7SP1 and migrate the database to a remote SQL Server running Standard Edition (or greater).

solarwinds-admin

so the new extension pack now is supported on remote SQL servers? that's good...do you have a link to the upgrade...i only see the demo...or do you want me to open a case and have support send me the info?

solarwinds-admin

If you opt to choose the first option, here are instructions for upgrade from SQL 2005 Express to SQL 2008R2 Express:

Download SQL2008R2 Express installation file (32-bit or 64-bit, depending on your needs) from here: http://www.microsoft.com/express/Database
Close EminentWare
Stop the ‘EminentWare Data Grid Service’ service
Open the installation file for SQL Express 2008R2
Choose the option during the install to upgrade from “SQL server 2000, SQL Server 2005 or SQL Server 2008”.

After the install, you’ll need to run a couple of installs to restore some EminentWare prerequisite files that were overwritten:

Microsoft SQL 2005 Native Client [ x64 | x86 ]
Microsoft SQL Server 2005 Management Objects Collection [ x64 | x86 ]

After those are installed, you can restart the EminentWare Data Grid Service and launch the EminentWare console.

solarwinds-admin

The newest update (1.71.201.0 at the time of this writing) is available on our Product Downloads page. To apply it you'd want to close any open Consoles, apply the Update Only patch to your EminentWare PAS (Primary Application Server), then to any additional server Roles you may have running, then to any remote Consoles you may have.