can not connect to server cabal

Hi I can not connect to my server (Cabal)

I can putty to connect properly only to cabal so if I want to play cabal will not work.
knows a why?

Log File;
WorldSvr_24_01.Log

Quote:

---

[Thu Apr 1 2010 21:25:52.599584 3086948032]: open log file '/var/log/cabal/WorldSvr_24_01.log'
[Thu Apr 1 2010 21:25:52.600473 3086948032]: LOG LEVEL: 3
[Thu Apr 1 2010 21:25:52.600574 3086948032]: MemPoolUnitSizeClass(5): 16384Bytes
[Thu Apr 1 2010 21:25:52.602595 3086948032]: Start WorldSvr_24_01 Server
[Thu Apr 1 2010 21:25:52.603825 3086948032]: CheckSkillCoolTimeHack (Off)
[Thu Apr 1 2010 21:25:52.603920 3086948032]: CheckShopHack (Off)
[Thu Apr 1 2010 21:25:52.603953 3086948032]: CheckWarpHack (Off)
[Thu Apr 1 2010 21:25:52.604402 3086948032]: CheckWareHouseHack (Off)
[Thu Apr 1 2010 21:25:52.604435 3086948032]: UseCheckDistanceSkillHack (Off)
[Thu Apr 1 2010 21:25:52.604465 3086948032]: MaxTimeHackingCount(2)
[Thu Apr 1 2010 21:25:52.604495 3086948032]: MaxDistanceHackingCount(2)
[Thu Apr 1 2010 21:25:52.604524 3086948032]: UseNonClientCheck (Off)
[Thu Apr 1 2010 21:25:52.604554 3086948032]: NonClientDisAdvantageRate (90)
[Thu Apr 1 2010 21:25:52.604584 3086948032]: useDropDiscount (Off)
[Thu Apr 1 2010 21:25:52.604614 3086948032]: UseBlessingBeadCheck (Off)
[Thu Apr 1 2010 21:25:52.604645 3086948032]: AllowTradeChannel (Off)
[Thu Apr 1 2010 21:25:52.604675 3086948032]: UseCheckMissionIdx(On)
[Thu Apr 1 2010 21:25:52.605380 3086948032]: UseCheckDeadStatActive(Off)
[Thu Apr 1 2010 21:25:52.605439 3086948032]: reload ActiveDeadStatCount(30)
[Thu Apr 1 2010 21:25:52.605892 3086948032]: UseHackcheckByTimeScope (Off)
[Thu Apr 1 2010 21:25:52.606436 3086948032]: CheckSkillTimeHackScope(60000)
[Thu Apr 1 2010 21:25:52.606469 3086948032]: UseMobsChaseModify (On)
[Thu Apr 1 2010 21:25:52.606501 3086948032]: UseAlzDbHackCheck (Off)
[Thu Apr 1 2010 21:25:52.606531 3086948032]: UseCutIfAlzDbHacked (Off)
[Thu Apr 1 2010 21:25:52.606561 3086948032]: useCheckUserAttack (Off)
[Thu Apr 1 2010 21:25:52.606591 3086948032]: UseHackUserDBSave (On)
[Thu Apr 1 2010 21:25:52.606620 3086948032]: UseAdminUser (Off)
[Thu Apr 1 2010 21:25:52.606699 3086948032]: UseAntiOnlineGameAddictionSystem(1)
[Thu Apr 1 2010 21:25:52.607422 3086948032]: InstantPlayTimeClearIntervalMin(300)
[Thu Apr 1 2010 21:25:52.607617 3086948032]: InstantPlayTimeDbUpdateIntervalMin(5)
[Thu Apr 1 2010 21:25:52.607650 3086948032]: InstantPlayTimeNotifyIntervalMin(1)
[Thu Apr 1 2010 21:25:52.607682 3086948032]: AdvantageBoundaryTime(10800, 18000)
[Thu Apr 1 2010 21:25:52.607712 3086948032]: InstantPlayTimeDebugMultiple(1)
[Thu Apr 1 2010 21:25:52.608745 3086948032]: UseCheckBelongItem (Off)
[Thu Apr 1 2010 21:25:52.608836 3086948032]: UseCheckDMZArea (Off)
[Thu Apr 1 2010 21:25:52.608867 3086948032]: AllowCashShop(0)
[Thu Apr 1 2010 21:25:52.608900 3086948032]: AllowNetcafePoint(0)
[Thu Apr 1 2010 21:25:52.609418 3086948032]: RestrictOddCircleUseCountInDungeon (On)
[Thu Apr 1 2010 21:25:52.609452 3086948032]: UseAdditionalMissionDungeonInstanceInPremiumCH (On)
[Thu Apr 1 2010 21:25:52.609480 3086948032]: UseAdditionalMissionDungeonInstanceInPremiumUser (On)
[Thu Apr 1 2010 21:25:52.609507 3086948032]: AdditionalMissionDungeonInstanceCount (0)
[Thu Apr 1 2010 21:25:52.609537 3086948032]: UsePvpBetting (Off)
[Thu Apr 1 2010 21:25:52.609566 3086948032]: PShopOpenLimitCount (0)
[Thu Apr 1 2010 21:25:52.609595 3086948032]: UseTradeChannelRestriction (Off)
[Thu Apr 1 2010 21:25:52.609625 3086948032]: UseArtOfDefensePenalty (On)
[Thu Apr 1 2010 21:25:52.609655 3086948032]: IgnorePartyInviteDistance (Off)
[Thu Apr 1 2010 21:25:52.609684 3086948032]: UseWorldDrop (On)
[Thu Apr 1 2010 21:25:52.609714 3086948032]: UseInventoryHackCheck (Off)
[Thu Apr 1 2010 21:25:52.610413 3086948032]: UseRandomValueWriteLog (Off)
[Thu Apr 1 2010 21:25:52.610444 3086948032]: UseMinLevDiffValueForExpCalc (On)
[Thu Apr 1 2010 21:25:52.610474 3086948032]: UsePartyMinExpForInvalidPartyMember (On)
[Thu Apr 1 2010 21:25:52.610597 3086948032]: UseIgnoreOtherBlessBuff (Off)
[Thu Apr 1 2010 21:25:52.610650 3086948032]: Extended Alz Mode
[Thu Apr 1 2010 21:25:52.610709 3086948032]: GameGuard enabled version
[Thu Apr 1 2010 21:25:52.611429 3086948032]: GameGuard turned off
[Thu Apr 1 2010 21:25:52.611514 3086948032]: APEX enabled version
[Thu Apr 1 2010 21:25:52.611549 3086948032]: APEX turned off
[Thu Apr 1 2010 21:25:52.611576 3086948032]: XTrap disabled version
[Thu Apr 1 2010 21:25:52.611607 3086948032]: WaitUntilChannelTypeSet(Off)
[Thu Apr 1 2010 21:25:52.611639 3086948032]: UseBootUpGmsChannelType(On)
[Thu Apr 1 2010 21:25:52.614452 3086948032]: Local ip = 5.98.107.112 (from ini)
[Thu Apr 1 2010 21:25:52.614566 3086948032]: MaxAttackHackTime (300000)
[Thu Apr 1 2010 21:25:52.614600 3086948032]: SpeedHackCheckTime (10000)
[Thu Apr 1 2010 21:25:52.640523 22342560]: CProcessLayer(0)::svc Start [22342560]
[Thu Apr 1 2010 21:25:52.641518 3086948032]: try connect 127.0.0.1:38170, Sync
[Thu Apr 1 2010 21:25:52.646444 3086948032]: sock 5 ->LinkHandler Open
[Thu Apr 1 2010 21:25:52.646567 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Thu Apr 1 2010 21:25:52.647479 3086948032]: try connect 127.0.0.1:38181, Sync
[Thu Apr 1 2010 21:25:52.651468 3086948032]: sock 7 ->LinkHandler Open
[Thu Apr 1 2010 21:25:52.651604 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Thu Apr 1 2010 21:25:52.651695 3086948032]: try connect 127.0.0.1:38190, Sync
[Thu Apr 1 2010 21:25:52.658684 3086948032]: sock 8 ->LinkHandler Open
[Thu Apr 1 2010 21:25:52.659445 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Thu Apr 1 2010 21:25:52.659536 3086948032]: try connect 127.0.0.1:38121, Sync
[Thu Apr 1 2010 21:25:52.664391 3086948032]: sock 9 ->LinkHandler Open
[Thu Apr 1 2010 21:25:52.664570 3086948032]: SendIPSConnect2Svr (161:24:01:00)
[Thu Apr 1 2010 21:25:52.748399 3086948032]: GuildCreateFee: 10000000
[Thu Apr 1 2010 21:25:56.422157 90160032]: CProcessLayer(1)::svc Start [90160032]
[Thu Apr 1 2010 21:25:56.589494 32832416]: CProcessLayer(2)::svc Start [32832416]
[Thu Apr 1 2010 21:25:56.589856 43322272]: CProcessLayer(3)::svc Start [43322272]
[Thu Apr 1 2010 21:25:56.783420 117013408]: CProcessLayer(4)::svc Start [117013408]
[Thu Apr 1 2010 21:25:56.783812 61791136]: CProcessLayer(5)::svc Start [61791136]
[Thu Apr 1 2010 21:25:56.988326 72280992]: CProcessLayer(6)::svc Start [72280992]
[Thu Apr 1 2010 21:25:56.988762 100649888]: CProcessLayer(7)::svc Start [100649888]
[Thu Apr 1 2010 21:25:57.201290 127503264]: CProcessLayer(8)::svc Start [127503264]
[Thu Apr 1 2010 21:25:57.201796 2986580896]: CProcessLayer(9)::svc Start [2986580896]
[Thu Apr 1 2010 21:25:57.400158 2967128992]: CProcessLayer(10)::svc Start [2967128992]
[Thu Apr 1 2010 21:25:57.400661 2947828640]: CProcessLayer(13)::svc Start [2947828640]
[Thu Apr 1 2010 21:25:57.631992 2931948448]: CProcessLayer(14)::svc Start [2931948448]
[Thu Apr 1 2010 21:25:57.633027 2911431584]: CProcessLayer(19)::svc Start [2911431584]
[Thu Apr 1 2010 21:25:57.821991 2896452512]: CProcessLayer(23)::svc Start [2896452512]
[Thu Apr 1 2010 21:25:57.822613 2881301408]: CProcessLayer(24)::svc Start [2881301408]
[Thu Apr 1 2010 21:25:58.005899 2866113440]: CProcessLayer(25)::svc Start [2866113440]
[Thu Apr 1 2010 21:25:58.006595 2851109792]: CProcessLayer(26)::svc Start [2851109792]
[Thu Apr 1 2010 21:25:58.196815 2835008416]: CProcessLayer(27)::svc Start [2835008416]
[Thu Apr 1 2010 21:25:58.196964 2820021152]: CProcessLayer(28)::svc Start [2820021152]
[Thu Apr 1 2010 21:25:58.392732 2804943776]: CProcessLayer(29)::svc Start [2804943776]
[Thu Apr 1 2010 21:25:58.392881 2789698464]: CProcessLayer(30)::svc Start [2789698464]
[Thu Apr 1 2010 21:25:58.454836 3086948032]: try listening 38111 port
[Thu Apr 1 2010 21:26:00.688529 22342560]: ChannelType changed(0 -> 1)

