sage 300 2017 not opening on workstations

[cjuimtu]

Hi All

I have installed MS SQL and Sage 3000 2017 on windows server 2012 R2 successfully.I can open the app and access the database successfully on the server
The problem comes when I try to open the app on the Workstations
The app opens sucessfully on the workstation but when I try to to login I get the error " "Cannot access database (error=49153)".
keeping in mind the ERP Database setup is server not ODBC.
Solns tried
I have tried restarting the SQL services
I have tried switching off the windows firewall temporarily to see if thats the issue
What could be the problem
Kindly help

 

[jebenson]

First, this is a forum for Visual Basic .NET programming. I think you probably meant to post this in a different forum.

Second, do you have the SQL Native Client installed on the workstations?

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!