SQL Error 26

Babak Bemani 1 Reputation point

Hello everyone,
Using Sage300 app online from Seneca College and SQL Management 2014 installed on my laptop! Last week connected perfectly and did an assignment! This week I can connect to Sage online App, but when I start SQL Management it says Error26 can not connect to database! We input the path of database manually as: Mylaptopname/sqlserverexpress. I didn’t do any changes since last week so please help me to solve my problem! Thank you in advance for your time.

SQL Server on Azure Virtual Machines
Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,256 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 38,861 Reputation points


    It has to be a backslash = \, not a slash = /
    And in common the default instance name is SQLEXPRESS, not sqlserverexpress. So try it with

    1 person found this answer helpful.

  2. Erland Sommarskog 98,811 Reputation points

    That error means that SSMS was not able to find the SQL Server instance BabakAsus\SQLExpress. There can be any number of reasons for this. The server and/or instance name is misspelled, SQL Server is not running, there is a firewall blocking the connection. Just to name a few of the possibilities.

    Here is a link to a troubleshooter for this error: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine

    0 comments No comments