Problem witch SMC

**pablitto15** · 16-01-15

i convert the password in MD5

and i have open the ports.

- - - Updated - - -

Its Ok This ?

2015-01-20_FatalLog

2015-01-20 04:22:10 [GlobalManager] server cord established : 1 (192.168.1.10:32000)
2015-01-20 04:22:12 [GlobalManager] GlobalManager is initialized successfully
2015-01-20 04:22:14 [GlobalManager] server cord established : 2 (192.168.1.10:49228)
2015-01-20 04:22:14 [DownloadServer] server cord established : 1 (192.168.1.10:15880)
2015-01-20 04:22:14 [DownloadServer] DownloadServer is initialized successfully
2015-01-20 04:22:17 [GlobalManager] server cord established : 3 (192.168.1.10:49229)
2015-01-20 04:22:17 [GatewayServer] lpfnSetDllCrtHeapLfh Call LFH Set Success
2015-01-20 04:22:17 [GatewayServer] It has been succeeded to initialize CJmxHttpClientMgr
2015-01-20 04:22:17 [GatewayServer] server cord established : 1 (192.168.1.10:15880)
2015-01-20 04:22:17 [GatewayServer] GatewayServer is initialized successfully
2015-01-20 04:22:18 [GlobalManager] server cord established : 4 (192.168.1.10:49230)
2015-01-20 04:22:19 [FarmManager] server cord established : 1 (192.168.1.10:15880)
2015-01-20 04:22:19 [FarmManager] FarmManager is initialized successfully
2015-01-20 04:22:20 [FarmManager] server cord established : 2 (192.168.1.10:49231)
2015-01-20 04:22:20 [AgentServer] server cord established : 1 (192.168.1.10:15882)
2015-01-20 04:22:20 [AgentServer] AgentServer is initialized successfully
2015-01-20 04:22:24 [GlobalManager] server cord established : 5 (192.168.1.10:49235)
2015-01-20 04:22:25 [MachineManager] server cord established : 1 (192.168.1.10:15880)
2015-01-20 04:22:25 [MachineManager] MachineManager is initialized successfully
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [FarmManager] server cord established : 3 (192.168.1.10:49237)
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2015-01-20 04:22:26 [SR_ShardManager] server cord established : 1 (192.168.1.10:15882)
2015-01-20 04:22:28 [SR_ShardManager] server cord established : 2 (192.168.1.10:49239)
2015-01-20 04:22:28 [AgentServer] server cord established : 2 (192.168.1.10:15883)
2015-01-20 04:22:29 [FarmManager] server cord established : 4 (192.168.1.10:49241)
2015-01-20 04:22:29 [SR_GameServer] server cord established : 1 (192.168.1.10:15882)
2015-01-20 04:22:29 [SR_GameServer] server cord established : 2 (192.168.1.10:49240)
2015-01-20 04:22:29 [AgentServer] server cord established : 3 (192.168.1.10:15885)
2015-01-20 04:22:30 [SR_ShardManager] server cord established : 3 (192.168.1.10:49242)
2015-01-20 04:22:30 [SR_GameServer] server cord established : 3 (192.168.1.10:15883)
2015-01-20 04:22:47 [SR_ShardManager] Not found RefServerEvent[30001]. Check service and date value. progress next data
2015-01-20 04:22:47 [SR_ShardManager] Not found RefServerEvent[30002]. Check service and date value. progress next data
2015-01-20 04:22:47 [SR_ShardManager] Not found RefServerEvent[30003]. Check service and date value. progress next data
2015-01-20 04:22:47 [SR_ShardManager] Not found RefServerEvent[30004]. Check service and date value. progress next data
2015-01-20 04:22:47 [SR_ShardManager] SR_ShardManager is initialized successfully
2015-01-20 04:22:48 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 0
2015-01-20 04:22:48 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 0
2015-01-20 04:22:48 [SR_GameServer] At initialize Server, Loading Siege data :: CurrentTax = 0
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,95) -> (141,95)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,95) -> (141,96)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,95) -> (141,94)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,96) -> (141,96)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,96) -> (141,97)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,96) -> (141,95)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,98) -> (141,98)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,98) -> (141,99)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,98) -> (141,97)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,99) -> (141,99)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,99) -> (141,100)]
2015-01-20 04:23:07 [SR_GameServer] LINK_REGION ERROR [(142,99) -> (141,98)]
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QSP_ALL_POTION_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_5)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_7)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_9)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_11)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QEV_ALL_BASIC_12)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_001)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_002)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_003)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_004)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_005)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_006)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_007)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_008)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_009)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_010)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_011)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_012)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_013)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_014)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_015)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_016)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_017)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_018)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_019)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_020)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_021)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_022)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_023)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_024)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_025)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_026)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_027)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_028)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_029)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_030)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_031)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_032)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_033)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_034)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_035)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_036)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_037)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_038)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_039)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_PLUS_040)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_CHEF_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SOLDIER_EA1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_POTION_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SOLDIER_EA2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_BO_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_SP_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_HORSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SPECIAL_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_SW_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_POTION_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_EUROPE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_BO_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SMITH_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_EUROPE_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_FERRY2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_GENARAL_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SPECIAL_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SMITH_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CH_SPECIAL_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_POTION_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_HORSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_ACCESSORY_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SPECIAL_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_WAREHOUSE_W_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_DOCTOR_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_HORSE_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_FERRY2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SPECIAL_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_DOCTOR_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SOLDIER_EA1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SOLDIER_EA2_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_ACCESSORY_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_HORSE_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SOLDIER_WE1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_FERRY3_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SMITH_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SMITH_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_DOCTOR_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_GENARAL_SW_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_GENARAL_SW_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_FERRY4_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_POTION_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SOLDIER_WE2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_MANAGER_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_WAREHOUSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_SOLDIER_SO1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_ARMOR_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_POTION_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_SMITH_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_KT_SOLDIER_WE2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_SOLDIER_EA2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_GENARAL_BO_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_WAREHOUSE_M_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_PRIEST2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_GENARAL_SP_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_WC_GENARAL_SW_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_5)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_8)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_9)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_10)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_CONS_12)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_6)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_7)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_10)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_16)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_18)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_20)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_EASTEU_13)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_WAREHOUSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_FERRY2_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_AM_FERRY1_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_GENERAL_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_PRIEST_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_GENERAL_4)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_GENERAL_5)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_SOLDIER_EA2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_GENERAL_6)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_EU_HORSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_HORSE_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_HUNTER_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_AM_FERRY1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_HORSE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_THIEF_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_THIEF_6_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_THIEF_6_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_TREASURE_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_TREASURE_2)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_MERCHANT_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_GORIA_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_GORIA_4)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_GORIA_5)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_THIEF_3)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_POTION_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_SPECIAL_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_SOLDIER_EA2_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_SOLDIER_SO1_1)
2015-01-20 04:23:15 [SR_GameServer] Try push not service quest(QNO_CA_TREASURE_3)
2015-01-20 04:23:16 [SR_GameServer] Not found RefServerEvent[30001]. Check service and date value. progress next data
2015-01-20 04:23:16 [SR_GameServer] Not found RefServerEvent[30002]. Check service and date value. progress next data
2015-01-20 04:23:16 [SR_GameServer] Not found RefServerEvent[30003]. Check service and date value. progress next data
2015-01-20 04:23:16 [SR_GameServer] Not found RefServerEvent[30004]. Check service and date value. progress next data
2015-01-20 04:23:16 [SR_GameServer] SR_GameServer is initialized successfully
2015-01-20 04:23:53 [GlobalManager] Query Error!!! Query Result : -1, Query : exec _CertifyUser 'nayman','9bc9ccc1fae5c0d9e073343bac77d56b','d41d8cd98f00b204e9800998ecf8427e'
2015-01-20 04:23:53 [GlobalManager] SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SRO_AccountDB.dbo.TB_User'.
2015-01-20 04:23:53 [GlobalManager] exec _CertifyUser 'nayman','9bc9ccc1fae5c0d9e073343bac77d56b','d41d8cd98f00b204e9800998ecf8427e'

