Can’t connect to localhost on SQL Server Express 2012 / 2016

by

According to Aaron Bertand:

  1. You need to verify that the SQL Server service is running. You can do this by going to Start > Control Panel > Administrative Tools > Services, and checking that the service SQL Server (SQLEXPRESS) is running. If not, start it.

  2. While you’re in the services applet, also make sure that the service SQL Browser is started. If not, start it.

  3. You need to make sure that SQL Server is allowed to use TCP/IP or named pipes. You can turn these on by opening the SQL Server Configuration Manager in Start > Programs > Microsoft SQL Server 2012 > Configuration Tools (or SQL Server Configuration Manager), and make sure that TCP/IP and Named Pipes are enabled. If you don’t find the SQL Server Configuration Manager in the Start Menu you can launch the MMC snap-in manually. Check SQL Server Configuration Manager for the path to the snap-in according to your version.

    SQL Server Configuration Manager

  4. Verify your SQL Server connection authentication mode matches your connection string:

    • If you’re connecting using a username and password, you need to configure SQL Server to accept “SQL Server Authentication Mode”:

      -- YOU MUST RESTART YOUR SQL SERVER AFTER RUNNING THIS!
USE [master]
GO
DECLARE @SqlServerAndWindowsAuthenticationMode INT = 2;
EXEC xp_instance_regwrite
  N'HKEY_LOCAL_MACHINE',
  N'Software\Microsoft\MSSQLServer\MSSQLServer',
  N'LoginMode',
  REG_DWORD,
  @SqlServerAndWindowsAuthenticationMode;
GO
    • If you’re connecting using “Integrated Security=true” (Windows Mode), and this error only comes up when debugging in web applications, then you need to add the ApplicationPoolIdentity as a SQL Server login:

  5. otherwise, run Start -> Run -> Services.msc If so, is it running?

If it’s not running then

It sounds like you didn’t get everything installed. Launch the install file and chose the option “New installation or add features to an existing installation”. From there you should be able to make sure the database engine service gets installed.

More Related Contents:

  1. C# DateTime to “YYYYMMDDHHMMSS” format
  2. Factory method with DI and IoC
  3. How to stop C# console applications from closing automatically? [duplicate]
  4. Can anonymous class implement interface?
  5. How do I enable HTTP PUT and DELETE for ASP.NET MVC in IIS?
  6. Any faster way of copying arrays in C#?
  7. Must declare scalar variable @Id?
  8. LINQ join two DataTables
  9. How can I convert BitArray to single int?
  10. High quality JPEG compression with c#
  11. Usage of AppDomain in C#
  12. When should one use dynamic keyword in c# 4.0?
  13. Private inner classes in C# – why aren’t they used more often?
  14. Change File Extension Using C#
  15. Change color of text within a WinForms RichTextBox [duplicate]
  16. Error-Attempt by method ‘X.set_DbConnection(System.Data.Common.DbConnection)’ to access method ‘Y.get_Settings()’ failed
  17. How to Programmatically Scroll a Panel
  18. Global hotkeys in WPF working from every window
  19. How can I get Visual Studio 2008 Windows Forms designer to render a Form that implements an abstract base class?
  20. How do I test database-related code with NUnit?
  21. How do I find the position of a cursor in a text box? C#
  22. Model Binding to Enums in ASP.NET MVC 3
  23. Azure Function with AD auth results in 401 Unauthorized when using Bearer tokens
  24. Floating curly braces in C#
  25. How to change the port number for Asp.Net core app?
  26. Convert DateTime to long and also the other way around
  27. Converting a byte array to PNG/JPG [closed]
  28. How to deserialize object derived from Exception class using Json.net?
  29. C# moving the mouse around realistically
  30. Resharper: vars

Leave a Comment