hello i have a error when i add the dns ples help me how to add
thnks
hello i have a error when i add the dns ples help me how to add
thnks
Last edited by jison; 15-02-12 at 03:42 PM.
Lol i dont know this language at all, how do you expect anyone to tell you what it means without giving a translation? Btw, ep3 does NOT require dsn settings, leave them blank and just fill your db ip, port, user, pass and db name. These should be enough for a connection to db anyway.
are you sure ?
i have log server errors
look here
Last edited by jison; 15-02-12 at 03:42 PM.
I can tell you for sure it works for me without dsn. Idk about your set up. But youve certainly done something wrong with sql. What sql did you install?
Last edited by PanKJ; 10-06-11 at 12:53 AM.
sql server not sql express
i think he means what version.. 2005 or 2008
I suggest you use mssql 2008 r2, use the db backups, follow my guide about mssql users and logins, configure mssql setting to set ip and port and THEN try to run the server (with correct settings in global.cfg).
i do i read your guide
check my golbal.cfg
Last edited by jison; 15-02-12 at 03:42 PM.
JISON\SQLEXPRESS <-- That one is wrong , there should be an IP not SQL login info.Code:################################################################################ # Database Settings 1 - PreServer ################################################################################ $PRE_ODBC_DSN = db_acc $PRE_ODBC_UID = 21474103 $PRE_ODBC_PASSWD = 2352580204405E $PRE_DB_SERVER_DATABASE_NAME = atum2_db_account $PRE_DB_SERVER_IP = JISON\SQLEXPRESS $PRE_DB_SERVER_PORT = 9979 ################################################################################ # Database Settings 2 - ServerGroup(IMServer, FieldServer, LogServer, NPCServer) ################################################################################ $SERVER_GROUP_ODBC_DSN = db_1 $SERVER_GROUP_ODBC_UID = 21474103 $SERVER_GROUP_ODBC_PASSWD = 2352580204405E $SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $SERVER_GROUP_DB_SERVER_IP = JISON\SQLEXPRESS $SERVER_GROUP_DB_SERVER_PORT = 9979 ################################################################################ # Database Settings 3 - Log DB Server(LogServer) ################################################################################ $LOG_SERVER_GROUP_ODBC_DSN = db_1 $LOG_SERVER_GROUP_ODBC_UID = 21474103 $LOG_SERVER_GROUP_ODBC_PASSWD = 2352580204405E $LOG_SERVER_GROUP_DB_SERVER_DATABASE_NAME = atum2_db_1 $LOG_SERVER_GROUP_DB_SERVER_IP = JISON\SQLEXPRESS $LOG_SERVER_GROUP_DB_SERVER_PORT = 9979
it does say pre_db_server_IP for a reason
else it maybe would say something like pre_db_server_path or something
Facepalm. But i wonder why there was an 127.0.0.1 when you got this file... In the original version of my cfgs i even had COMMENTS so that noobs no what to put there. I even recommended to use the 127.0.0.1 without changing it. Idk what else i should say.
Hum interesting,do you know the JISON\SQLEXPRESS is like my config i use MIKAL\SQLEXPRESS cause if i use my ip that not work, my instance on db query is like this,and when i setup my sqlexpress on your way using 192.168.1x or 127.0.0.1 or 5.x.x.x.x i got my instance working on it on log but preserver not runningiocp init fail,have to go back to MIKAL\SQLEXPRESS config instance in sqlexpress to get it work.This interest me cause i think that if i got some problem with admintools,that start by that cause when i use MIKAL\SQLEXPRESS on patching that got wrong entry.
Last edited by desp08500; 10-06-11 at 10:00 AM.
okay what ip i do give
the hamachi ip or the 192.0.0.0?