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?

Thanks
Mike

Exactly what lights are you referring to? Do you mean the Icon in SSMS? If
so this really isn't something you should be relying on to tell the status
of a given SQL Instance. There are apparently many factors that determine if
the status can be checked and is updated. Even on my local copy of SSMS it
doesn't show the status as running on my local instance even though I know
for a fact it is. I believe it also has a lot to do with account privileges,
especially between different domains. I don't even know what the polling
timing is but I think it is pretty high. If you are counting on this for
anything real time you are only setting yourself up for trouble.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"The Other Mike" <mdunlap (AT) nospam (DOT) com> wrote

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

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Andrew J. Kelly (sqlmvpnooospam (AT) shadhawk (DOT) com) writes:
Au contraîre, the default poll interval is far too short. Some years
ago, I was wondering what was hammering my hard disk every now and then
and set out with a quest with Diskmon, and I was surprised to find that
SSMS was the culprit. I then found a Connect item by Razvan Socol, and
the resolution was to change a registry value to reduce the poll interval.

I don't remember the exact numbers, but I think the default was something
like five seconds.


--
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

The Other Mike (mdunlap (AT) nospam (DOT) com) writes:
Your Windows account would need to have the appropriate permissions on
that server. (No, I don't know exactly which.)

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

Ten seconds.

http://connect.microsoft.com/SQL/fee...edbackID=24736
7

I thought the same thing. I just assumed he meant something other than the
traditional replication we are used to talking about. But then again, I
can't imagine how anything programmatic would care about the little status
icons in SSMS, as those are just visual candy.

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...edbackID=41844
4

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

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

Aaron Bertrand (moc.liamg (AT) dnartreb (DOT) noraa) writes:
Ah, that was the Connect item I had in mind. Thanks, Aaron!


--
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