---

LoginSvr_01.Log;

Quote:

---

[Thu Apr 1 2010 21:25:53.916222 3086882496]: open log file '/var/log/cabal/LoginSvr_01.log'
[Thu Apr 1 2010 21:25:53.916839 3086882496]: LOG LEVEL: 3
[Thu Apr 1 2010 21:25:53.917188 3086882496]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Apr 1 2010 21:25:53.921206 3086882496]: Start LoginSvr_01 Server
[Thu Apr 1 2010 21:25:53.922200 3086882496]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Thu Apr 1 2010 21:25:53.922272 3086882496]: TestChannelGroupIdxStartPoint=50
[Thu Apr 1 2010 21:25:53.922352 3086882496]: affiliatedCorpIP=121.170.135.;
[Thu Apr 1 2010 21:25:53.922795 3086882496]: AdminIP=121.170.135.;
[Thu Apr 1 2010 21:25:53.922835 3086882496]: client_version=22
[Thu Apr 1 2010 21:25:53.922867 3086882496]: IgnoreClientVersion(1)
[Thu Apr 1 2010 21:25:53.922904 3086882496]: UseAntiOnlineGameAddictionSystem(1)
[Thu Apr 1 2010 21:25:53.923204 3086882496]: AdultAge(18)
[Thu Apr 1 2010 21:25:53.923236 3086882496]: DefaultAgeAdult(1)
[Thu Apr 1 2010 21:25:53.923278 3086882496]: UsePSS(0)
[Thu Apr 1 2010 21:25:53.923309 3086882496]: CachedPSS(0)
[Thu Apr 1 2010 21:25:53.923340 3086882496]: PssCacheDurationMin(1440)
[Thu Apr 1 2010 21:25:53.923370 3086882496]: CutIfPssUserNotFound(0)
[Thu Apr 1 2010 21:25:53.923789 3086882496]: PssLogLevel(0)
[Thu Apr 1 2010 21:25:53.923819 3086882496]: InstantPlayTimeClearIntervalMin(300)
[Thu Apr 1 2010 21:25:53.923848 3086882496]: IDC(1)
[Thu Apr 1 2010 21:25:53.924313 3086882496]: SharedPssPersonId(0)
[Thu Apr 1 2010 21:25:53.924392 3086882496]: NormalClientMagicKey(1168110)
[Thu Apr 1 2010 21:25:53.924424 3086882496]: UseImageAuth(0)
[Thu Apr 1 2010 21:25:53.924790 3086882496]: ImageAuthDataPath(./ImageAuth/)
[Thu Apr 1 2010 21:25:53.924820 3086882496]: ImageAuthMaxTryCount(5)
[Thu Apr 1 2010 21:25:53.924850 3086882496]: ImageAuthWaitTime(120000)
[Thu Apr 1 2010 21:25:53.924880 3086882496]: BlockIfImageAuthFail(0)
[Thu Apr 1 2010 21:25:53.925187 3086882496]: UseServerListManualOrder(0)
[Thu Apr 1 2010 21:25:53.925217 3086882496]: 00:00 => 0
[Thu Apr 1 2010 21:25:53.925245 3086882496]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Thu Apr 1 2010 21:25:53.925274 3086882496]: ImageAuthDataMgr Init Begin
[Thu Apr 1 2010 21:25:55.210005 3086882496]: ImageAuthDataMgr Init End(Count:1995)
[Thu Apr 1 2010 21:25:55.215351 3086882496]: try connect 127.0.0.1:38170, Sync
[Thu Apr 1 2010 21:25:55.221185 3086882496]: sock 7 ->LinkHandler Open
[Thu Apr 1 2010 21:25:55.221299 3086882496]: SendIPSConnect2Svr (195:128:01:00)
[Thu Apr 1 2010 21:25:55.221987 3086882496]: try connect 127.0.0.1:38180, Sync
[Thu Apr 1 2010 21:25:55.226372 3086882496]: sock 9 ->LinkHandler Open
[Thu Apr 1 2010 21:25:55.227205 3086882496]: SendIPSConnect2Svr (195:128:01:00)
[Thu Apr 1 2010 21:25:55.227365 3086882496]: try listening 38101 port
[Thu Apr 1 2010 21:25:55.660996 3078581152]: CProcessLayer(0)::svc Start [3078581152]
[Thu Apr 1 2010 21:25:55.661209 3078581152]: ServerState changed(0 -> 0)
[Thu Apr 1 2010 21:26:21.780022 3086882496]: accept success 11(5.98.150.201:4395)
[Thu Apr 1 2010 21:26:21.782306 3086882496]: 1.open user 11 [8ED1748] (5.98.150.201)
[Thu Apr 1 2010 21:26:21.877942 3078581152]: AuthRequest: UserID(test), Addr(5.98.150.201)
[Thu Apr 1 2010 21:26:43.277869 3086882496]: 1.close user 11 [8ED1748] (5.98.150.201)
[Thu Apr 1 2010 21:26:44.204448 3086882496]: accept success 11(5.98.150.201:4397)
[Thu Apr 1 2010 21:26:44.205599 3086882496]: 1.open user 11 [8ED1748] (5.98.150.201)
[Thu Apr 1 2010 21:26:44.359352 3078581152]: AuthRequest: UserID(test), Addr(5.98.150.201)
[Thu Apr 1 2010 21:27:04.576686 3086882496]: 1.close user 11 [8ED1748] (5.98.150.201)

