Local instance of SQL Server 2012 is missing

Asked

Viewed 755 times

0

I installed SQL Server 2012 with SQL Server Manager to interact with the database.

I logged in locally, saw db master. I disconnected (I don’t remember if I restarted the machine) but I went in again giving this error. Someone knows how to solve?

Cannot connect to MATRIX SQLSERVER.

ADDITIONAL INFORMATION:

Instance-specific or network error when connecting to SQL Server. The server was not found or not accessible. Check that the instance name is correct and that SQL Server is configured to allow remote connections. (Preview: SQL Network Interfaces, error: 26 - Server Locate Error/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

sql-server-2012

  • The service is running?

  • I try to log into the server, in the combo to choose the servers and log in to the browser for more (it does not appear here) and have window database Engine-> expand it-> ae inside has server design with name -> MY SQLEXPRESS When I click on the above error , see if you are running the service?

  • Check in SQL Server Configuration Manager. It is an icon of a red case that should be in your start menu.

1 answer

-1

I found the same problem in SQL Server 2019. The way I solved the problem was in the server name, put only the computer name. In your case it would just: Server name: MATRIX

Browser other questions tagged sql-server-2012

You are not signed in. Login or sign up in order to post.