[Video Tutorials] Shaiya EP4 Private Server By Omega

Linxis172 · 05/08/2011, 00:50

Feel free to help if you, but when i open up Microsoft SQL Server Management Studio Express and try to connect it gives me this:

Code:

TITLE: Connect to Server
------------------------------

Cannot connect to AJShaiya.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server.
 The server was not found or was not accessible. Verify that the instance name is correct and that
 SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 -
 Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL
+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476


------------------------------

BUTTONS:


OK

------------------------------

At first i went to my SQL Server Configuration Manager and checked every protocol, i found that one of my IPs wasnt enabled so i enabled it. I applied it and opened Microsoft SQL Server Management Studio Express again and tried to connect. But that same error came up.

EDIT: Problem fixed. SQL forgot to install something.
Solution, removing every file that had to do anything with that SQL install and reinstalling again.

Aketchi · 05/08/2011, 06:05

@haxa3d

You better read the first post s no one will do the worke for you so if you want to run a server try it by your self you have all wat you need here in this Forum

in case you ar from germany here is the post in german

Pass auf keiner setzt sich hin und macht dir die ganze arbeit wen du nen server willst dan setz dich hin und mach selbst was alles was du brauchst hast du hir im forum also solltest du s erst mal versuchen befor du hier so sinnfrei post s verfasst

LG Aketchi

Svinseladden · 05/08/2011, 09:51

Quote:

Originally Posted by Aketchi

Here ar my Next question on you guy s how exeley i change the parts to the server because if i tray to instal the server by Klicking on server install it givs me error s that the programm cant found the datas i need

my shaiya_db_restore File lock like ths if i open it to edit so wath i have to do if for exampel my server is on my /C Drive ?? Pleace help everting alse works perfect ^^

Here it is :

@ECHO OFF
ECHO.> temp.sql

ECHO RESTORE DATABASE OMG_GameWEB FROM DISK = '%~dpf1\OMG_GameWEB' WITH REPLACE,>> temp.sql
ECHO MOVE 'OMG_GameWEB_Data' TO 'C:\ShaiyaServer\DATABASE\OMG_GameWEB.mdf',>> temp.sql
ECHO MOVE 'OMG_GameWEB_Log' TO 'C:\ShaiyaServer\DATABASE\OMG_GameWEB.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_Billing FROM DISK = '%~dpf1\PS_Billing' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_Billing_Data' TO 'C:\ShaiyaServer\DATABASE\PS_Billing.mdf',>> temp.sql
ECHO MOVE 'PS_Billing_Log' TO 'C:\ShaiyaServer\DATABASE\PS_Billing.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_ChatLog FROM DISK = '%~dpf1\PS_ChatLog' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_ChatLog_Data' TO 'C:\ShaiyaServer\DATABASE\PS_ChatLog.mdf',>> temp.sql
ECHO MOVE 'PS_ChatLog_Log' TO 'C:\ShaiyaServer\DATABASE\PS_ChatLog.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_GameData FROM DISK = '%~dpf1\PS_GameData' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_GameData_Data' TO 'C:\ShaiyaServer\DATABASE\PS_GameData.mdf',>> temp.sql
ECHO MOVE 'PS_GameData_Log' TO 'C:\ShaiyaServer\DATABASE\PS_GameData.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_GameDefs FROM DISK = '%~dpf1\PS_GameDefs' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_GameDefs_Dat' TO 'C:\ShaiyaServer\DATABASE\PS_GameDefs.mdf',>> temp.sql
ECHO MOVE 'PS_GameDefs_Log' TO 'C:\ShaiyaServer\DATABASE\PS_GameDefs.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_StatData FROM DISK = '%~dpf1\PS_StatData' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_StatData_Data' TO 'C:\ShaiyaServer\DATABASE\PS_StatData.mdf',>> temp.sql
ECHO MOVE 'PS_StatData_Log' TO 'C:\ShaiyaServer\DATABASE\PS_StatData.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_Statics FROM DISK = '%~dpf1\PS_Statics' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_Statics_Data' TO 'C:\ShaiyaServer\DATABASE\PS_Statics.mdf',>> temp.sql
ECHO MOVE 'PS_Statics_Log' TO 'C:\ShaiyaServer\DATABASE\PS_Statics.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_UserData FROM DISK = '%~dpf1\PS_UserData' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_UserData_Data' TO 'C:\ShaiyaServer\DATABASE\PS_UserData.mdf',>> temp.sql
ECHO MOVE 'PS_UserData_Log' TO 'C:\ShaiyaServer\DATABASE\PS_UserData.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_GameLog FROM DISK = '%~dpf1\PS_GameLog' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_GameLog_Data' TO 'C:\ShaiyaServer\DATABASE\PS_GameLog.mdf',>> temp.sql
ECHO MOVE 'PS_GameLog_Log' TO 'C:\ShaiyaServer\DATABASE\PS_GameLog.ldf';>> temp.sql

