2008 vs 2014

sariusmt · 04/25/2015, 09:23

Guys, I`ve seen tutorials for Rohan Local Servers that many used SQL 2008 R2. Would I encounter any problems if I use 2014 Enterprise SQL? Just asking cuz I don`t wanna waste HDD space and time to install 2008 R2 if it will work with 2014.

~~xpro99~~ · 04/25/2015, 10:52

so am I, dont want to waste my time trying to tell people who are lazy

sariusmt · 04/25/2015, 11:54

Quote:

Originally Posted by xpro99

so am I, dont want to waste my time trying to tell people who are lazy

It`s not about lazyness. I`m just asking people who already compared the both versions of SQL since SQL 2008 R2 conflicts with Win8.1 and won`t work. So the ironie ain`t necessarry here. If you ain`t willing to provide any info regarding the subject I don`t understant why you replay to this thread. Just to show off or be rude to others?

DretoNEX · 04/25/2015, 12:13

Quote:

Originally Posted by sariusmt

It`s not about lazyness. I`m just asking people who already compared the both versions of SQL since SQL 2008 R2 conflicts with Win8.1 and won`t work. So the ironie ain`t necessarry here. If you ain`t willing to provide any info regarding the subject I don`t understant why you replay to this thread. Just to show off or be rude to others?

I think you got the idea wrong cuz i tested SQL 2008 on Win 8.1 and works fine without any problem.If you are not sure what to use 2008 or 2014 both work.

sariusmt · 04/25/2015, 12:27

Quote:

Originally Posted by DretoNEX

I think you got the idea wrong cuz i tested SQL 2008 on Win 8.1 and works fine without any problem.If you are not sure what to use 2008 or 2014 both work.

Dreto, on my system when I try to install SQL 2008 R2 it crashes, complayning about system compatibility. 2014 tho seems to work fine. That`s why i asked. Thank you. A simple answer like yours would sufice. Would be so hard for him to post a simple yes or no? Just sayin`...

SkyZer0 · 04/25/2015, 13:13

Quote:

Originally Posted by sariusmt

Guys, I`ve seen tutorials for Rohan Local Servers that many used SQL 2008 R2. Would I encounter any problems if I use 2014 Enterprise SQL? Just asking cuz I don`t wanna waste HDD space and time to install 2008 R2 if it will work with 2014.

Im using 2008 its sure it will work , i tried 2014 but there was a problem whit different ports so better for you to use 2008 .

DretoNEX · 04/25/2015, 13:34

Default ports can be changed from the options menu

~~xpro99~~ · 04/25/2015, 14:15

Quote:

Originally Posted by sariusmt

It`s not about lazyness. I`m just asking people who already compared the both versions of SQL since SQL 2008 R2 conflicts with Win8.1 and won`t work. So the ironie ain`t necessarry here. If you ain`t willing to provide any info regarding the subject I don`t understant why you replay to this thread. Just to show off or be rude to others?

never try SQL 2014 but SQL 2012 work fine for me, probably just need to find a suitable arrangement. I mean why dont you just try it

please dont be offended, Im just bored with my work

im batman · 04/25/2015, 15:53

I've seen both MSSQL server 2008 R2 and 2014 as well as Windows Server 2010 R2 and 2012.

If you use Windows Server 2012, I would say MSSQL server 2014 would prolly be better to keep stuff current. For older windows server, either one works fine in my friend's vms. Rohan doesn't seem to have a problem with either.

sariusmt · 04/25/2015, 16:58

Quote:

Originally Posted by im batman

I've seen both MSSQL server 2008 R2 and 2014 as well as Windows Server 2010 R2 and 2012.

If you use Windows Server 2012, I would say MSSQL server 2014 would prolly be better to keep stuff current. For older windows server, either one works fine in my friend's vms. Rohan doesn't seem to have a problem with either.

Thank you. I do really appreciate for the reply and the prompt answer.

sariusmt · 04/26/2015, 23:50

Ok managed to get up and running SQL. Now I can`t seem to get the Db server to work with SQL. Maybe I`m missing something sincer I`m already trying to make this work for at least a couple of hours and nothing.
This would be the db.log

Quote:

15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 08001 00000011 [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied. DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5
15/04/27 00:35:15> 01000 00000002 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). DBTask_Unknown(0x00000000) 5

this would be the dbcon from xampp

Quote:

<?php
$serverName = "Sarius-PC" ;
$uid = 'sa' ;
$pwd = 'XXXX' ;

$connectionInfo = array( "UID" => $uid ,
"PWD" => $pwd ,
"Database" => "RohanUser"
);

$oConn = sqlsrv_connect( $serverName, $connectionInfo);
if( $oConn === false ) {
// print_r( sqlsrv_errors(), true);
die (-1000); # Unable to connect to the database
}

?>

and these would be the registry

Spoiler

.
The passwords might not match on this description since I replaced them with XXX for obvious reasons but they are the same on each. Any ideeas what I`m doing wrong?
PS: I would really appreciate for people that aren`t willing to help not to reply to this thread.

khenjikyle · 04/27/2015, 07:31

why my friends can't play on my server. They got error Http_status_error log in failed. We're using hamachi. :3

im batman · 04/27/2015, 16:10

Quote:

Originally Posted by sariusmt

Ok managed to get up and running SQL. Now I can`t seem to get the Db server to work with SQL. Maybe I`m missing something sincer I`m already trying to make this work for at least a couple of hours and nothing.
This would be the db.log

