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