My customer's SQL database for GEN/LOGAN and app database was moved from one server to another. So, I had to repoint all of Lawson to the new database server using the CAP file (MICROSOFT) in %LAWDIR%/GEN and %LAWDIR%/LOGAN. The ODBC connection on the appserver can connect with the new database server, no problem. The gen and logan databases do exist in the new database server, and lawson user is the owner of those databases.
So now when I try to reorg GEN and LOGAN (yes changes), I get the following messeage,
File GEN/EXECUTABLE. OpenDBFile2 error is Unable to communicate with database driver process (99). Additional information is 1170.
I have looked over the MICROSOFT file again to ensure everything is correct. Again I can connect from app to database server with the ODBC Command, and the login/password are correct.
Something simple i know i'm missing, any ideas?
LSF9.0.0.3, SQL 2005, WIndows.
Thanks in advance,
-R
Ok, did an osql on the database.
osql -U lawson -P -S -d LOGAN
Login failed for user 'lawson'
But when I used:
osql -E lawson -S -d LOGAN
It worked fine.
So I checked the database on the db server.
The server does have 'lawson' listed within the Security logins (using windows authentication).
The database LOGAN is owned by lawson, but the lawson user is not lised as a User in that database. When I try to add the lawson user to the list of Users within SQL Server Management Studio, I get the pop up message, "The login already has an account under a different user name." Hmmm..
(Not a db guru here). But does the lawson user need to be listed as a user too?
Thanks,