Saturday, February 25, 2012

can't open an .msc file to monitor SQL server on another machine

I need to be able to monitor our SQL server's performance on a new machine
but simply copying the .msc file I use to this machine and trying to open it
isn't working. I get this error message:
MMC cannot open the selected file
If it matters, the problelm machine is Windows 2000 and mine is XP.
I thought that I might need to just open MMC and create a new .msc but it's
been so long I can't really remember how to do it at all!
Need some help here...
Paul
That is not how Enterprise Manager work. You need to install the client tools on the client machine
where you want to run Enterprise Manager. You then, on that client machine, register the SQL Servers
you want to work against.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
>I need to be able to monitor our SQL server's performance on a new machine
> but simply copying the .msc file I use to this machine and trying to open it
> isn't working. I get this error message:
> MMC cannot open the selected file
> If it matters, the problelm machine is Windows 2000 and mine is XP.
> I thought that I might need to just open MMC and create a new .msc but it's
> been so long I can't really remember how to do it at all!
> Need some help here...
> Paul
>
|||Already did that.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> That is not how Enterprise Manager work. You need to install the client
tools on the client machine
> where you want to run Enterprise Manager. You then, on that client
machine, register the SQL Servers
> you want to work against.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
machine[vbcol=seagreen]
open it[vbcol=seagreen]
it's
>
|||Then why the need to transfer the msc file? What purpose would that serve? Perhaps I'm
misunderstanding what you want to achieve?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Already did that.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23GDi90rkFHA.320@.TK2MSFTNGP09.phx.gbl...
> tools on the client machine
> machine, register the SQL Servers
> news:uRmbagrkFHA.2920@.TK2MSFTNGP14.phx.gbl...
> machine
> open it
> it's
>
|||I have a monitor that graphs SQL Server access methods, processor time, disk
access, and some other stuff in real time through MMC. It's useful to see
what's happening at a glance.
I solved it, though. I needed to manually add the ActiveX control "System
Monitor Control", and I have recreate everything - SQL Server access
methods, system stats, etc (which was a pain). I guess in this case saved
MSC files are not designed to be portable.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Then why the need to transfer the msc file? What purpose would that serve?
Perhaps I'm
> misunderstanding what you want to achieve?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul" <noone@.executespammers.org> wrote in message
news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
in[vbcol=seagreen]
but
>
|||I see, you are talking about performance monitor, not Enterprise Manager. Sorry, I haven't used
perfmon enough to know whether the msc file is portable and if so between which OS versions etc.
Consider posting this to a windows group (as perfmon is a windows tool) if the need arises again.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul" <noone@.executespammers.org> wrote in message news:%23dLuD1skFHA.576@.tk2msftngp13.phx.gbl...
>I have a monitor that graphs SQL Server access methods, processor time, disk
> access, and some other stuff in real time through MMC. It's useful to see
> what's happening at a glance.
> I solved it, though. I needed to manually add the ActiveX control "System
> Monitor Control", and I have recreate everything - SQL Server access
> methods, system stats, etc (which was a pain). I guess in this case saved
> MSC files are not designed to be portable.
> Paul
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23jckIiskFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Perhaps I'm
> news:e5al0QskFHA.3960@.TK2MSFTNGP12.phx.gbl...
> in
> but
>

No comments:

Post a Comment