2 NPM servers use 1 instance of SQL 2005?

I am planning on changing a current server setup to accommodate an expansion in my network. The plan is to install NPM and NetFlow on a new physical server (already in place) and have it connect to an existing physical SQL server. This change is required due to it currently being run on a virtual machine on an ESX with limited remaining resources. The virtual machine install needs to stay operational throughout the process of installing and configuring the new NPM. I want to accomplish this without adding another instance of SQL 2005 in order to utilize the existing database. Is this possible or will there be conflicts inside of SQL if two NPM installs are accessing it simultaneously?

Find more posts tagged with

Install

installation

sql

sql_2005

npm

sql_2005_database

Accepted answers

Questionario

I dont think the same database will work, same instance should be fine as long as the resources are there.

However you can just run the config wizard on the new machine until you are ready to switch over so you can shutdown the old server and then connect the new one

All comments

Questionario

I dont think the same database will work, same instance should be fine as long as the resources are there.

However you can just run the config wizard on the new machine until you are ready to switch over so you can shutdown the old server and then connect the new one

bshopp

Questionario is right, you cannot have two Orions using the same DB at the same time.

njoylif

you can have two SEPARATE DATABASES with different NAMES (i.e. NetPerfMon, and NetPerfMonExpansion) on the same SQL server, they just can NOT talk to the same DB.