I'm having an issue with connecting to an MS SQL Server DB via ODBC, the model currently happily works with 2 different MySQL servers connected via ODBC but the MS SQL Server gives this error
I'm having an issue with connecting to an MS SQL Server DB via ODBC, the model currently happily works with 2 different MySQL servers connected via ODBC but the MS SQL Server gives this error
With authentication issues you can try different settings for the DSN , plus you could try using the non-native client driver. Are you passing login credentials, or are you using Windows Authentication, and if so have you configured the users rights to access SQL Server?
Googling the ODBC error code 28000 suggests that this is a login issue (as indicated by the error message itself). That search leads to many articles that you could search for further hints as to what is happening and how to fix it.
Without having a MS SQL Server installation to test with, my best guess is that there are settings when you create a data source that need to be set to appropriately connect to your server, and the server itself will need to have credentials set that the data source can use.
------
There are also some other items to be aware of when configuring a FlexSim <> ODBC <> DB setup. This may not be affecting you, but I'll mention it in case others searching the community need it.
5 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © Autodesk Inc. All rights reserved