Connection issue to DB

Peter_1985 2,546 Reputation points
2023-10-12T09:32:43.9733333+00:00

Hi,

I connected to "\my.re.al.ip\schema_name" from the client PC and got the following. What to be enabled on the server?

User's image

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,852 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 102.2K Reputation points MVP
    2023-10-12T21:23:20.75+00:00

    The error message means that the application was not able to find the SQL Server instance you specified. There can be a number of reasons for that:

    • The server and/or instance name is misspelled.
    • The server is not running.
    • There is a firewall blocking the way.
    • The server is not enabled for remote connections.

    And the list goes on. Since we don't your environment we cannot say exactly what is wrong, but only suggest troubleshooting. This document can be helpful.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 41,006 Reputation points
    2023-10-12T10:00:23.47+00:00

    "\my.re.al.ip\schema_name"

    With a slash at the beginning of the server name? That's wrong, also "\schema_name" remove it and use only the IP address.