Solved

SQL Server can be started but not accessed

Posted on 2016-11-28
1
27 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
ID: 41904862
.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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

803 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