Share via

Could not find when connecting to data source

Xiaowen Dong 100 Reputation points
2023-03-22T06:16:02.6133333+00:00

I downloaded SQL server 2019, SSRS 2019, and report builder. After simple configuration according to the official document, I open the report builder to prepare the report. But when I created the embedded data source, I couldn't find a server name to connect to. Not even if refreshed. Can you tell me what the solution is?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,911 questions
0 comments
Accepted answer
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-03-22T07:11:43.2766667+00:00

    Hi @Xiaowen Dong

    As Olaf says, you can enter your server name directly. If you don't know your server name, you can use the statement "select @@servername" in SSMS.

    But in general, when you create a connection string, clicking the drop-down will automatically pop up the connectable server name. I guess you mean that? You can check your Sql server configuration manager. Make sure that everything except the sql server agent is starting.

    7

    Best regards.

    Aniya

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 44,136 Reputation points
    2023-03-22T06:31:05.0366667+00:00

    I couldn't find a server name to connect to

    Find, why find and where? Simply enter the server name.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.