Troubleshooting
Problem
An organization deploys SPSS Modeler (Client +Server) in their Windows® environment. They have a specific user (let's call them
User1) who's a data scientist that manipulates data and build models. This user has access to connect to Modeler Server. Because they simply import data into Modeler, the User1 user does not have direct access to the SQL Server database instance. They then have to use a different credential to log in to SQL Server (let's call this dbUser1).The current observation is that Modeler connects to Server with
User1 but when Modeler makes the database connection, it still uses User1 and not dbUser1 that was specified in the Database SOURCE node.Symptom
User cannot connect to the db despite using the right credentials in the Database source node.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"ARM Category":[{"code":"a8m500000008hzbAAA","label":"Modeler-\u003EODBC"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"18.2.1;18.2.2"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM SPSS Modeler
Component:
Modeler->ODBC
Software version:
18.2.1, 18.2.2
Document number:
6433223
Modified date:
09 April 2021
UID
ibm16433223
Manage My Notification Subscriptions