Solved

SQL Server status symbol not green

Posted on 2013-01-23
4
657 Views
Last Modified: 2013-04-29
Years ago I knew how to fix this one, but now I don't remember.  In SQL Server management studio, the symbol next to the name of the server and the agent would have a green triangle displayed.  Now in one server instance, it does not.  I remember the fix had to do with a protocol.
Can you tell me how to fix this?
0
Comment
Question by:Jack Seaman
  • 2
  • 2
4 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 38812207
0
 

Author Comment

by:Jack Seaman
ID: 38814622
I went to check if the firewal was running on this server, and got this message:
Windows Firewall cannot run because another program or service is running that might use the network address translation component (Ipnat.sys)

Also, Ive noticed that I cannot open up my mapped drive to that server.  I get " the specified network name is no longer available."
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 38814816
Is SQL Browser service running on that server? Is TCP\IP protocol enabled under Network Client Utility?
0
 

Author Comment

by:Jack Seaman
ID: 38815033
I've discovered what the real issue was with this server.  A few days ago, we had a city wide power failure and our backup UPS/generator failed too.  This server crashed and when it restarted 8 of the services did not restart among them were the server service and the computer browser service.  After I started them, the problems I was having seem to have corrected themselves.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Incremental load example 2 52
T-SQL to Update Table Dynamically 2 41
MS SQL order by with "over" statement and row_number() 11 39
CROSS APPLY 4 44
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now