Monday, January 11, 2021

Install SSMA/No SQL Server instance was found on this machine

Error : No SQL Server instance was found on this machine. Please try after installing an SQL Server instance.

Scenario : This error faced while installing SSMA on machine.

Correct Step to Install ( Below step are for oracle SSMA):

Download installer from link (click here) "https://www.microsoft.com/en-us/download/details.aspx?id=54258"

Download File - SSMAforOracle_x.xx.x.msi
Download File - SSMAforOracleExtensionPack_x.xx.x.msi

STEP 1
  • Install SSMAforOracle_x.xx.x.msi on your computer/machine (after double click)
  • Accept Agreements
  • Click on "Typical" type installation 
  • Click on "install" button

STEP 2
  • Double click on SSMAforOracleExtensionPack_x.xx.x.msi
  • Accept Agreements
  • Click on "Typical" type installation 
  • Click On "Install" Button
  • Installation will finish, allow for any permission if it asked
  • Popup will visible on screen after few seconds, you can see 2 option on screen
    • Local instance (chose this option if SQL Server Engine is installed on local computer)
    •   Remote instance ( Chose this option if SQL Server Engine is installed on remote machine, cloud, network computer)
  • Add connection details (Hostname, port, username, password)
  • Click check box "Trust server Certificate", if "Remote instance" option is selected
  • on next Screen default option is selected " Install Untilities Database .....", Click on next 
  • Let the installtion complete, after that you will be ready to use

Why error was occured : User was selecting option "Local Instance" while installation, however SQL Server engine was installed on remote machine

No comments:

Post a Comment

web stats