데카론 9캐릭용[서버파일]

댓글2

• 0

  마에노

  2017.01.19 - 22:10 #396695

  디비연결해주신담에
  쿼리분석기로 아래 쿼리 돌려주시고요

  Use master;
  Go
  EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
  EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

  Use master;
  Go
  exec sp_serveroption 'LSV_GHBILL','rpc out','true'
  exec sp_serveroption 'LSV_GHBILL','rpc','true'
  exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
  exec sp_serveroption 'LSV_DKRACNT','rpc','true'
  exec sp_serveroption 'DKRCASH','rpc out','true'
  exec sp_serveroption 'DKRCASH','rpc','true'
  exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
  exec sp_serveroption 'LSV_DKRHELION','rpc','true'
  exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
  exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
  exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
  exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
  exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
  exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
  exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
  exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
  exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
  exec sp_serveroption 'LSV_DKRTEST','rpc','true'
  exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
  exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
  exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
  exec sp_serveroption 'LSV_DKRSTA','rpc','true'
  exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
  exec sp_serveroption 'DKRACCOUNT01','rpc','true'

  MD5활성화를 위해 아래 쿼리 돌려주세요(쿼리 분석기)
  Use account;
  Go
  ---Account Query By Warmonger---
  DECLARE @UserNO varchar(16), @AccountID varchar(16), @Password  varchar(32), @Email varchar(50), @SecretA varchar(22), @SecretQ  varchar(22)
  SET @UserNO= '09101410275532'
  SET @AccountID = 'Account ID'
  SET @Password = 'Account Password'
  SET @Email = 'E-Mail'
  SET @SecretA = 'Secret Answer'
  SET @SecretQ = 'Secret Question'
   
  Insert Into [USER_PROFILE] Values  (@UserNO,@AccountID,@Password,'801011000000','1','0','Y','01/01/2006  00:00:00',null,null,null,'000')

  다음 ODBC를 SYStem DSN 에 디비명과 같이 연결해주시고요

  안에 서버와 관련된 파일들 메모장으로 열어 아이피 전부수정하시고 서버구동해주세요
• 0

  조아이씨

  2017.01.26 - 14:32 #406276

  이거 9캐릭용 아닌데요...