Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 15:31

  • 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   #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   #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   #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   #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



« Previous Thread | Next Thread »

Similar Threads
WTB 50/50 GWAMM, non-NCSoft linked or WTT WoW CE account not linked to battle.net
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...
0 Replies - Guild Wars Trading
Database U1 Error
Hi ich hab nen problem woran könnte es liegen das ich den error query:{call...
0 Replies - Flyff PServer - Discussions / Questions
[HELP] DataBase Error
http://img261.imageshack.us/img261/739/databaseerrortw9.png İ use Steals Server Pack What is wrong here ?? -- phpMyAdmin SQL Dump --...
1 Replies - CO2 PServer - Discussions / Questions
WBB Linked msql Database
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...
0 Replies - Technical Support



All times are GMT +2. The time now is 15:31.


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.