SQL Error 26

Babak Bemani 1 Reputation point
2022-07-09T19:23:36.937+00:00

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.
Babak/Fariba

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
    2022-07-11T05:42:28.523+00:00

    Mylaptopname**/sqlserverexpress**

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

    1 person found this answer helpful.

  2. Erland Sommarskog 98,811 Reputation points
    2022-07-11T21:11:15.627+00:00

    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