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

sql-server server sql-server-2014
Tiago Neto picture Tiago Neto · Aug 15, 2015 · Viewed 25.4k times · Source

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.

Answer

DrJoe picture DrJoe · Aug 25, 2015

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.

Related questions

Unable to install/run SQL Server driver in WildFly 10

I am running my application on a WildFly 10 server. I do not wish to place my connection details on my application src codes thus am trying to place it inside WildFly 10 server itself. However I am facing issues. Under [WILDFLY_…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More