[Video Tutorials] Shaiya EP4 Private Server By Omega
Discussion on [Video Tutorials] Shaiya EP4 Private Server By Omega within the Shaiya PServer Development forum part of the Shaiya Private Server category.
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.
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
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
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..
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 ^^
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...
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...
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..
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..
@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!
@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
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..
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?
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
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.
[REQUEST]How to make Shaiya Private Server Ep4 Video 09/29/2016 - Shaiya Private Server - 4 Replies I would appreciate it greatly if someone would make a private server and record it with hypercam or something, its a lot easier to do this stuff for me and to remember stuff if I see whats going on. A lot of people are bad at reading instructions like me, so I figure someone could get a lot of reputation out of this as well. So if anyone has free time, PLEASE make a video on it.
Shaiya Private Server Video Tutorial 09/14/2012 - Shaiya PServer Development - 87 Replies Hi all i'm new here and not the kind of guy who talks in forums... Anyway i see alot of post asking about the server not working or why i have red cross etc. So i make this Video tutorial to help all ppl here and make life easy for everyone.
First here u will see step by step how to Install and configure SQL and SSMSEE
YouTube - Howto: Setup MSSQL Express for Personal Use
Theres a better tutorial here...