EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB421981: "ServerName cannot be used with HostName, PortNumber, SID, or ServiceName" error message appears when testing an Oracle DSN in MicroStrategy Connectivity Wizard in MicroStrategy 9.x or 10.x


Community Admin

• Strategy


This article describes a potential root cause of the error message "ServerName cannot be used with HostName, PortNumber, SID, or ServiceName."

SYMPTOM:
When testing an Oracle DSN in Strategy Connectivity Wizard, users may see the following error message:
 

ka04W000000Oaj6QAC_0EM440000002HHH.png


ServerName cannot be used with HostName, PortNumber, SID, or ServiceName.

CAUSE:
This error message occurs when a user has information entered in "Standard Connection" and "TNSNames Connection".
 
ACTION:
When creating an Oracle DSN, the user must only enter information for either Standard Connection or TNSNames Connection, but not both.  If the user sees the error message when testing the connection from the Standard Connection screen, ensure that no information is entered in the TNSNames Connection screen.  Similarly, if the user sees the message when testing the connection from the TNSNames Connection screen, ensure that no information is entered in the Standard Connection screen. 

KB421981


Comment

0 comments

Details

Knowledge Article

Published:

June 12, 2017

Last Updated:

December 31, 2018