Connect to SQL Server - error (SSMS)

Ahmad Safi 11 Reputation points
2022-09-22T19:22:36.93+00:00

Need help with the following error. i know nothing about SQL and wanted to install it for a beginer class that im about to take in two days; but now im facing this debacle...i dont have any server to connect to except maybe the local computer.

243993-screenshot-2022-09-22-121342.png

SQL Server Dev edition installation error
243972-devsql-error.png

SSMS connection error
i dont know if these two errors are connected....

i'd highly appreciate any assistance

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,364 questions
{count} votes

2 answers

Sort by: Most helpful
  1. NikoXu-msft 1,911 Reputation points
    2022-09-23T06:29:59.433+00:00

    Hi @AhmadSafi-7914 ,

    The error can be caused because SQL Server Analysis Services is not running.
    What I want to say is that it was due to the installation failure of your second diagram that caused your first error.
    Have you already install SQL Server on this computer? If yes - try uninstall this driver, and then install SQL Server again.
    If you are willing to share your error log, it will be more helpful to solve your issue, in the folder C:Program FilesMicrosoft SQL Server150Setup BootstrapLog.

    Best regards
    Niko

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".


  2. Ahmad Safi 11 Reputation points
    2022-09-23T08:19:15.52+00:00

    Hi @NikoXu-msft

    Here is the log you were asking. I hope this helps

    Overall summary:
    Final result: User canceled
    Exit code (Decimal): -2068380094
    Exit facility code: 1207
    Exit error code: 1602
    Exit message: User has canceled.
    Start time: 2022-09-23 01:06:48
    End time: 2022-09-23 01:07:19
    Requested action: Repair

    Machine Properties:
    Machine name: DA23ATAPP89LE823
    Machine processor count: 16
    OS version: Microsoft Windows 11 (10.0.2262198)
    OS service pack:
    OS region: 1
    OS language: English
    OS architecture: x64
    Process architecture: 64 Bit
    OS clustered: No

    Product features discovered:
    Product Instance Instance ID Feature Language Edition Version Clustered Configured
    SQL Server 2019 MSSQLSERVER MSSQL15.MSSQLSERVER Database Engine Services 1033 Developer Edition 15.0.2000.5 No Yes

    Package properties:
    Description: Microsoft SQL Server 2019
    ProductName: SQL Server 2019
    Type: RTM
    Version: 15
    SPLevel: 0
    Installation location: C:\SQL2019\Developer_ENU\x64\setup\
    Installation edition:

    User Input Settings:
    ACTION: Repair
    AGTDOMAINGROUP: <empty>
    AGTSVCACCOUNT: <empty>
    AGTSVCPASSWORD: <empty>
    AGTSVCSTARTUPTYPE: Manual
    ASCONFIGDIR: Config
    ASSVCACCOUNT: <empty>
    ASSVCPASSWORD: <empty>
    ASTELSVCACCT: <empty>
    ASTELSVCPASSWORD: <empty>
    ASTELSVCSTARTUPTYPE: 0
    CLTSTARTUPTYPE: 0
    CLTSVCACCOUNT: <empty>
    CLTSVCPASSWORD: <empty>
    CONFIGURATIONFILE:
    CTLRSTARTUPTYPE: 0
    CTLRSVCACCOUNT: <empty>
    CTLRSVCPASSWORD: <empty>
    ENU: true
    EXTSVCACCOUNT: <empty>
    EXTSVCPASSWORD: <empty>
    FAILOVERCLUSTERGROUP:
    FAILOVERCLUSTERNETWORKNAME: <empty>
    FTSVCACCOUNT: <empty>
    FTSVCPASSWORD: <empty>
    HELP: false
    IACCEPTPYTHONLICENSETERMS: false
    IACCEPTROPENLICENSETERMS: false
    IACKNOWLEDGEENTCALLIMITS: false
    INDICATEPROGRESS: false
    INSTANCENAME: <empty>
    ISMASTERSVCACCOUNT: NT AUTHORITY\Network Service
    ISMASTERSVCPASSWORD: <empty>
    ISMASTERSVCPORT: 8391
    ISMASTERSVCSSLCERTCN: <empty>
    ISMASTERSVCSTARTUPTYPE: Automatic
    ISMASTERSVCTHUMBPRINT: <empty>
    ISSVCACCOUNT: NT AUTHORITY\Network Service
    ISSVCPASSWORD: <empty>
    ISSVCSTARTUPTYPE: Automatic
    ISTELSVCACCT: <empty>
    ISTELSVCPASSWORD: <empty>
    ISTELSVCSTARTUPTYPE: 0
    ISWORKERSVCACCOUNT: NT AUTHORITY\Network Service
    ISWORKERSVCCERT: <empty>
    ISWORKERSVCMASTER: <empty>
    ISWORKERSVCPASSWORD: <empty>
    ISWORKERSVCSTARTUPTYPE: Automatic
    MRCACHEDIRECTORY:
    QUIET: false
    QUIETSIMPLE: false
    SQLSVCACCOUNT: <empty>
    SQLSVCPASSWORD: <empty>
    SQLTELSVCACCT: <empty>
    SQLTELSVCPASSWORD: <empty>
    SQLTELSVCSTARTUPTYPE: 0
    SUPPRESSPAIDEDITIONNOTICE: false
    SUPPRESSPRIVACYSTATEMENTNOTICE: false
    UIMODE: Normal
    X86: false

    Configuration file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220923_010647\ConfigurationFile.ini

    Rules with failures or warnings:

    Rules report file: C:\Program Files\Microsoft SQL Server\150\Setup Bootstrap\Log\20220923_010647\SystemConfigurationCheck_Report.htm

    Exception summary:
    The following is an exception stack listing the exceptions in outermost to innermost order
    Inner exceptions are being indented

    Exception type: Microsoft.SqlServer.Chainer.Infrastructure.CancelException
    Message:
    User has canceled.
    HResult : 0x84b70642
    FacilityCode : 1207 (4b7)
    ErrorCode : 1602 (0642)
    Stack:
    at Microsoft.SqlServer.Configuration.UIExtension.Request.Wait()
    at Microsoft.SqlServer.Configuration.UIExtension.UserInterfaceProxy.SubmitAndWait(Request request)
    at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.<>c__DisplayClass2_0.<ExecuteActionWithRetryHelper>b__0()
    at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.ExecuteActionHelper(ActionWorker workerDelegate)