LANSA WEB and MS SQL setup

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
kno_dk
Posts: 221
Joined: Tue Feb 23, 2016 12:00 am

LANSA WEB and MS SQL setup

Post by kno_dk »

HI

We have a LANSA WEB POC project for one of our customers. They are running an ERP system from Microsoft (C5).

The C5 Database is running in an MS SQL Server named LANSADEV\SQLS19L15 and the database is name C5SQLDB.

I have installed LANSA V15 (EPC150050) on the same MS SQL server, but it is named LANSADEV\LANSAC5 and the database is named LANSAC5

I am able to import the C5 tables into the LANSA IDE as an “Other” tables by pointing to the ODBC pointing to the CSQLDB, but when I run the WEB application it is not able to get any data and it fails.
How can I point from my LANSA WEB application running in the LANSADEV\LANSAC5 to get data from the C5SQLDB on the LANSADEV\SQLS19L15 ? Should I use the BIF - DEFINE_DB_SERVER
Or can I do something in the settings of the LANSA WEB?

Thanks

/klaus
Top
User avatar
Dino
Posts: 477
Joined: Fri Jul 19, 2019 7:49 am
Location: Robbinsville, NC
Contact:
Contact Dino

Re: LANSA WEB and MS SQL setup

Post by Dino »

Hi klaus, check if your default user that you use in the web administrator or your lansa iis configuration, it's also authorized to the other database in sql. Check the errors. Notice the lansa_users group authorized to your primary database
Top
Post Reply

Return to “Questions & Answers”