---

GlobalDbAgent_Log;

Quote:

---

[Thu Apr 1 2010 21:25:49.480926 3086825152]: open log file '/var/log/cabal/GlobalDBAgent.log'
[Thu Apr 1 2010 21:25:49.481964 3086825152]: LOG LEVEL: 3
[Thu Apr 1 2010 21:25:49.482042 3086825152]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Apr 1 2010 21:25:49.485077 3086825152]: Start GlobalDBAgent Server
[Thu Apr 1 2010 21:25:49.488140 3086825152]: UseEcryptText (Off)
[Thu Apr 1 2010 21:25:49.508985 3086822304]: CProcessLayer(0)::svc Start [3086822304]
[Thu Apr 1 2010 21:25:49.509992 3076332448]: CProcessLayer(0)::svc Start [3076332448]
[Thu Apr 1 2010 21:25:49.510192 3065842592]: CProcessLayer(0)::svc Start [3065842592]
[Thu Apr 1 2010 21:25:49.513914 3086825152]: try listening 38180 port
[Thu Apr 1 2010 21:25:49.515110 3055352736]: CProcessLayer(0)::svc Start [3055352736]
[Thu Apr 1 2010 21:25:49.515982 3044862880]: CProcessLayer(0)::svc Start [3044862880]
[Thu Apr 1 2010 21:25:49.516139 3034373024]: CProcessLayer(0)::svc Start [3034373024]
[Thu Apr 1 2010 21:25:49.516987 3023883168]: CProcessLayer(0)::svc Start [3023883168]
[Thu Apr 1 2010 21:25:49.517115 3013393312]: CProcessLayer(0)::svc Start [3013393312]
[Thu Apr 1 2010 21:25:49.518105 3002903456]: CProcessLayer(0)::svc Start [3002903456]
[Thu Apr 1 2010 21:25:49.518923 2992413600]: CProcessLayer(0)::svc Start [2992413600]
[Thu Apr 1 2010 21:25:50.157835 3086825152]: accept success 8(127.0.0.1:33084)
[Thu Apr 1 2010 21:25:50.159818 3086825152]: 1.open user 8 [A0C0AA0] (127.0.0.1)
[Thu Apr 1 2010 21:25:55.223326 3086825152]: accept success 10(127.0.0.1:33092)
[Thu Apr 1 2010 21:25:55.225992 3086825152]: 2.open user 10 [A0CF1E0] (127.0.0.1)
[Thu Apr 1 2010 21:29:30.955284 3086822304]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 1 2010 21:29:30.955658 3086822304]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 1 2010 21:29:30.955689 3086822304]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 1 2010 21:29:30.960275 3086822304]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 1 2010 21:29:30.960719 3086822304]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 1 2010 21:29:30.960783 3086822304]: [##ERROR##] Database Connect Fail (uid=sa;pwd=cabalmssql;dsn=CabalAccount;APP=GlobalDBAgent)
[Thu Apr 1 2010 21:29:30.962624 3086822304]: [##ERROR##] check 'pDB' fail
[Thu Apr 1 2010 21:29:30.962697 3086822304]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:96)
[Thu Apr 1 2010 21:29:30.962738 3086822304]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(60:0:96) Addr(127.0.0.1)
[Thu Apr 1 2010 21:32:39.985011 3076332448]: [##ERROR##] DB ERROR(MSG) : [unixODBC][FreeTDS][SQL Server]Server is unavailable or does not exist.
[Thu Apr 1 2010 21:32:39.985127 3076332448]: [##ERROR##] DB ERROR(CODE) : 20009
[Thu Apr 1 2010 21:32:39.985469 3076332448]: [##ERROR##] DB ERROR(VAR_INFO) :
[Thu Apr 1 2010 21:32:39.985498 3076332448]: [##ERROR##] DB ERROR(SQLSTATE) : 08S01
[Thu Apr 1 2010 21:32:39.985526 3076332448]: [##ERROR##] DB ERROR(STM_TEXT) :
[Thu Apr 1 2010 21:32:39.985557 3076332448]: [##ERROR##] Database Connect Fail (uid=sa;pwd=cabalmssql;dsn=CabalAccount;APP=GlobalDBAgent)
[Thu Apr 1 2010 21:32:39.985591 3076332448]: [##ERROR##] check 'pDB' fail
[Thu Apr 1 2010 21:32:39.985618 3076332448]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:96)
[Thu Apr 1 2010 21:32:39.986027 3076332448]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(60:0:96) Addr(127.0.0.1)

---

server can't connect to your sql server,double check login details and turn off firewall

Hello

Hi yes it is looked up correctly
Login: sa
Passwd: cabalmssql

I use Sql Server 2005


I hope you / can you help me.

if im right where you have put the string in for the linked server you have done it wrong as where you have it (uid=sa;pwd=cabalmssql;dsn=CabalAccount;APP=Global DBAgent) you have got to put ur user and password where it says uid and pwd like this
DRIVER={SQL Server};SERVER=localhost;URUSERHERE=;YOURPWD=;

Hope it helps

Hello
If the problem is ok with the database error.
Ps it was the firewall [Windows] where I forgot to identify.

But now I get an error when I try to create an account in the database,

Command:
Exec dbo.cabal_tool_registeraccount 'REQUEST ACCOUNT', 'PASSWORD REQUEST'

Error message

Message 515, Level 16, State 2, Procedure cabal_tool_registerAccount, line 10
The value NULL can not be inserted into the 'password' column, 'ACCOUNT.dbo.cabal_auth_table' table. The column allows NULL values can not. Error in INSERT.
The statement has been terminated.
Message 515, Level 16, State 2, Procedure cabal_tool_registerAccount, line 16
The value NULL can not be inserted into the 'UserNum' column,' ACCOUNT.dbo.cabal_charge_auth 'table. The column allows NULL values can not. Error in INSERT.
The statement has been terminated.

(1 row (s) suffer)

Quote:

---

Originally Posted by skillzer

if im right where you have put the string in for the linked server you have done it wrong as where you have it (uid=sa;pwd=cabalmssql;dsn=CabalAccount;APP=Global DBAgent) you have got to put ur user and password where it says uid and pwd like this
DRIVER={SQL Server};SERVER=localhost;URUSERHERE=;YOURPWD=;

Hope it helps

---

chumpy said on his guide you don't need to push anything there, its in RED BOLD word too. if that a problem then we should all blame chumpy.

I had this same error Zero. I solved my issue with it by following Chumpys' advice and 1st deleting the stored procedure md5 in the SQL...2nd by deleting the md5.dll file all together out of the folder where I had put it and relocating it to another folder. 3rd, running the add stored proc again in sql query on master db. After you run the query again, do properties on the md5 procedure in the sql and check to make sure it has the right location where you put the .dll file. Hope this helps you.

1. Check pass sa they meet in mssql used cabalserver on centos or blank
2. Check Linled Servers in mssql.
Ex. A Linled Servers.
Select Enterprise Manager.
Choose Security>> Right-click Linled Servers>> New Linled Servers.
Input name GAMESERVER on the box.
Provider name, select Microsoft OLE DB Provider for ODBC Drivers.
Product name Input game.
Provider string input box DRIVER = (SQL Server); SERVER = localhost; UID =; PWD =;
Security page, select Be made using the login's current security context.
Server Options page, select true 5 options and press OK to finish.

Or, see this step by chumpywumpy. http://forum.ragezone.com/f460/cant-...d-this-486829/

I Sorry, not good English.

DRIVER = (SQL Server); SERVER = localhost; UID =; PWD =;
if i change SQL Server into something it won't work and SERVER=localhost into other IP it won't let me finished procedure.

if i leave it all like it works. but still cannot connect to my own servers. man this is the hardest and confusion server files i have ever faced. the whole server connection should be a lot easier.

so anyone know what i need it change it to (SQL Server)=?

i tried with hamachi no luck, because when installing hamachi on the centos i get an errors which requires some libraries files, such as libcryto.so.0..9.7..

Quote:

---

Originally Posted by john007

DRIVER = (SQL Server); SERVER = localhost; UID =; PWD =;
if i change SQL Server into something it won't work and SERVER=localhost into other IP it won't let me finished procedure.

if i leave it all like it works. but still cannot connect to my own servers. man this is the hardest and confusion server files i have ever faced. the whole server connection should be a lot easier.

so anyone know what i need it change it to (SQL Server)=?

i tried with hamachi no luck, because when installing hamachi on the centos i get an errors which requires some libraries files, such as libcryto.so.0..9.7..

---

Make sure when you do that server is stopped!!!

there are steps missed out in chumpy's guide actually.

do not put in ur username n password in the linked server parameters, u need to set the permission for the user to access the linked server.

regarding the cannot create account, the stored procedure is abit flawed with wrong table names, just edit the cabal_tool_registerAccount and fix the proper table name. 2 or 3 table names in that sp is wrong.

Both xp_md5 and the linked server are actually redundant these days.

xp_md5 replacement (32 and 64 bit):
http://forum.ragezone.com/f459/fix-l...64-dll-608699/

Linked server removal:
http://forum.ragezone.com/f460/how-t...server-576629/