Read error text carefully - need install "ODBC SQL server driver", U can download it from Microsoft THIS me was install 17 and 13 ver
Read error text carefully - need install "ODBC SQL server driver", U can download it from Microsoft THIS me was install 17 and 13 ver
i just downloaded and installed your driver. if i use 127.0.01,1433 for the SQL server to connect, i got the same error. if i use the "DESKTOP-AI91F2E\SQLEXPRESS" the one showed on my "Microsoft SQL Server Management Studio", logged in using CrimsonDesert with the default pass BlackNo.1Game#^ i got this error upon testingOriginally Posted by TieLay
have i installed the driver wrong?
***edited***
i enabled 1433 port, was able to go through 127.0.01,1433, but when i run the test, its still the same error with "TESTS FAILED!"
Last edited by squire14; 01-06-22 at 04:18 PM.
Did you restore all of the databases using that CrimsonDesert ID and did you set that user ID to have sysadmin access?
i just installed the v13 of odbc and the test went success but when i double click:
1. Auth.cmd (it auto closes)
2. Manager.cmd (auto closes)
3. Field.cmd (got an error saying "The application was unable to start correctly (0xc0000142)
was wondering, in ODBC, should i do this?
for billing.dsn>configure>NOVA_BILLINGDB_0001
for field.dsn>configure>NOVA_GAMEDB_0001
for log.dsn>configure>NOVA_LOGDB_0001
for publishing.dsn>Configure>NOVA_WORLDDB_0001
for world.dsn>configure>NOVA_WORLDDB_0001
or set all to NOVA_BILLINGDB_0001?
RTFMi just downloaded and installed your driver. if i use 127.0.01,1433 for the SQL server to connect, i got the same error. if i use the "DESKTOP-AI91F2E\SQLEXPRESS" the one showed on my "Microsoft SQL Server Management Studio", logged in using CrimsonDesert with the default pass BlackNo.1Game#^ i got this error upon testing
have i installed the driver wrong?
***edited***
i enabled 1433 port, was able to go through 127.0.01,1433, but when i run the test, its still the same error with "TESTS FAILED!"
I.e. SQL EXPRESS use dynamic por for accept external connectios, in this case U can:
- know what the port use you's SQL EXPRESS and add it's number into ODBC connection string
- set static port and add it's number into ODBC connection string coz for SQL EXPRESS it's very matter
- change SQL EXPRESS to full SQL SERVER, any edition, but U must buy it or use w@rezz and forget about it problem
- - - Updated - - -
U can run CMD as admin escalated priv, goto folder exists this .cmds and call any of then, or edit any of then and add in the end string "pause", after that execute and read console output, and log-files...
was wondering, in ODBC, should i do this?
for billing.dsn>configure>NOVA_BILLINGDB_0001
for field.dsn>configure>NOVA_GAMEDB_0001
for log.dsn>configure>NOVA_LOGDB_0001
for publishing.dsn>Configure>NOVA_WORLDDB_0001
for world.dsn>configure>NOVA_WORLDDB_0001
or set all to NOVA_BILLINGDB_0001?
U can run CMD as admin escalated priv, goto folder exists this .cmds and call any of then, or edit any of then and add in the end string "pause", after that execute and read console output, and log-files...
how to do the "add in the end string pause"? im sorry im lost there
Last edited by squire14; 01-06-22 at 05:12 PM.
You did not answer this:
Do NOT change the mapping of your dsn files.
I ran into that as well. It turned out to be an issue with the time zone and Daylight savings time. You have to disable auto timezone and turn off DST in your host system. Don't skip that step.
For me it turned out to be using Windows Server 2019 not respecting my change to the DST setting. It kept re-enabling it on me. I redid the install on Windows Server 2016 and all went well. If you are using Server 2019 or possibly newer, this may be your problem as well.
NOTE FOR ANYONE READING THIS:
I avoid Sql Server Express like it was Covid. Go download MS SQL Server STANDARD from their site and get the "Developer" version. It is legally free too and has everything in it the main 'for money' version does and is not nerfed in any way. For all versions you WILL have to use the SQL Server Configuration tool to enable TCPIP and reboot after you have done so.
Last edited by The Sourcerer; 01-06-22 at 06:37 PM.
In .dsn-file correct connection string for MS SQL EXPRESS on static port 1433 must seen as in THIS:
it's like:Code:SERVER=.,1433
and likeCode:SERVER=127.0.0.1,1433
for you's <server_IP> likeCode:SERVER=localhost,1433
for non SQLEXPRESS no need write port numberCode:SERVER=<server_IP>,1433
oh crap i forgot to install windows server. XD i already have the files but upon checking on the guides to install windows server, It says that i have to Configure BIOS Before Installing Windows Server and im pretty dumb with bios stuff hahaha uhmmm, do i really have to install windows server in VM?
i guess? after i got the files, i followed ledies instruction right away. i can delete the server files and extract again if that can help?Did you restore all of the databases using that CrimsonDesert ID and did you set that user ID to have sysadmin access?
yep. thats it. but i guess i made a mistake coz i was not using the vm?Re: Nova 3205 server file + clientIn .dsn-file correct connection string for MS SQL EXPRESS on static port 1433 must seen as in THIS:
Code:
SERVER=.,1433
it's like:
Code:
SERVER=127.0.0.1,1433
and like
Code:
SERVER=localhost,1433
for you's <server_IP> like
Code:
SERVER=<server_IP>,1433
for non SQLEXPRESS no need write port number
as far as I know depot 582661 is their test server and to be able to download this client you need to be registered on their test server, right?
I was able to get it using my steam id and password.
Find file MarketPlace Emulator.rar in your ya.disc. It's working? Can u say how include in this server? Thanks
not tested, it's only from other side, not remember origin...Find file MarketPlace Emulator.rar in your ya.disc. It's working? Can u say how include in this server? Thanks
- - - Updated - - -
no matter, so possible me forget for MS SQL Server Exprees need to use instance name like it's own default SQLEXPRESS, so easy forget coz no SQ EXPRESS under hand
it's like:Code:SERVER=.\SQLEXPRESS,1433
and likeCode:SERVER=127.0.0.1\SQLEXPRESS,1433
for you's <server_IP> likeCode:SERVER=localhost\SQLEXPRESS,1433
possible correct.Code:SERVER=<server_IP>\SQLEXPRESS,1433
About using VM, it's eats more resources for hypervisor even if it from MS or VMware, and VMware player/WS have host's RAM use limit 128Gb. as me seen in tread...
The VM uses some resources for the hypervisor indeed. However if you have 256G memory you can easily use 128gb for the server and a few gb for the hypervisor overhead. VMWare does imposes that limit of 128gb for a vm but is simple to configure. MS HyperV does not have that limit, but is much harder to configure.
Because I work with a lot of different game servers, it is my own preference to use a VM for those game servers. Much easier to manage them all.
Cheers!
Me try test at ESXi 6.7 update 3, it's good exp with it, but use so more RAM, 148Gb, for it's GS - very bed...
So about GS, so maybe who find settings for more decriase RAM usage with correct work, lags mo matter?...
Reply With Quote