|
You last visited: Today at 19:47
Advertisement
SQL Error
Discussion on SQL Error within the Dekaron Private Server forum part of the Dekaron category.
09/25/2019, 15:57
|
#1
|
elite*gold: 0 
Join Date: Nov 2016
Posts: 8
Received Thanks: 0
|
SQL Error
|
|
|
|
09/25/2019, 17:42
|
#2
|
elite*gold: 50
Join Date: May 2011
Posts: 184
Received Thanks: 137
|
|
|
|
|
|
10/21/2019, 06:08
|
#3
|
elite*gold: 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
|
|
|
|
|
10/21/2019, 23:49
|
#4
|
elite*gold: 0
Join Date: Feb 2016
Posts: 229
Received Thanks: 64
|
How do you change MSDASQL to SQLNCLI10?
|
|
|
|
|
10/22/2019, 01:12
|
#5
|
elite*gold: 50
Join Date: May 2011
Posts: 184
Received Thanks: 137
|
Quote:
Originally Posted by nemesidevmv
How do you change MSDASQL to SQLNCLI10?
|
Look at his query where it says SQLNCLI10, normally MSDASQL is there.
|
|
|
|
 |
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 +1. The time now is 19:48.
|
|
