SQLTeam.com | Weblogs | Forums

Restore Instance for SQL Server 2014


#1

Hi,
I have been running the SQL Server 2014 ctp2 for test. During an Upgrade to 2014 Enterprise, something went wrong and I lost Reference to my instance (MSSQLSERVER2014).

  1. I can see it in the listing of optional instances in Sever Managment Studio.

  2. When trying to Connect I get:
    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)

  3. When inspecting the instance folder I can see that I'm missing folders like Binn, Install, Backup.

  4. My database files look fine.

Help is very much appreciated.

Rgs,
/Kjell


#2

have you checked your database engine is configured to accept remote connections?