- Joined
- May 4, 2009
- Messages
- 54
- Reaction score
- 19
Make sure your SQL TCP/IP config is enabled.. Check the edited post
i follow your guide
userdb connection failure what is this?
Make sure your SQL TCP/IP config is enabled.. Check the edited post
Same as mine. When logging in gm accnt login failed. but if I use the cfg method I can login but with .xml method login failed. I also enabled the port in sql server manager and restarted itit work but when i login my gm acct back to login failed error
Put this config file in the same directory as your GMChartEdit for the ADO connection to work. The user and password should also be encrypted. The IP is the same as the data source tag you put in the server files CFG. Or, you can enable the TCP/IP config for your SQL Server (check attachments below)..
GMCharEdit.xml
PHP:<?xml version="1.0" standalone="yes"?> <groups> <group> <title>International Server</title> <userdb> <name>RanUser</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </userdb> <gamedb> <name>RanGameS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </gamedb> <logdb> <name>RanLogS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </logdb> </group> </groups>
EDIT:
Check the attachment for SQL configuration example AND MAKE SURE TO RESTART SQL AFTER CHANGING THE SETTINGS
<?xml version="1.0" standalone="yes"?>
<groups>
<group>
<title>International Server</title>
<userdb>
<name>RanUser</name>
<ip>your PC\SQLEXPRESS</ip>
<id>sa(encrypted)</id>
<pw>1234(encrypted)</pw>
<gamedb>
<name>RanGameS1</name>
<ip>your PC\SQLEXPRESS</ip>
<id>sa(encrypted)</id>
<pw>1234(encrypted)</pw>
</gamedb>
<logdb>
<name>RanLogS1</name>
<ip>your PC\SQLEXPRESS</ip>
<id>sa(encrypted)</id>
<pw>1234(encrypted)</pw>
</logdb>
</group>
</groups>already got login windows for GMC, but using what account to GMC? in GSUserInfo or UserInfo?
Tried both GSUserInfo & UserInfo and it still says incorrect login.
Put this config file in the same directory as your GMChartEdit for the ADO connection to work. The user and password should also be encrypted. The IP is the same as the data source tag you put in the server files CFG. Or, you can enable the TCP/IP config for your SQL Server (check attachments below)..
GMCharEdit.xml
PHP:<?xml version="1.0" standalone="yes"?> <groups> <group> <title>International Server</title> <userdb> <name>RanUser</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </userdb> <gamedb> <name>RanGameS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </gamedb> <logdb> <name>RanLogS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </logdb> </group> </groups>
EDIT:
Check the attachment for SQL configuration example AND MAKE SURE TO RESTART SQL AFTER CHANGING THE SETTINGS
why 2005 wrong configuration 2017 find sql folder on start menuI followed your guide
i dont have sql express in my sql server configuration.. I use SQL 2017
still ADO problem is there
Do you have Database ADO in SQL?
why 2005 wrong configuration 2017 find sql folder on start menu
you able to use gmc? mine login failed
you able to use gmc? mine login failed
Found it already...why 2005 wrong configuration 2017 find sql folder on start menu
Put this config file in the same directory as your GMChartEdit for the ADO connection to work. The user and password should also be encrypted. The IP is the same as the data source tag you put in the server files CFG. Or, you can enable the TCP/IP config for your SQL Server (check attachments below)..
GMCharEdit.xml
PHP:<?xml version="1.0" standalone="yes"?> <groups> <group> <title>International Server</title> <userdb> <name>RanUser</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </userdb> <gamedb> <name>RanGameS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </gamedb> <logdb> <name>RanLogS1</name> <ip>127.0.0.1,50711</ip> <id>sa</id> <pw>1234</pw> </logdb> </group> </groups>
EDIT:
Check the attachment for SQL configuration example AND MAKE SURE TO RESTART SQL AFTER CHANGING THE SETTINGS
use RanOnlineEd.exe for ado config for gmchareditFound it already...
still error on ADO and say Database error when searching using character name..but character ID works.
no items in inventory can't see..
use RanOnlineEd.exe for ado config for gmcharedit
use RanOnlineEd.exe for ado config for gmcharedit
xml exorti try this thanks
failed to login