DB engine green/red status not displaying

Question

Post reply

DB engine green/red status not displaying

dharper3

SSCrazy

Points: 2361
More actions
March 29, 2006 at 1:55 am

#167667

Hi all, I have a problem geting Management studio to display the green or red status in the registered databases icon.

All remote sql servers just display a white circle. A locally running sql express instance displays fine. I am guessing its a domain / authentication issue but no idea what. Also what protocol / port is the indicator info talking over as it may be that?

I have a valid windows authenticated trust to the remote servers and can connect to all of them from Management Studio so not a remote connectivity issue. Tried starting the Browser service but no difference.

Any ideas would be appreciated as I have drawn a blank on this one.

Derek

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

jonathanv SSC Enthusiast Points: 185 More actions · Answer 1

jonathanv

SSC Enthusiast

Points: 185

March 30, 2006 at 4:16 am

#629768

The network protocols are configured? Without them, no network access are authorized.

Jonathan

Ted Smith SSC Veteran Points: 205 More actions · Answer 2

Ted Smith

SSC Veteran

Points: 205

March 30, 2006 at 8:32 am

#629879

I'm having this issue also over the network and I cannot find anything on what might be causing this.. I can ping the servers OK from my local machine. Guess I will keep searching for a soultion.

Scott Coleman One Orange Chip Points: 27451 More actions · Answer 3

Did you create new registrations in SMS, or use "Previously Registered Servers" to pull in old EM definitions?

I haven't found the old "Display SQL Server state in console" option in SMS, but the EM registrations I pulled into SMS do show the red/green status.

If you create registrations through SQL-DMO, the "Display State" option is an undocumented bit in the RegisteredServer.PersistFlags property. It may also be in SMO, in the RegisteredServer.UserData property (I don't know, I haven't looked). Some enterprising individual may want to come up with SMO code to create server registrations with "Display State" on.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 4

Check to make sure that TCP port 445 is open (not being blocked by a network firewall or the Windows firewall) in both directions between the client and server machines. You can accomplish this with a quick telnet test. Open up a cmd window and enter: telnet computername|ip address 445. If you do not recieve an error message the session is established and the port is open. You will have to do this twice. Once from the server to the client and once from the client to the server.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

dharper3 SSCrazy Points: 2361 More actions · Answer 5

Thanks all for responses.

1. Yes network protocols are enabled, I am able to connect via Management studio all other functionality exists.

2. I created new registrations for all 2005 instances but imported all my 2000 registrations. None display the status indicator, only a locally running sql express (2005) instance has correct status.

3. Tried the port 445 test and this may be the issue. I can connect from my desktop to the servers running sql server (which is being done over a vpn) but I cannot go back the other way from server to my desktop. Hmmm of into the merry land of VPN and firewalls both at customers end and my end.

So Rudy, you pretty sure this port is the answer before I wade into it from this angle.?

Derek

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 6

Yes. I had the same situation while back in working through a firewall with the default rule set of "DENY ALL". We used Ethereal (a network sniffing tool that's free) to confirm things. Also if you like I can give you a more complete list of ports tha I found out through testing.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."