Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Sql Server 2014 - Update to windows 10 and can't connect to the Local Server

Tags:

sql-server

server

sql-server-2014

Recently I updated my Windows from 8 to 10 and suddenly my SQL Server 2014 stopped working. When I open the Management Studio and try to connect to the Server (local) i obtain the following error:

Obtained Message

Does any of you had similar problems? Before updating the Windows everything was running just fine.

like image 513
Tiago Neto Avatar asked Aug 15 '15 15:08

Tiago Neto

People also ask

Can't connect to local SQL Server?

Check the TCP/IP and Named Pipes protocols and port. Open SQL Server Configuration Manager and check the SQL Server Network Configuration protocols. You should enable Named Pipes and TCP/IP protocol. For the TCP/IP protocol, right click and select properties to check the TCP/IP communication port as well.

Does Windows 10 support SQL Server 2014?

SQL Server 2014 Express can be installed on Windows 10/ Windows 8.1/ Windows 7. These steps are almost similar for any SQL Server Express edition installation on any Windows OS.

How do I fix Windows could not start the SQL Server on local computer?

Right-click "SQL Server (NUCLEUS)" service and select "Properties." In the "SQL Server (NUCLEUS) Properties" Window, click on the "Log On" tab. In the "Log On" tab, select "Local System account" and then click "Ok"(Note: If this option is grayed out you will need to run services. msc as an administrator).

Which version of SQL Server is compatible with Windows 10?

The Hardware and Software Requirements page for SQL 2016 confirms that SQL Server 2016 Developer edition is supported on Windows 10 Professional.

1 Answers

I had the same problem after upgrading from Windows 8.1 Pro to Windows 10 Pro. I was able to resolve it as follow:

  1. Control Panel
  2. Administrative Tools
  3. Services
  4. The SQL Service Browser was Disabled
  5. Right click and select Properties
  6. Change the Startup type to Automatic (Delayed Start)
  7. Click to Start button to start the service
  8. And off you go. This should resolve the issue.
like image 155
DrJoe Avatar answered Sep 17 '22 12:09

DrJoe
Sign in to Comment

Related questions

Select values from multiple columns into single column
create function must be the only statement in the batch
How do I implement a password Reset Link
Pivot Table and Concatenate Columns
Cannot resolve the collation conflict between "SQL_Latin1_General_Pref_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation
Select Distinct for 2 columns in SQL query
LINQ to Entities and null strings
Where do I find Sql Server metadata for column datatypes?
SQL Server, "Invalid column name" error when inserting into Excel "linked server"
How can I execute a .sql from C#?
performance difference between User Defined Function and Stored Procedures
Order by clause with Union in Sql Server
How to get last char in a string in sql server
Windows API call "RegGetValueW" returned error code: 0
OBJECT_ID of object in another database - how to find database ID or name/fully qualified object name?
Getting the Return Value from JDBC MSSQL
Interpreting type codes in sys.objects in SQL Server
How do I auto-increment a column in my table?
alias not working on sql server 2008 r2
Convert mssql datetime object to PHP string

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!