ECHO RESTORE DATABASE PS_GMTool FROM DISK = '%~dpf1\PS_GMTool' WITH REPLACE,>> temp.sql
ECHO MOVE 'PS_GMTool_Dat' TO 'C:\ShaiyaServer\DATABASE\PS_GMTool.mdf',>> temp.sql
ECHO MOVE 'PS_GMTool_Log' TO 'C:\ShaiyaServer\DATABASE\PS_GMTool.ldf';>> temp.sql

CLS
osql -E -i temp.sql
DEL temp.sql
PAUSE
@exit

all your stuff is in c: you can see that it's in C:\ShaiyaServer and so on. if you want to have that in d: or eve e: you need to change that path c:/ to wherever you have your files

Svinseladden · 05/08/2011, 09:57

Quote:

Originally Posted by haxa3d

ken one make me a server and then give me by me is not going ... pls im need help

LOL you realy mean that someone is going to hand over there server to you? you need to know what your doing how can you then fix buggs and so on when that time comes? adding drop,make accounts and so on? i think it was Bane that said this the best. if you don't know what your doing, it's not a good idea to do it. there is alot of truth in that.. becouse when you have the server online your not done..

Aketchi · 05/08/2011, 12:40

I just have on problem left for example i will show wath s unclear for me

First This it s the Top part of the shaiya Restore bd
do i have change enything here ??

@ECHO OFF
ECHO.> temp.sql

The secaound one is the bottom part of the shaiya restore bd
is maby enithing to change there??

CLS
osql -E -i temp.sql
DEL temp.sql
PAUSE
@exit

and this on here too

ECHO RESTORE DATABASE OMG_GameWEB FROM DISK = '%~dpf1\OMG_GameWEB' WITH REPLACE,>> temp.sql

Maby some one can help oh importent to knowe is i donte have evene that Database folder i dont knowe if thats importent everithing else works perfect ^^

Thank you

Lan-Lan · 05/08/2011, 17:08

Hello,
I've a problem: I can log in as admin, create/select a char, but when I click on 'start' I have a error: "connection with server has been disconnected ERROR 0"
I found that someone had the same error in this topic, but I don't find a good answer.

I have done everything as the video says, and don't made any update of the client.

Ps: I want a local server, that run only on my pc, so I used my local IP...

ps_dbAgent.ini

Spoiler

ps_game.ini

Spoiler

ps_gameLog.ini

Spoiler

ps_gamewar.ini

Spoiler

ps_login.ini

Spoiler

ps_session.ini

Spoiler

ps_userlog.ini

Spoiler

... Thanks for your help

Svinseladden · 05/08/2011, 18:59

Quote:

Originally Posted by Lan-Lan

Hello,
I've a problem: I can log in as admin, create/select a char, but when I click on 'start' I have a error: "connection with server has been disconnected ERROR 0"
I found that someone had the same error in this topic, but I don't find a good answer.

I have done everything as the video says, and don't made any update of the client.

Ps: I want a local server, that run only on my pc, so I used my local IP...

ps_dbAgent.ini

Spoiler

ps_game.ini

Spoiler

ps_gameLog.ini

Spoiler

ps_gamewar.ini

Spoiler

ps_login.ini

Spoiler

ps_session.ini

Spoiler

ps_userlog.ini

Spoiler

... Thanks for your help

have you put in /NPROTECTOFF in the game command? have you disable the uca if you have vista og windows 7? run everything as admin if you have vista or windows 7..

Svinseladden · 05/08/2011, 19:02

Quote:

Originally Posted by Aketchi

I just have on problem left for example i will show wath s unclear for me

First This it s the Top part of the shaiya Restore bd
do i have change enything here ??

@ECHO OFF
ECHO.> temp.sql

The secaound one is the bottom part of the shaiya restore bd
is maby enithing to change there??

CLS
osql -E -i temp.sql
DEL temp.sql
PAUSE
@exit

and this on here too

ECHO RESTORE DATABASE OMG_GameWEB FROM DISK = '%~dpf1\OMG_GameWEB' WITH REPLACE,>> temp.sql

Maby some one can help oh importent to knowe is i donte have evene that Database folder i dont knowe if thats importent everithing else works perfect ^^

Thank you

don't know about this one. but do you realy need the OMG_gameweb? think someone said you didn't need it. try without..

run all bat files as admin too.

Aketchi · 05/09/2011, 20:56

Hello Agen ^^

i know it seem s i anoy you guy s but i really cant fix that by my owne
so here ar my problems and questions

Thing s you have to know

1. everithing i did was thet same as schown in the video tut of omega

2. i post how my shaiya restore bd look like a view post s before

3. every singel programm i installt and use i runn as Admin (use windows 7)

Questions

1. wath exacle i have change in the shaiya restore bd ?? use my post befor and mark the part s i have to change in... any color

2. do i have to change somthing in the server instal file ??

BUG s and ERROR s

1 if i try to run the Instal server bd as Admin
this messages ar shown

... cant found be sure the name of this data i rght and repeat the actiom
(Translation from german in englisch )

