while SCCM 2002 installation , SQL instance error - Not taking SQL instance name

Vij 301 Reputation points
2020-10-06T13:04:24.353+00:00

30431-sql.png
Getting above error while entering SQL instance details.

Provided below details in SQL server. apart from below, any other things need to take care?

  1. Server Collection - SQL_Latin1_General_CP1_CI_AS
  2. SQL server memory (Min & Max) - 8192
  3. Named Pipes - enabled.
  4. TCP/IP port changed to - 1433

tried with firewall off & on mode and inbound & outbound has been created for the 4033 port

in the same server sql & SCCM installing.

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Simon Ren-MSFT 28,556 Reputation points Microsoft Vendor
    2020-10-07T07:22:46.953+00:00

    Hi,

    Thank you for coming Microsoft MECM Q&A forum.

    1.Please help check the ConfigMgrSetup.log located in C drive to see if there is any further information.

    2.Which user account do you use to install the SCCM? Have you added the user account to SQL server administrators?

    For more information, please refer to: Installing SQL Server 2012 For Configuration Manager 2012 R2

    Thanks for your time.

    Best regards,
    Simon


    If the response 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.

1 additional answer

Sort by: Most helpful
  1. Simon Ren-MSFT 28,556 Reputation points Microsoft Vendor
    2020-10-08T07:22:27.07+00:00

    Hi,

    Thanks for your reply.

    When we use a domain user account as the site installation account to sign in to the server where you run Configuration Manager setup and install a new site. This account requires the following rights:

    Administrator on the following servers:
    The site server
    Each server that hosts the site database
    Each instance of the SMS Provider for the site

    And sysadmin on the instance of SQL Server that hosts the site database

    Please help check if the permissions are met. For more information, please refer to: Accounts that Configuration Manager uses

    Thanks for your time.

    Best regards,
    Simon


    If the response 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.

    0 comments No comments