**MentaL**

**pablitto15** · 17-01-15

uuuuuuuuupppppppppppp

**Caosfox** · 17-01-15

a little more info?

ports are ok? firewall is open for conection? any error at server modules when you try to log in at smc?

**mapunsa** · 18-01-15

i face the same problem and i searched a lot until i noticed it

make sure that u made MD5 for your pw....

**pablitto15** · 18-01-15

Uppppppppppppp

**pablitto15** · 20-01-15

uuuuppppp

**pablitto15** · 20-01-15

i solve this, i use this query

USE [SRO_R_Accountdb]
GO
/****** Object: StoredProcedure [dbo].[_CertifyUser] Script Date: 01/03/2015 13:10:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_CertifyUser]
@szUserID VARCHAR(25),
@szPassword VARCHAR(50),
@szSSNumber VARCHAR(32)
AS
DECLARE @nUserJID INT
DECLARE @sec_primary tinyint
DECLARE @sec_content tinyint
SET @nUserJID = 0
SET @sec_primary = 0
SET @sec_content = 0
IF (NOT EXISTS(SELECT JID FROM TB_User WHERE StrUserID = @szUserID))
BEGIN
SELECT CONVERT( INT, 0), CONVERT( tinyint, 0), CONVERT( tinyint, 0)
RETURN
END
SELECT @nUserJID = JID FROM TB_User WHERE StrUserID = @szUserID
IF (@nUserJID = 0 OR @nUserJID IS NULL OR @@error <> 0 OR @@rowcount = 0)
BEGIN
SELECT CONVERT( INT, 0), CONVERT( tinyint, 0), CONVERT( tinyint, 0)
RETURN
END
IF (NOT EXISTS(SELECT JID FROM TB_User WHERE JID = @nUserJID AND password = @szPassword))
BEGIN
SELECT CONVERT( INT, 0), CONVERT( tinyint, 0), CONVERT( tinyint, 0)
RETURN
END

SELECT @sec_primary = sec_primary, @sec_content = sec_content FROM dbo.TB_User WITH (nolock) WHERE JID = @nUserJID
SELECT @nUserJID, @sec_primary, @sec_content

Problem witch SMC

Thread Tools

Problem witch SMC

Re: Problem witch SMC

Re: Problem witch SMC

Re: Problem witch SMC

Re: Problem witch SMC

Re: Problem witch SMC

Re: Problem witch SMC

Advertisement