Hello Everyone, I am currently learning Sage 300 2019 and have download the latest student limited edition of the software along with the SQL Server Management Studio 2017.
I did manage to install all the software and setup the database as seen on the textbook Using Sage 300 by 2017 Christine A. Heaney.
After I setup the database in SQL Server Management Studio, for two database OMNDAT and OMSYS
First time I setup I used Windows authentication with default user name and no password, since it didn't work in the Database Setup. I did again and this time using SQL Server Authentication with recommended login: sa and password: Sage300
I don't know if it is the password issue, but I keep getting "Unable to connect to database; database specification is not valid."
Can anyone help me out?
Thank you so much in advance!