UPK: When Installing UPK MultiUser the MSSQL Server is Not Available in List and is Not Available in Browse

(Doc ID 2413538.1)

Last updated on JULY 02, 2018

Applies to:

User Productivity Kit - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Server

UPK Database scripts were run in advance of the installation. When selecting, "yeses, scripts have been run" the MSSQL server does not appear in the drop down list.
Trying to manually enter the MSSQL Server name results in an error message.

ERROR
-----------------------
An error occurred while trying to connect to the server.

DBMSSON: There was an error logging in to the Microsoft SQL Server.
Error: DBNETLIB (Connection Open) (Connect). Specificed SQL server not found.

DBNMPNTW: There was an error logging into the Microsoft SQL server.
Error: DBNETLIB (Connection Open) (Connect) SQL Server does not exist or access denied.


Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms