Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL Server status symbol not green

Posted on 2013-01-23
4
Medium Priority
?
676 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 40

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 40

Accepted Solution

by:
lcohan earned 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

577 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