FormerMember

Database Setup error: unable to connect to the database; database specification is not valid

Posted By FormerMember

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!