Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 18:55

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


SQL Linked Database Error

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2008
Posts: 18
Received Thanks: 1
SQL Linked Database Error

Been running into a few problems setting up a server to play around on but I'm stuck at the moment. Any suggestions/advise would be great.

I am getting this error when starting the server.
epvpImg: *burp*, images are delicious.

I know it has to do with the queries you need to add to link the databases so i went back to redo just that step but it will tell me each time their are already entries there. Also I have adjusted my paging files to 6,000 and i have 4gig of ram so i believe the end error is only caused by the first set of errors occuring.



Xapphire is offline  
Old 01/28/2013, 13:43   #2
 
elite*gold: 0
Join Date: Mar 2008
Posts: 205
Received Thanks: 23
You forgot to run the SN scripts

Start>Programs>Windows SQL Server>Query Analyzer.

And run thoes scripts there:

Code:
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=;'
Q2
Code:
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'
That should fix your problem.


If it's not working, than restore agian the databases, and set up all from the begin.


lifs2000 is offline  
Old 01/29/2013, 02:49   #3
 
elite*gold: 0
Join Date: Nov 2008
Posts: 18
Received Thanks: 1
Gone through and did a fresh install as I've ran those queries still no success on the front I am following this guide

Code:
http://www.dkunderground.org/forums/topic/751-mssql-sql-server-2008-installation-dekaron-db-setup/
Any other ideas?
Xapphire is offline  
Old 02/28/2013, 10:37   #4
 
elite*gold: 0
Join Date: Feb 2013
Posts: 1
Received Thanks: 0
RecoveryFIX for SQL Database Recovery retrieves all data stored within SQL server .MDF files such as tables, triggers, views, stored procedures with damaged unique keys, primary keys and foreign keys. Deleted files are also successfully recovered and saved in a separate batch file for further use.



Thanks


davegeeit is offline  
Old 04/29/2018, 12:52   #5
 
elite*gold: 0
Join Date: Jul 2016
Posts: 1
Received Thanks: 0
[IMG=expandable: 1, title: Please Help]C:\Capture.png[/IMG]


khemz18 is offline  
Reply



« want to buy dekaronserver action6 | [DEKARON]Quest Transup Fixed All Class »

Similar Threads
WTB 50/50 GWAMM, non-NCSoft linked or WTT WoW CE account not linked to battle.net
06/22/2012 - Guild Wars Trading - 0 Replies
Hi, 1.) I am looking for a 50/50 GWAMM account, not linked to an NCSoft master account, must have all CD-KEYS and must provide security questions/answers. I am willing to pay around $400USD. 2.) I am also interested in accounts that are 40/50 and over that apply to the guidelines above. PM me with a price.
Database U1 Error
05/08/2011 - Flyff PServer - Discussions / Questions - 0 Replies
Hi ich hab nen problem woran könnte es liegen das ich den error query:{call CHARACTER_STR('U1','0000001','01','',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} SQLSTATE:22001 error:Die Zeichenfolgedaten wurden rechts abgeschnitten bekomme.
[HELP] DataBase Error
09/12/2008 - CO2 PServer - Discussions / Questions - 1 Replies
http://img261.imageshack.us/img261/739/databaseerrortw9.png İ use Steals Server Pack What is wrong here ?? -- phpMyAdmin SQL Dump -- version 2.10.3 -- http://www.phpmyadmin.net --
WBB Linked msql Database
04/13/2007 - Technical Support - 0 Replies
Ich suche ein Modul, Hack or whatever für Xoops 2 um die Database von meinem Woltlab Burning Board 2.3.3 mit der von Xoops 2 zu verbinden. Also ums genauer zu erkläutern: Das Board hat schon eine komplette Database die vorhanden bleiben soll, und diese Database soll mit der von Xoops 2 gelinked werden. Wär nice wenn jemand vielleicht ein Anhaltspunkt hat, denn ich find gar nichs hab schon auf diversen Seite gesucht. Gruß



All times are GMT +1. The time now is 18:55.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.