Originally Posted by
zeldaevolution
So this is my current setup...
Client - PC w10
Server Binaries - PC w10
Database - Virtual Box Ubuntu
I wonder if anyone has the same setup? I just want to avoid installing databases on my local computer since they're a bit difficult to remove whenever I want to
The setup is working fine, the compiles are fine, but I'm not sure where the problem is in regards to my connection on the server-db relationship
I can login the sa via SSMS and actually access the db from the ubuntu box;
I've rechecked all the ODBC data sources and they're all fine
The binaries are OK and compiled without much issues (except for the debug ones), and tried both modifying the IPs on the server config files (AccountServer.ini, loginserver.ini, Certifier.ini, etc...); but somehow all of the server binaries can't connect to the DB?
Here's a portion of the logfile that's being generated after being run:
2022/05/27 13:25:14
query:login
SQLSTATE:28000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user 'account'.
//================================================================================================================
now I'm not sure what's wrong since at first it was user 'sa' and now it's logging in using 'account'
this is just the Certifier, and I believe that if I'm able to pass through this single problem I'd be able to proceed with all the other server binaries
---other things I've tried:
changing 'sa' password to an alphanumeric format since there might have been issues if I include special characters
modifying ODBC data source from the registry editor so that it would be able to 'remember' the said password since I reckon the password might not have been proceeding from via the .ini or something
changing all the IPs to my database's IP
reverted and only changed the ones recommended by the guide (only where the external IPs should be changed)
added 'account' in the ODBC
I've pinged from the host, and I've also pinged from the virtual box towards the host, so it means that the connection is bidirectional
no firewalls, and considering that both are within the same subnet, I don't think the firewalls have anything to do with my connection problems
I've already spent about 25-30 hours and I'm not sure how to proceed anymore..... except making a windows based virtual box and making my new DB over there
...if this works I guess we can say that the db can be implemented on a non-windows platform then