Season 2, SQL 2005, Windows 2008

[WhenSorrowSang]

Hey guys i have just bought a new opteron dedicated server on Windows Server 2008 Web edition 64x

I have some problems, first of all i'd like to state that i had my server for 2 weeks on my home pc which runs on windows XP with no literaly no problems with the difference of SQL 2000

and since i have failed trying to install SQL 2000 on Windows Server 2008 i tried to use SQL 2005 with MD5 using the MMT Production official season II files

1st.

i have copy/paste 'd the WZ_MD5 something. dll into the SQL Server 2005 (84x)-> binn folder

entered the database infos into the files in bin folder as told and queried the code into the visual studio which was executed with no errors

I have tried to open CzF_Editor randomly with no special reason just to see if its configured well and i have understood that theres actually no connection inbetween SQL server 2005 and the files aswell as the CzF editor

i suspect that it has to do with my dedicated server hoster even tho its the first time i use sql 2005 server for mu i suspect that my host has different sql account settings than what you normally get ( sa ) but i hope someone who has already successfully used sql 2005 pls help

or is there a possibility that the default ODBC registry of the MMT files do not support SQLSERVER 2005 ?


2nd. My JoinServer.exe crashes lol. even tho all ips are right and i put my head into it, i have been checking and rechecking the ips for hours now... I suspect it might have to do with the previous problem (1st), i have tried several twicks with run compability and run as admin things but nothing works..

I wish i could downgrade my windows server 2008 to 2003 because this sql 2005 is taking the piss pls help me !

[MentaL]

[WhenSorrowSang]

after trying other server files.. i somehow got depressed because it seems like 2008 web cant really run mu server.. gosh

cept if anyone knows any one who hosts mu servers in windows 2008 web edition

[evo1123]

sql2005 is working good on windows 2008

try this GUIDE maybe it will help

[WhenSorrowSang]

I got now problems with it i dont know whats goin on really..

i have tried the odbc creation tool with different Protocols such as Pipe, Remoteaddress(while the ports are open) and every single connection protocol available and i still get the specific error that server can not be found ..

[evo1123]

go to the SYSTEM DNS tab... not that USER DNS tab .

heres another GUIDE

[WhenSorrowSang]

thanks for this i have finished the ODBCs now i have re restored the databases for MD5 and installed the MD5 support aswell as i decided to try the SrTeam season 2 files now i am having a problem with dataserver that is the WZ_character which has probably to do with incorrect installation of MD5, or database or something

[evo1123]

any screenshot of the error?

[WhenSorrowSang]

all DNS/ODBC functions seem to be ok and were installed with no errors also i have made sure that

first i install the WZ_MOD_MD3.dll and querried the MD5 and afterwards restored the dbs

[evo1123]

i think your still lacking of ODBC

does your files got ODBC.reg on it?

post it here.

[WhenSorrowSang]

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LOGIN]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnline]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuOnlineJoinDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuRanking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuRanking"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MuEvent]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuEvent"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\USELOG]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnline"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"LOGIN"="SQL Server"
"MuOnline"="SQL Server"
"MuOnlineJoinDB"="SQL Server"
"MuRanking"="SQL Server"
"MuEvent"="SQL Server"
"USELOG"="SQL Server"

---------- Post added at 01:54 PM ---------- Previous post was at 01:20 PM ----------

i have just tried the run as administrator mode aswell still same errors which are sql-oriented

[evo1123]

kinda weird you stored the ODBC correctly but you still error.. headache LOL

did you restore the right database? or try restarting your machine.

[WhenSorrowSang]

yes the database is correctly restored i guess, the Md5.dll file is on MSSQL.1 -> BINN folder

i have querried the SrTeam files query for enabling MD5

and afterwards i had the databases restored

but now i am trying to reboot and it delays much

---------- Post added at 03:30 PM ---------- Previous post was at 02:45 PM ----------

same WZ thing error in dataserver.. man i wish i could install SQL 2000 in Windows server 2008 web edition cr@P

but it seems like something is not right with the sql 2005 like it needs some extra settings in access protocols or dunno

[WhenSorrowSang]

Is there any possibility that the database baks dont fully support mssql 2005 ?, i m really desperate :'( or could i work SQL 2005 WITH OUT MD5?

[WhenSorrowSang]

i have just reinstalled the sql server and fixed its accessibility i mean after trying to access it via event and ranking and other servers it works perfectly.. i have just opened the odbc.reg and rewrote the server name part i have even tried to create an account via an editor but the dataserver insists in the WZ_CreateChracter error on the side note i don't have MD5 enabled is it a must to enable md5 since its sql server 2005?

[evo1123]

maybe your SQL2005 is still restricted and thats why the DS cant get access to the database

[WhenSorrowSang]

i have enabled Pipe/Names TCP/IP and every single connection mode the SQL 2005 offers

[WhenSorrowSang]

Problem found with the help of a great coder, the problem is that Windows Server 2008 Web edition does NOT Support the mu server .dlls because they are old but we have managed to fix that and the server is now up!