Share via

I have downloaded sql server 18.9.2 version and trying to connect to local host server. But unable to connect.

Sania Fatimi 21 Reputation points
2021-07-28T11:28:55.127+00:00

HI All,

I have downloaded sql server 18.9.2 version and trying to connect to local host server. But unable to connect. I tried to check if my MSSQL is in running state. But unable to do so, as I am unable to find the "Tools/Binn" ; in c drive - C:\Program Files\Microsoft SQL Server\110\Tools\Binn\

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,841 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,642 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2021-07-29T03:33:49.373+00:00

    Hi SaniaFatimi-2246,

    Welcome to Microsoft Q&A.
    Have you installed SQL Server?
    If you have installed SQL Server, please go to SQL Server Configuration Manager or Services in your machine to check if the instance is running. In SQL Server Configuration Manager, on the left pane, click SQL Server Services. The right pane lists several services that are related to SQL Server. If the Database Engine is installed, the Database Engine service is listed as SQL Server (MSSQLSERVER) if it is the default instance; or SQL Server (<instance_name>), if the Database Engine is installed as a named instance. Please refer to Determine Whether the Database Engine Is Installed and Started which might help.

    118868-image.png

    In addition, please share us the detailed error message which is located at Program Files\Microsoft SQL Server\MSSQL1x.\ MSSQL\Log\ERRORLOG.

    If you have not installed SQL Server, please download and install it first. You can download it from here.
    And here is a tutorial about SQL Server installation which might help.
    If you have any question, please feel free to let us know.

    Best Regards,
    Amelia

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dan Guzman 9,236 Reputation points
    2021-07-28T11:49:45.313+00:00

    I have downloaded sql server 18.9.2 version

    18.9.2 is a SQL Server Management Studio version. SSMS is only a client tool and does not include the SQL Server database engine. You need to separately install SQL Server, such as the Developer or Express edition for local development

    1 person found this answer helpful.
    0 comments
  2. Frank Kamara 1 Reputation point
    2021-07-29T20:53:25.17+00:00

    Thank you, this worked for me.

    0 comments

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.