Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL Server 2014 network-related error

Posted on 2016-09-22
6
47 Views
Last Modified: 2016-09-22
Don't know what happened with my computer.  I had issues with Visual Studio and SQL Server.  I reinstalled VIsual Studio and that resolved that issue.  I repaired SQL Server but i'm still having and issue with SQL server.

SQL
Any ideas?
0
Comment
Question by:CipherIS
  • 4
  • 2
6 Comments
 
LVL 1

Expert Comment

by:gaspan
ID: 41811743
I assume they are both on the same machine (Using Shared Memory)? Is SQL running (check under services) when you are getting this error?
0
 
LVL 1

Author Comment

by:CipherIS
ID: 41811749
When I click on "Connect to Database" and it tries to authenticate.
0
 
LVL 1

Author Comment

by:CipherIS
ID: 41811750
Under Services

Sql Server (computername)
sql server agent
sql server analyssis services
sql server browser
sql server distributed replay count
sql server distributed replay controller
sql server integration services 12.0
sql server reporting services
sql server vss writer
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 1

Accepted Solution

by:
gaspan earned 500 total points
ID: 41811755
Sorry, I just saw your list of services. Assume they are running.
The connection you are attempting is via Shared Memory. Have you tried another method like TCP/IP and the localhost (127.0.0.1,1433).

Here is a checklist for such problems (ignore that it for 2005, the issues are generic):
https://support.microsoft.com/en-us/kb/328306
0
 
LVL 1

Assisted Solution

by:CipherIS
CipherIS earned 0 total points
ID: 41811756
0
 
LVL 1

Author Closing Comment

by:CipherIS
ID: 41811758
It was stopped.  Needed to go to Configuration to check to see if it was running.  It wasn't.  Started it.  Have no idea how it stopped.
1

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

839 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