well all seems to work properly i have migrated my mu server 2008 and now my titanlinkserver crashes....
got this error from the log.
SQLSTATE:08004, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Language requested in login '¼òÌåÖÐÎÄ' is not an official language name on this SQL Server. Login fails.
config.ini is good
odbc tested and connection is ok.
on my computer it works perfectly (if i change the ip correctly)
need some assist whit this
well says ur Login id is bad, changed to sa? i dont know exactly.. run as admin titanlink is normal i guess.
the titanserver is auto started as administrator.
sa login has been changed. even the odbc connection with sa and the good password and test is fine.
rechecked te config.ini and other files in titanlinkserver folder but are all fine with correct information.
only different on my pc with windows 7 32-bit it works.
on de server 2008 R2 64-bit it doesn't....
welll its cus of ur sql server?
no sql server on my server 2008 is accectly the same as on my windws 7 machine.
some installation files and some configuration.
if i restore the db on my windows 7 it works. and if i restore it on my server its reporting the error message above given
"SQLSTATE:08004, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Language requested in login '¼òÌåÖÐÎÄ' is not an official language name on this SQL Server. Login fails."
Originally Posted by pretendor
There is an issue with your ODBC.
Check out karli's guide. It covers most databases s1-s8
Or your SQL pass in the configs is wrong.
nja probleem 1 is opgelost. het sa account in de DB deed moeilijk nieuw account aangemaakt en gemachtigt voor de DB's alle files aangepast met de nieuwe username en password maar nu crashen de applications bij het opstarten.
ODBC koppelingen zijn ook goed aangepast.
bij titanserver komt nu not responing na een tijdje. en er word geen log weg geschreven
i dont understand you pretendor, just do the same way i do on some of my tutorials, use sql 2000 for no issues,else sql 2008 is complex.
Problem 1 solved the sa login on sql server 2008 was bad. So created new account and change every config file with the new password and username.
New it will startup and stay open but chrases on running
titanlinkserver reports not responding in titlebar
Odbc connections are reconfigured and al mu server files runs.
Only titanserver crashes all other programs run and connecting to sql server
on windows 7 this runs properly
so because its stuck during running there is no log written,,,,,, any ideas??
pretendor, seriously i am really lost and confused and cannot help you.. dont even understand your explanations, give some screens i dont know.. use sql 2000 i dont know.
Everything is working now and can connect to the database. Only the titanlinkserver is not responding and cannot write his log file cuz i have to kill to process. So seems like the titanlinkserver crashes and i don't know what cuz the problem
well i have found mu issue i guess only now the solution...
log:
Initialized log instance
Initializing Servers...
[AllowList] Loaded Successfull!
[DataServer1] Initializing database connection
[DataServer1] [DB] Connection Successfull!
[DataServer1] Connected to MuOnline@MuOnline database
[DataServer1] Initialized database connection
[DataServer1] Initializing IOCP system connection
[DataServer1] Server Listen OK. Port: 55960
[DataServer1] Initialized IOCP system connection
[DataServer2] Initializing database connection
[DataServer2] [DB] Connection Successfull!
[DataServer2] Connected to MuOnline@MuOnline database
[DataServer2] Initialized database connection
[DataServer2] Initializing IOCP system connection
[DataServer2] Server Listen OK. Port: 55962
[DataServer2] Initialized IOCP system connection
[JoinServer] Initializing database connection
[JoinServer] [DB] Connection Successfull!
[JoinServer] Connected to MuOnline@MuOnlineJoinDB database
[JoinServer] Initialized database connection
[JoinServer] Initializing IOCP system connection
[JoinServer] Server Listen OK. Port: 55970
[JoinServer] Initialized IOCP system connection
19:40:35 UPDATE MEMB_STAT SET ConnectStat = 0, DisConnectTM = getdate() WHERE ConnectStat = 1
[ExtraServer] Initializing database connection
SQLSTATE:28000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
SQLSTATE:IM006, Diagnosis:[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[ExtraServer] [DB] Error On Connection!
[ExtraServer] Connected to MuOnline@MuOnline database
[ExtraServer] Initialized database connection
[ExtraServer] Initializing IOCP system connection
[ExtraServer] Server Listen OK. Port: 55999
[ExtraServer] Initialized IOCP system connection
[WzExDB] Initializing database connection
[WzExDB] [DB] Connection Successfull!
[WzExDB] Connected to MuOnline@MuOnline database
[WzExDB] Initialized database connection
[WzExDB] Initializing IOCP system connection
[WzExDB] Server Listen OK. Port: 55906
[WzExDB] Initialized IOCP system connection
19:40:36 SELECT * FROM Guild WHERE Number = G_Union
19:40:36 SELECT * FROM Guild WHERE Number <> G_Union
[WzExDB] [MuOnlineDB] GuildData Loaded in 156 msec
[PostServer] Initializing IOCP system connection
[PostServer] Server Listen OK. Port: 55998
[PostServer] Initialized IOCP system connection
Servers initialization in 1313 msec
config:
[DataServer1]
Port=55960
ServerODBC=MuOnline
Name=MuOnline
NameMe=MuOnline
NameRS=Ranking
NameES=MU2003_EVENT_DATA
ResetColumn=Resets
Login=Muadmin
Password=*******
MaxConnections=10
[DataServer2]
Port=55962
ServerODBC=MuOnline
Name=MuOnline
NameMe=MuOnline
NameRS=Ranking
NameES=MU2003_EVENT_DATA
ResetColumn=Resets
Login=Muadmin
Password=********
MaxConnections=10
[PostServer]
Port=55998
AdminName=Jeffrey
MaxConnections=10
[WzExDB]
Port=55906
ServerODBC=MuOnline
Name=MuOnline
Login=Muadmin
Password=********
MaxConnections=10
[JoinServer]
Port=55970
ServerODBC=MuOnlineJoinDB
Name=MuOnline
Login=Muadmin
Password=**********
UseGoldChannelSystem=0
UseSpecialDisconnect=0
OnStartDisconnectAllInDB=1
UseSpecialMove=0
UseMD5=0
CSIP=127.0.0.1
CSUDPPort=55557
[Common]
IsS6E2=1
IsSavePostLogs=1
ODBC connections are all setup with username Muadmin and password *********
adres is changed from (local) to 127.0.0.1.
it seems like the Titanlinkserver keeps useing SA as username instead of Muadmin.
someone an idea where this can be configured??
i have only the config.ini file in the titanlinkserver folder.
and all other config files or files with sql setup changed from sa to Muadmin..
please assist me with this. this the only thing thats keep me from running the server
Not sure my friend.. if it says SQLSTATE:28000, Diagnosis:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
then somethin with that, somewhere it cannot be read, and last time, use sql 2000?
karli thanks for replying me.
i cannot run sql 2000 on my server 2008 r2.
and about the login failed.... nowhere in the scripts is login sa configured...... atleast what i know off.
i have changed all the logins for sql login to Muadmin so i really don't know where he gets its SA account from.
you any idea?? where i can look foor login sa....
mate, - reinstall sql 2008 again on ur PC, u did somethin wrong with the installation or something.
Reply With Quote