https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505891#M19982 <P><A href="https://www.google.com/search?q=odbc+28000+error">Googling the ODBC error code 28000</A> suggests that this is a login issue (as indicated by the error message itself). That search leads to <A rel="noopener noreferrer" href="https://support.microsoft.com/en-us/kb/555332" target="_blank">many</A> <A href="http://dba.stackexchange.com/questions/29992/odbc-data-source-sql-server-connection-login-failed-for-user">articles</A> that <A href="https://support.microsoft.com/en-us/kb/2121736">you could search</A> for further hints as to what is happening and how to fix it.</P><P>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.</P><P>------</P><P>There are also some other items to be aware of when configuring a FlexSim &lt;&gt; ODBC &lt;&gt; DB setup. This may not be affecting you, but I'll mention it in case others searching the community need it.</P><UL><LI>Make sure that your ODBC driver architecture (32- or 64-bit) matches your FlexSim installation.</LI></UL><UL><LI>The ODBC driver needs to be compatible with your database software. Its possible that if the ODBC driver is 64-bit, it may not be able to talk to a 32-bit database application. See the following articles for related information specifically for MS SQL Server:<UL><LI><A rel="noopener noreferrer" href="https://msdn.microsoft.com/en-us/library/cc645931.aspx" target="_blank">Data Source Names and 64-bit Operating Systems</A></LI><LI><A rel="noopener noreferrer" href="https://www.mssqltips.com/sqlservertip/2498/create-a-32bit-dsn-on-64bit-machine-for-sql-server/" target="_blank">Create a 32-bit DSN on 64-bit machine for SQL Server</A></LI><LI><A rel="noopener noreferrer" href="http://stackoverflow.com/questions/1954128/how-do-i-connect-to-my-64-bit-sql-server-with-odbc" target="_blank">How do I connect to my 64-bit SQL Server with ODBC?</A></LI><LI><A rel="noopener noreferrer" href="http://stackoverflow.com/questions/1134827/how-do-i-use-a-32-bit-odbc-driver-on-64-bit-server-2008-when-the-installer-doesn" target="_blank">How do I use a 32-bit ODBC driver on a 64-bit Server 2008 when the installer doesn't create a standard DSN?</A></LI><LI>That isn't an exhaustive list, but it's a starting point if this seems to be affecting you</LI></UL></LI></UL> Thu, 28 Jul 2016 18:15:03 GMT Ben_WilsonADSK 2016-07-28T18:15:03Z https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505889#M19980 <P><I>[ FlexSim 16.1.0 ]</I></P><P>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</P> <P><span class="lia-inline-image-display-wrapper" image-alt="1558-capture.png"><img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1493884i8F8948B18AFF6519/image-size/large?v=v2&amp;px=999" role="button" title="1558-capture.png" alt="1558-capture.png" /></span></P> Thu, 28 Jul 2016 10:50:35 GMT https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505889#M19980 michael_smith4 2016-07-28T10:50:35Z https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505890#M19981 <P>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?</P> Thu, 28 Jul 2016 17:39:07 GMT https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505890#M19981 jason_lightfoot_adsk 2016-07-28T17:39:07Z https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505891#M19982 <P><A href="https://www.google.com/search?q=odbc+28000+error">Googling the ODBC error code 28000</A> suggests that this is a login issue (as indicated by the error message itself). That search leads to <A rel="noopener noreferrer" href="https://support.microsoft.com/en-us/kb/555332" target="_blank">many</A> <A href="http://dba.stackexchange.com/questions/29992/odbc-data-source-sql-server-connection-login-failed-for-user">articles</A> that <A href="https://support.microsoft.com/en-us/kb/2121736">you could search</A> for further hints as to what is happening and how to fix it.</P><P>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.</P><P>------</P><P>There are also some other items to be aware of when configuring a FlexSim &lt;&gt; ODBC &lt;&gt; DB setup. This may not be affecting you, but I'll mention it in case others searching the community need it.</P><UL><LI>Make sure that your ODBC driver architecture (32- or 64-bit) matches your FlexSim installation.</LI></UL><UL><LI>The ODBC driver needs to be compatible with your database software. Its possible that if the ODBC driver is 64-bit, it may not be able to talk to a 32-bit database application. See the following articles for related information specifically for MS SQL Server:<UL><LI><A rel="noopener noreferrer" href="https://msdn.microsoft.com/en-us/library/cc645931.aspx" target="_blank">Data Source Names and 64-bit Operating Systems</A></LI><LI><A rel="noopener noreferrer" href="https://www.mssqltips.com/sqlservertip/2498/create-a-32bit-dsn-on-64bit-machine-for-sql-server/" target="_blank">Create a 32-bit DSN on 64-bit machine for SQL Server</A></LI><LI><A rel="noopener noreferrer" href="http://stackoverflow.com/questions/1954128/how-do-i-connect-to-my-64-bit-sql-server-with-odbc" target="_blank">How do I connect to my 64-bit SQL Server with ODBC?</A></LI><LI><A rel="noopener noreferrer" href="http://stackoverflow.com/questions/1134827/how-do-i-use-a-32-bit-odbc-driver-on-64-bit-server-2008-when-the-installer-doesn" target="_blank">How do I use a 32-bit ODBC driver on a 64-bit Server 2008 when the installer doesn't create a standard DSN?</A></LI><LI>That isn't an exhaustive list, but it's a starting point if this seems to be affecting you</LI></UL></LI></UL> Thu, 28 Jul 2016 18:15:03 GMT https://forums.autodesk.com/t5/flexsim-forum/sql-server-connection-over-odbc/m-p/13505891#M19982 Ben_WilsonADSK 2016-07-28T18:15:03Z