this would be the dbcon from xampp

and these would be the registry

Spoiler

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet]
"Nation"="US"
"ServerDir"="C:\\RoHan\\RoHan"
"LogDir"="C:\\RoHan\\RoHan\\Log"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\AI]
"ConnMap"="1-0|1-1|1-2|1-3|1-4|5-0|5-1|5-3|5-4|5-5|3-0|3-1"
"DBServer"="127.0.0.1:22500"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.AI.ROHAN_4_1"
"ServerClassMap"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4 "
"ThreadSleep"=dword:0000005f
"Module"="C:\\RoHan\\RoHan\\Fairy\\AIServer\\AISer ver.exe"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\DB]
"ServerClass"="FAIRY.ROHAN_4.DB.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\DBServer\\DBSer verT.exe"
"LoginDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=RohanUser"
"GameDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=RohanGame"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\Interrupt]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\LOG]
"DBServer"="127.0.0.1:22500"
"ServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\LogServer\\LogS erver.exe"
"LogDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=rohanstat"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\LogCopy]
"LogFTP_IP"="127.0.0.1"
"LogFTP_ID"="rohan-dev"
"LogFTP_PW"="dlsehvotm!@#$"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\MAP]
"Title"="Map US"
"LogServerClass"="FAIRY.ROHAN_4.LOG.ROHAN_4"
"ServerClassAI"="FAIRY.ROHAN_4.MAP_AI.ROHAN_4"
"ServerClass"="FAIRY.ROHAN_4.MAP.ROHAN_4"
"DBServer"="127.0.0.1:22500"
"Module"="C:\\RoHan\\RoHan\\Fairy\\MapID\\MapID.ex e"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\Monitor]
"CodeDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=RohanCode;"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\RelayCom]
"ConfigPath"="D:\\Fairy\\RelayCom\\RelayCom.config "
"LogPath"="d:\\Log\\RelayCom"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\RelayCom\Consign]
"config"="D:\\Fairy\\RelayCom\\Consign.config"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\RelayCom\Login]
"ip"="127.0.0.1"
"port"=dword:000071ac
"poolsize"=dword:0000001e

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\RohanCom]
"ConfigPath"="C:\\sslcer\\Fairy\\RohanCom\\RohanCo m.config"
"LogPath"="C:\\sslcer\\Fairy\\Log\\RohanCom"
"LanguageID"="KRKSC"

.
The passwords might not match on this description since I replaced them with XXX for obvious reasons but they are the same on each. Any ideeas what I`m doing wrong?
PS: I would really appreciate for people that aren`t willing to help not to reply to this thread.

1. instead of using Sarius-PC, use your server's real IP address instead - not 127.0.0.1.
2. instead of using 127.0.0.1, use your server's real IP address instead.
3. Did you set up the RohanUser.dbo.TServer table entries with your server's real IP address as well - not 127.0.0.1?
4. make sure yor serverlist5.php file is updated with the ip address and port of your rohan server - not 127.0.0.1.

~~xpro99~~ · 04/27/2015, 17:27

Quote:

Originally Posted by sariusmt

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Geomind\Ga menet\DB]
"ServerClass"="FAIRY.ROHAN_4.DB.ROHAN_4"
"Module"="C:\\RoHan\\RoHan\\Fairy\\DBServer\\DBSer verT.exe"
"LoginDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=RohanUser"
"GameDB"="DRIVER={SQL Server};SERVER=Sarius-PC;UID=sa;PWD=XXX;DATABASE=RohanGame"

"LoginDB"="DRIVER={SQL Server};SERVER=PC-Name\InstanceName;UID=sa;PWD=XXX;DATABASE=RohanUser"
also for GameDB, LogDB, CodeDB

Quote:

Originally Posted by sariusmt

<?php
$serverName = "Sarius-PC" ;
$uid = 'sa' ;
$pwd = 'XXXX' ;

$connectionInfo = array( "UID" => $uid ,
"PWD" => $pwd ,
"Database" => "RohanUser"
);

$oConn = sqlsrv_connect( $serverName, $connectionInfo);
if( $oConn === false ) {
// print_r( sqlsrv_errors(), true);
die (-1000); # Unable to connect to the database
}

?>

$serverName = "PC-Name\InstanceName" ;

im batman · 04/27/2015, 17:41

you don't need the instance name if the instance is the default, or only, instance in that pc. just an ip address is fine.

I usually find using the real ip address is much more reliable than the pc name. especially in vms.
"Module"="C:\\RoHan\\RoHan\\Fairy\\DBServer\\D BSer verT.exe"
but that space in DBServerT.exe is a definite problem.