- batch/ shaiya_db_restore cant found
- config_d atabase.bat
- shaiya_svn_register.bat
- PSMServer_mgr.exe

2. if i try to run it normal

well it a lot of text so i have to right it down somtime ^^

but it like accses inditet and a menny error s by creating datas the server manga opens after this but

the point database and all sup point s ar yellow only the first to point s in the list ar red X

so that s my problem i hope really you can help otherwise send this post around maby some one now a answer on my questions

ill thank you in the first place for helping

LG Aketchi

~~×X×™~~ · 05/11/2011, 12:11

@Video Part 2 ...
After restarting computer, and send PSMServer_Mgr to Desktop and open it... But I see red crosses, not green crosses ... What I should do

?
please help me!

ShaiyaOmega · 05/12/2011, 03:41

Quote:

Originally Posted by ×X×™

@Video Part 2 ...
After restarting computer, and send PSMServer_Mgr to Desktop and open it... But I see red crosses, not green crosses ... What I should do ?
please help me!

Press Alt+Ctrl+Del
Check to see if PSM_Agent.exe and PSMServer_Agent.exe are running if not you will need to run C:\ShaiyaServer\SERVER\batch\shaiya_svc_register.b at Then Server Setup Button on PSMServer_Mgr then Apply Windows Registry and restart your computer.

Alternate way is to run
C:\ShaiyaServer\SERVER\PSM_Server\PSMServer_Servic eMgr.exe Click Install and then run. Then
C:\ShaiyaServer\SERVER\PSM_Client\PSM_ServiceMgr.e xe and make sure all are installed and at least PSM_AgentClient is started. Good Luck

Svinseladden · 05/12/2011, 09:44

Quote:

Alternate way is to run
C:\ShaiyaServer\SERVER\PSM_Server\PSMServer_Servic eMgr.exe Click Install and then run. Then
C:\ShaiyaServer\SERVER\PSM_Client\PSM_ServiceMgr.e xe and make sure all are installed and at least PSM_AgentClient is started. Good Luck

i need to run that sometimes only thing that works. but just on some computers..

~~×X×™~~ · 05/12/2011, 11:13

Quote:

Originally Posted by ShaiyaOmega

Press Alt+Ctrl+Del
Check to see if PSM_Agent.exe and PSMServer_Agent.exe are running if not you will need to run C:\ShaiyaServer\SERVER\batch\shaiya_svc_register.b at Then Server Setup Button on PSMServer_Mgr then Apply Windows Registry and restart your computer.

Alternate way is to run
C:\ShaiyaServer\SERVER\PSM_Server\PSMServer_Servic eMgr.exe Click Install and then run. Then
C:\ShaiyaServer\SERVER\PSM_Client\PSM_ServiceMgr.e xe and make sure all are installed and at least PSM_AgentClient is started. Good Luck

@the first option, I looked but didn't find PSM_Agent.exe and PSMServer_Agent.exe, then I run shaiya_svc_register.bat, pressed any key... I looked again to find it, but still there wasn't anything like that... Ok I thought... hmm ... I run PSMServer_Mgr and apply windows registry... restartet computer and it was still red...

Then I made the alternative way... I opened PSMServer_Service_Mrg.exe ... I could only click on "Uninstall" and on "Start" ... But I didn't clicked on anything... The name of the file was "(S) PSM_AgentServer"... it was already installed, right? So I didn't could make that with this alternative... so there are still the red crosses

Could you help me per TeamViewer? Skype? Or something else?

Moonheart · 05/12/2011, 13:33

I can't get the install_server file to work correctly. When I tell it to run as administrator, it says it cannot find the batch files so it does not start. When I run it regularly, it says access denied at the end. I also have gotten messages such as, there is already an instance... What can I do? thanks

ShaiyaOmega · 05/12/2011, 18:35

Quote:

Originally Posted by ×X×™

Then I made the alternative way... I opened PSMServer_Service_Mrg.exe ... I could only click on "Uninstall" and on "Start" ... But I didn't clicked on anything... The name of the file was "(S) PSM_AgentServer"... it was already installed, right? So I didn't could make that with this alternative... so there are still the red crosses

Alternate way is to run
C:\ShaiyaServer\SERVER\PSM_Server\PSMServer_Servic eMgr.exe Click Install and then run. <<< That means click start Then
C:\ShaiyaServer\SERVER\PSM_Client\PSM_ServiceMgr.e xe and make sure all are installed and at least PSM_AgentClient is started.

Quote:

Originally Posted by Moonheart

I can't get the install_server file to work correctly. When I tell it to run as administrator, it says it cannot find the batch files so it does not start. When I run it regularly, it says access denied at the end. I also have gotten messages such as, there is already an instance... What can I do? thanks

Right Click on All .bat files (Including the ones in the batch folder) and replace "%dir_install%" with "C:\ShaiyaServer\" without the quotes. then retry.

For some reason some Windows 7 and Vista machine have a hard time understanding the %dir_install% Command.