2005 status lights

#11

Aaron Bertrand (moc.liamg (AT) dnartreb (DOT) noraa) writes:

Quote:

Anyway it is not getting any better, as there is even less control over
this in 2008 SSMS starting with SP1.

http://connect.microsoft.com/SQL/fee...dbackID=418444

For what it is worth, I am able to control services on a remote computer
(well, a VM running in the same physical machine) from SSMS 2008 SP1.

I would assume that this has to do with Windows permissions. If you don't
have sufficient rights in Windows on the remote SQL Server box, you cannot of course not control the server. Furthermore Windows must permit services
to be controlled and monitored remotely. I don't know if this configurable
at all, but it seems conceivable.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#12

Interesting. We just started having a problem with file replication.

"Chris Wood" <anonymous (AT) microsoft (DOT) com> wrote

Quote:

The other Mike,

This is a WMI permissions problem. I will try and look thru my notes to
see what we had to do when we went to SQL2005.

Chris

"The Other Mike" <mdunlap (AT) nospam (DOT) com> wrote in message
news:esaK9K%23JKHA.3632 (AT) TK2MSFTNGP05 (DOT) phx.gbl...
Sorry. Replication is working without the status lights. I forgot to
add the windows account to SQL server for permissions.

I'm still confused as to why my SQL 2000 servers can see each other where
my 2005 can not.

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote in message
news:Xns9C74EF0A639B2Yazorman (AT) 127 (DOT) 0.0.1...
The Other Mike (mdunlap (AT) nospam (DOT) com) writes:
I recently had to rebuild a SQL 2005 server in Domain A. I can not see
the green status light from another Sql 2005 server in Domain B. I
have
2 Sql 2000 servers in these domains and the status lights are visible.
Any server that wanted to see the status lights has to be a domain
controller. Any ideas on how to get the lights back on?

Your Windows account would need to have the appropriate permissions on
that server. (No, I don't know exactly which.)

Yes. The Icon in SSMS. Without them, I cannot replicate.

What do you mean? You need the status lights in Registered Serves
to be able to run Replication? I haven't tried, but it sounds a little
difficult to believe.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

2005 status lights

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup

Re: 2005 status lights - 08-29-2009 , 07:30 AM

Re: 2005 status lights - 08-31-2009 , 08:02 AM