question

Ksenia F avatar image
0 Likes"
Ksenia F asked Jeanette F commented

error while connecting the database

Hello! When working with a database, the connector fails to connect to the MS SQL Server database. Throws an error, I can't figure out the reason for this error. Perhaps you have already come across in your experience with a similar one and can help me, otherwise, excuse the bother, if this question is not for you.

FlexSim 21.0.1
databaseflexsim 21.0.1
error1.jpg (57.3 KiB)
· 3
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Searching online I saw that in one case the server was set to "Windows Authentication Mode" only and it was resolved by setting it to "SQL Server and Windows Authentication mode"

Also - you can try making the connection and database import in Excel and then copy the connection string you see in Excel to the connector field's "Full Connection String".

0 Likes 0 ·
Ksenia F avatar image Ksenia F Jason Lightfoot ♦♦ commented ·

@jason.lightfoot Thanks for the help! I have already tried to solve the problem in this way and unfortunately it did not help. I understand that this question is not entirely for you, I just assumed that you might have come across you earlier.

I'll try your option!

0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Ksenia F,

Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond with a comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

0 Likes 0 ·

0 Answers