Solved

SQL Server can be started but not accessed

Posted on 2016-11-28
1
12 Views
Last Modified: 2016-11-28
Hi experts
i am reading about: If SQL Server can be started but not accessed
what's the mean?
.Check for network-related issues
.Try to access SQL Server via the DAC
0
Comment
Question by:enrique_aeo
1 Comment
 
LVL 10

Accepted Solution

by:
Ray earned 500 total points
Comment Utility
.Check for network-related issues
this means to check things like firewall preventing access from another machine.  If working on the same server as the sql installation, then this is likely not a troubleshooting step you will need to do.

.Try to access SQL Server via the DAC
DAC means dedicated administrator connection.
For more information see this brief article   https://www.brentozar.com/archive/2011/08/dedicated-admin-connection-why-want-when-need-how-tell-whos-using/
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

10 Experts available now in Live!

Get 1:1 Help Now