Register for your free account! | Forgot your password?

You last visited: Today at 10:38

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

SQL Error

Discussion on SQL Error within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2016
Posts: 8
Received Thanks: 0
SQL Error



My sessionLogin is crashing after this message.. I did everything right in the sql ,what is the issue?
makore1 is offline  
Old   #2
 
thirdeye42's Avatar
 
elite*gold: 50
The Black Market: 0/0/0
Join Date: May 2011
Posts: 184
Received Thanks: 137



thirdeye42 is offline  
Old   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Dec 2017
Posts: 11
Received Thanks: 1
1. your need sql 2008r2
2. delete old linkedserver or you restore new DB
3. change driver provider from MSDASQL to SQLNCLI10
Code:
EXEC sp_addlinkedserver 'LSV_GHBILL','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','SQLNCLI10',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','SQLNCLI10',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','SQLNCLI10',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','SQLNCLI10',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'


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'

enjoy

by [DEV]fndemo
harumiharumi01 is offline  
Thanks
1 User
Old   #4
 
nemesidevmv's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2016
Posts: 232
Received Thanks: 64
How do you change MSDASQL to SQLNCLI10?
nemesidevmv is offline  
Old   #5
 
thirdeye42's Avatar
 
elite*gold: 50
The Black Market: 0/0/0
Join Date: May 2011
Posts: 184
Received Thanks: 137
Quote:
Originally Posted by nemesidevmv View Post
How do you change MSDASQL to SQLNCLI10?
Look at his query where it says SQLNCLI10, normally MSDASQL is there.
thirdeye42 is offline  
Reply

« DekaronServer.exe Error | NEED HELP with Shangri_la Server [SQL] Account »

Similar Threads Similar Threads
ERROR: GAME DB INIT ERROR : [DBNETLIB][ConnectionOpen (Connect()).]Specified SQL serv
08/06/2013 - Rappelz Private Server - 5 Replies
Hallo :D:D ich habe ein Problem, und zwar kommt bei mir immer diese Fehlermeldung wenn ich den CaptainHerlockServer starte ,,ERROR: GAME DB INIT ERROR : Ungültige Autorisierungsangab." Ich habe zwar schon etwas darüber gelesen, doch nur auf englisch und die meinte etwas über die DB files :confused::confused::confused: doch ich habe keine ahnung wo ich diese Files herbekomme, bitte um schnelle Hilfe Danke! :):)
[SQL-Error]Sql Database For HellmouthSoruce
04/28/2011 - CO2 Private Server - 10 Replies
Hello, i was setting up the Hellmouth source 5300+ everything was going smoothly and because i'm stupid and noob + i never used/liked navicat i got error when trying to execute the sql databse and here's the error http://www.youtube.com/watch?v=op25Gz_X3Wg
[SQL Error] Sql server 2000
01/02/2011 - Dekaron Private Server - 2 Replies
Enterprice Manager, launching today, I got the following message http://img10.imageshack.us/img10/3899/sqlerrors.j pg Anyone of you knows how to fix it OK problem solved. If anyone of you comes across this problem. Just run from the Start Menu-> Programs-> Microsoft SQL Server-> Server Network Utility and disable the Force Protocol Encryption, and Winsock Proxy Click Apply and OK Topic CLOSE
[Help]I cant find SQL 2000+SP4... and janvier`s sql has some error...
10/07/2009 - Dekaron Private Server - 9 Replies
can some1 give me SQL 2000+SP4 dl link plz? :O thanks for helping



All times are GMT +2. The time now is 10:38.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.