| Author |
Topic |
|
shanepj
Starting Member
4 Posts |
 Posted - 2004-08-18 : 16:27:54
|
| I have a need at my company to be able to run two instances of Enterprise manager on one system. I need to make one that only shows production systems and one that shows test systems. I know I can create groups inside of Enterprise manager and group the systems under That way. But that is not working and the request is to run two instances. Any ideas would be appreciated.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 16:51:37
|
| I think you are confused about what two instances means. Two instances means that you will actually have two instances of SQL Server installed and not of Enterprise Manager. Enterprise Manager is just a tool to see things. It is not what makes SQL Server. You need to install an additional instance of SQL Server by running SQL Server setup again and giving the named instance a name.Tara |
 |
|
|
shanepj
Starting Member
4 Posts |
Posted - 2004-08-18 : 17:20:13
|
| No I actually did not have a better definition/Described it poorly. I am trying to run enterprise manager on a workstation to manage our servers. When I add and delete servers out of the console. The changes show up on any enterprise manager Console I run from that workstation. I need to be able to open up to seperate consoles on my workstation and have them display different servers. This is just the Enterprise manager console running on a workstation. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 17:22:21
|
| That is not possible.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-18 : 18:34:20
|
| Right click on Microsoft SQL Servers and create New SQL Server Group. Call one prod and one dev. When you open up your two EM windows expand prod in one and dev on the other.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 18:37:08
|
| Derrick, I think you missed the point of that not being a solution for them.Tara |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-18 : 18:50:43
|
| I think I do. I think it's a ridiculous request though. You name one group prod, one group test, one group dev. They each point to their own databases. If anyone that doesn't have access to prod logs in on that computer, they won't be able to access anything anyway.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-18 : 18:51:54
|
| Agreed.Tara |
|
|
|
shanepj
Starting Member
4 Posts |
Posted - 2004-08-19 : 11:01:46
|
| I agree that just making the groups should be enough. However the Managementin my organization wants sometething else. I at least can tell them that expert opinion and the ALMIGHTY "Best Practices" say use groups. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-19 : 13:12:58
|
| :) Tell them they're stupid. If they want that functionality they can pay you or me to write a custom tool for them.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-19 : 14:39:55
|
That's why he's the MeanOldDBA!  But seriously, management just needs to be educated about how the EM console works.Tara |
|
|
|
|
Seperate instances of Enterprse manager