Aremis 0 Report post Posted April 27, 2017 1 minute ago, V3ct0r said: Are you sure that you installed MSSQL Server Instance? Looks like you installed only MSSQL Management Studio ENU\x64\SQLEXPRADV_x64_ENU.exe or ENU\x64\SQLEXPRWT_x64_ENU.exe ? Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted April 27, 2017 @Aremis * = contains the feature SQLEXPR SQLEXPRWT SQLEXPRADV ---------------------------------------------------------------------------- > SQL Server Core * * * > SQL Server Management Studio - * * > Distributed Replay – Admin Tool - * * > LocalDB - * * > SQL Server Data Tools (SSDT) - - * > Full-text and semantic search - - * > Specification of language in query - - * > some of Reporting services features - - * You need SQL Server Core and SQL Server Management Studio 1 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
Aremis 0 Report post Posted April 28, 2017 11 hours ago, V3ct0r said: Are you sure that you installed MSSQL Server Instance? Looks like you installed only MSSQL Management Studio Fixed it! Thanks a lot mate! Quote Share this post Link to post Share on other sites
Aremis 0 Report post Posted April 28, 2017 (edited) 11 hours ago, V3ct0r said: @Aremis * = contains the feature SQLEXPR SQLEXPRWT SQLEXPRADV ---------------------------------------------------------------------------- > SQL Server Core * * * > SQL Server Management Studio - * * > Distributed Replay – Admin Tool - * * > LocalDB - * * > SQL Server Data Tools (SSDT) - - * > Full-text and semantic search - - * > Specification of language in query - - * > some of Reporting services features - - * You need SQL Server Core and SQL Server Management Studio Now what the hell this is Edited April 28, 2017 by Aremis Quote Share this post Link to post Share on other sites
Kovu 10 Report post Posted May 18, 2017 (edited) hii all i have problem with permission users on database can some explain it pliis and i cant change connection on gameserver cause always use GAMEDB i want use other Edited May 18, 2017 by nectrouler Quote FORO EN ESPAÑOL :) ---------------------------------------------------------------------------- Share this post Link to post Share on other sites
Awatawa 3 Report post Posted October 18, 2017 "Can't find Registry key : SOFTWARE\Microsoft\MSDTC" It appears when the sql server 2014 was installed. Quote Share this post Link to post Share on other sites
seemsq8 3 Report post Posted October 26, 2017 (edited) Hey, thanks for the guide! I am facing some issues attaching the Accountserver, gamedb files to SQL. any idea how to solve this? log: Spoiler TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'ALHATEM-PC'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2569.0+((SQL14_RTM_QFE-CU).160527-1418)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Database 'GameDB' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database. Could not open new database 'GameDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft SQL Server&EvtSrc=MSSQLServer&EvtID=950&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Edited October 26, 2017 by seemsq8 Quote Share this post Link to post Share on other sites
Dan 184 Report post Posted October 26, 2017 @seemsq8 2 Quote Share this post Link to post Share on other sites
itsmfx 0 Report post Posted November 3, 2017 (edited) I have a question , i do all , my server connect without any error but when i try to enter in game , to create a character , say "This server is busy" how can fix that ? I use SQL 2014 , please any ideea how to fix it ? Thx Edited November 3, 2017 by itsmfx Working now Quote Share this post Link to post Share on other sites
Airborne 0 Report post Posted February 14, 2018 Hello Everyone! I am having trouble when I launch GameServer through the Server Launcher interface. I get the following error which can be seen in the picture. Has anyone encountered this problem or know of a solution? Thanks! Quote Share this post Link to post Share on other sites
tahi 0 Report post Posted April 15, 2018 itemattr got problem. not enough access. and anyone got iteminfo list? Quote Share this post Link to post Share on other sites
daim2604 0 Report post Posted August 15, 2018 Hello sir, thanks alot for this guide. I'm getting error, connection to database failed, the process terminated. This is my first time setting up a private server. I've googled to no avail. I've checked/given user permission still the same. I'm using sql server 2014 instance. Thanks in advance. Quote Share this post Link to post Share on other sites
BlackBarba 22 Report post Posted August 24, 2018 (edited) can i use 2017 version? Images are Broken =\ Edited August 24, 2018 by BlackBarba Quote Share this post Link to post Share on other sites
gatero 24 Report post Posted August 24, 2018 9 hours ago, BlackBarba said: can i use 2017 version? Images are Broken =\ Yea See my posts 1 Quote Share this post Link to post Share on other sites
asking12 0 Report post Posted April 21, 2019 (edited) On 8/12/2016 at 4:05 PM, Snre3n said: GUIDE UNDER CONSTRUCTION - NO SUPPORT IS GIVEN FOR THINGS IN DEVELOPMENT This guide is intended to help you setup a server, and a client in the easiest possible way, therefore this guide is in first hand focused on setting up a server & client that work on your PC, and only your PC.If you intend to host a public server, see Change IP - Client & Server, and Opening Ports. SQL Server 2014 Setup: Hide contents 1. Acquire SQL Server 2014 Setup executable. First you'll need SQL Server 2014, it can be obtained here: https://www.microsoft.com/en-US/download/details.aspx?id=42299 If you have a 32bit Operating System: ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe If you have a 64bit Operating System: ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe 2. SQL Server 2014 Setup Reveal hidden contents DISCLAIMER: Server name does not have to be the same as mine, Im using the default option given, this can be/is different for you! Run the executable you downloaded and let it extract. Once extraction is done, run "SETUP" in the newly extracted folder. * Microsoft Update - It's up to whether you check it or not. -> Next. * Installation Type - Perform a new installation of SQL Server 2014. -> Next. * License Terms - Check "I accept the license terms." -> Next. * Feature Selection - -> Next. * Instance Configuration - Default Instance. -> Next. * Server Configuration - Next. * Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth) Password: Y87dc#$98 Also "Add Current User" if prompt pops up. -> Next. * Installation Progress should now begin, Click "Close" after completion and your done! 3. Attaching Database to SQL. Reveal hidden contents * Run SQL Server 2014 Management Studio * Databases -> Right Click -> Attach * Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF. * Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio. 4. Enable TCP/IP . ( Fix for AccountServer Hang ) Hide contents Open: SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click TCP/IP -> Enable. Restart SQL Server (MSSQLSERVER) PKO II Server Setup: In development Hide contents 1. Download Database. ( See Resources ) Download PKOII - Server Files. ( See Resources ) 2. Extract PKOII - Server Files,then extract Database in you server file folder. eg: C:/PKOII - Server Files C:/PKOII - Server Files/DB Start Server: Reveal hidden contents Use Server Launcher.exe to start the server, you will need to launch: - AccountServer - GroupServer - GateServer - GameServer PKO II Client Setup: In development Hide contents Download PKO II - Client: See "Resources" To run the game, use Start Game.bat. Change IP - Client & Server: In development Hide contents The default IP is set to 127.0.0.1 in the server files and client files provided in this guide, to connect, your server has to be hosted on the same PC as you run your client. If you intend to let other players connect to your server, you will have to make a few changes to your server files, and to the client. Client: Hide contents ServerSet.txt - can be found in your client folder, PKOII/scripts/table. //ID Name Region IP #1 IP #2 IP #3 IP #4 IP #5 Description ? 1 ServerName RegionName 127.0.0.1 0 0 0 0 - Replace 127.0.0.1 with the IP address shown at https://www.whatismyip.com/ - Run Bin Compiler.bat located in client folder to compile ServerSet.txt to ServerSet.bin. Server: Hide contents Open your command prompt, type ipconfig, then hit enter. Look for your IPv4 Address, IPv4 Address. . . . . . . . . . . : 192.168.1.X You will use this IP address to replace 127.0.0.1 in AccountServer.cfg, GameServer.cfg, GateServer.cfg, GroupServer.cfg. Protip: Hide contents If you are using notepad++, you can open up your configuration files, CTRL + H, Replace All in All Opened Documents. Opening Ports: In development Hide contents Resources: Hide contents MEGA library: https://mega.nz/#F!xw4SFLoS!RmzYX7PdcbcNG2PplfK9jA hmm... how about on create an account to run in the client (this is my major concern) and how to make my id or alts be GM?? After the server run correctly, the client will connect to the server automatically??? The open port must be done to run the client??? what if I just wanna to play by myself??? Please do reply me :D Edited April 21, 2019 by asking12 Quote Share this post Link to post Share on other sites
V3ct0r 2,117 Report post Posted April 21, 2019 @asking12 Quote Some useful links / Полезные ссылки Tips for making a topic in 'Questions & Help' / Рекомендации по созданию тем в разделе "Помощь" Server Advertising Section Rules / Правила раздела "Реклама серверов" Available e-mail domains for registration / Допустимые e-mail домены для регистрации User groups / Группы пользователей User ranks / Звания пользователей "Broken" pictures on the forum / "Битые" изображения на форуме Beware of scammers! / Осторожно, мошенники! My developments / Мои разработки Mods for client and server / Моды для клиента и сервера PKOdev.NET website for Tales of Pirates Server / PKOdev.NET веб-обвязка для сервера Пиратии I do not provide any help in private messages and outside the forum. Use 'Questions & Help' section please. Thank you for understanding! Я не оказываю какую-либо помощь в личных сообщениях и вне форума. Пожалуйста, используйте раздел "Пиратия: Помощь". Благодарю за понимание! Share this post Link to post Share on other sites
asking12 0 Report post Posted April 22, 2019 22 hours ago, V3ct0r said: @asking12 thx ya. May I know is it possible to run the client without opening the port? I dont wanna to have such complicated thing... I am not good in computer... I just wanna to play TOP alone safely (I mean without the risk of getting virus or hacked) Quote Share this post Link to post Share on other sites
Unknown 17 Report post Posted April 22, 2019 2 hours ago, asking12 said: thx ya. May I know is it possible to run the client without opening the port? I dont wanna to have such complicated thing... I am not good in computer... I just wanna to play TOP alone safely (I mean without the risk of getting virus or hacked) Run it on localhost or 127.0.0.1. Not sure Quote Share this post Link to post Share on other sites
asking12 0 Report post Posted April 23, 2019 19 hours ago, Unknown said: Run it on localhost or 127.0.0.1. Not sure I tried but when i run for client it says cannot connect or connection fail..... Do you have the full guide with picture that can show me on how to create it properly without opening the port :D May I know anybody had create the server that he play alone without open the port XD thank you Quote Share this post Link to post Share on other sites
Unknown 17 Report post Posted April 23, 2019 3 hours ago, asking12 said: I tried but when i run for client it says cannot connect or connection fail..... Do you have the full guide with picture that can show me on how to create it properly without opening the port :D May I know anybody had create the server that he play alone without open the port XD thank you Try using hamachi Quote Share this post Link to post Share on other sites
asking12 0 Report post Posted April 24, 2019 (edited) 20 hours ago, Unknown said: Try using hamachi what is hamachi? I think it will also put me at risk :( Any other method?? I wanna it can be play without internet connection XD I wanna to be the GM and control what I want XD Edited April 24, 2019 by asking12 Quote Share this post Link to post Share on other sites
Dan 184 Report post Posted April 24, 2019 (edited) This setup guide should already be working for hosting a server on your PC while still being able to access without internet no? If you want others to access you would have to open a certain port to let others connect if I remember correctly. Another way you can go about this is if you open a port, they can’t play unless they have an account registered and access to your local host I.P. Edited April 24, 2019 by GOAT Quote Share this post Link to post Share on other sites
Shiryu 2 Report post Posted May 23, 2019 the images on the guide has expired... please re upload ni images in the guide. Quote Share this post Link to post Share on other sites
Dragon3rdPrince 0 Report post Posted June 18, 2019 On 8/12/2016 at 9:09 PM, Red said: Much appreciated sir @Snre3n im used to SQL 2000 ( thats how long its been since i worked on servers ) and i wanted to set this up. Thank you again. Please let me know if i can help you with anything. Scripts or code etc ^^ On 8/12/2016 at 4:05 PM, Snre3n said: EDIT: This guide didn't develop into what I intially had in mind, and is now being deprecated. My suggestion is use to this guide: GUIDE UNDER CONSTRUCTION - NO SUPPORT IS GIVEN FOR THINGS IN DEVELOPMENT This guide is intended to help you setup a server, and a client in the easiest possible way, therefore this guide is in first hand focused on setting up a server & client that work on your PC, and only your PC.If you intend to host a public server, see Change IP - Client & Server, and Opening Ports. SQL Server 2014 Setup: Hide contents 1. Acquire SQL Server 2014 Setup executable. First you'll need SQL Server 2014, it can be obtained here: https://www.microsoft.com/en-US/download/details.aspx?id=42299 If you have a 32bit Operating System: ExpressAndTools 32BIT\SQLEXPRWT_x86_ENU.exe If you have a 64bit Operating System: ExpressAndTools 64BIT\SQLEXPRWT_x64_ENU.exe 2. SQL Server 2014 Setup Reveal hidden contents DISCLAIMER: Server name does not have to be the same as mine, Im using the default option given, this can be/is different for you! Run the executable you downloaded and let it extract. Once extraction is done, run "SETUP" in the newly extracted folder. * Microsoft Update - It's up to whether you check it or not. -> Next. * Installation Type - Perform a new installation of SQL Server 2014. -> Next. * License Terms - Check "I accept the license terms." -> Next. * Feature Selection - -> Next. * Instance Configuration - Default Instance. -> Next. * Server Configuration - Next. * Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth) Password: Y87dc#$98 Also "Add Current User" if prompt pops up. -> Next. * Installation Progress should now begin, Click "Close" after completion and your done! 3. Attaching Database to SQL. Reveal hidden contents * Run SQL Server 2014 Management Studio * Databases -> Right Click -> Attach * Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF. * Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio. 4. Enable TCP/IP . ( Fix for AccountServer Hang ) Reveal hidden contents Open: SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> Right click TCP/IP -> Enable. Restart SQL Server (MSSQLSERVER) PKO II Server Setup: In development Reveal hidden contents 1. Download Database. ( See Resources ) Download PKOII - Server Files. ( See Resources ) 2. Extract PKOII - Server Files,then extract Database in you server file folder. eg: C:/PKOII - Server Files C:/PKOII - Server Files/DB Start Server: Reveal hidden contents Use Server Launcher.exe to start the server, you will need to launch: - AccountServer - GroupServer - GateServer - GameServer PKO II Client Setup: In development Reveal hidden contents Download PKO II - Client: See "Resources" To run the game, use Start Game.bat. Change IP - Client & Server: In development Reveal hidden contents The default IP is set to 127.0.0.1 in the server files and client files provided in this guide, to connect, your server has to be hosted on the same PC as you run your client. If you intend to let other players connect to your server, you will have to make a few changes to your server files, and to the client. Client: Reveal hidden contents ServerSet.txt - can be found in your client folder, PKOII/scripts/table. //ID Name Region IP #1 IP #2 IP #3 IP #4 IP #5 Description ? 1 ServerName RegionName 127.0.0.1 0 0 0 0 - Replace 127.0.0.1 with the IP address shown at https://www.whatismyip.com/ - Run Bin Compiler.bat located in client folder to compile ServerSet.txt to ServerSet.bin. Server: Reveal hidden contents Open your command prompt, type ipconfig, then hit enter. Look for your IPv4 Address, IPv4 Address. . . . . . . . . . . : 192.168.1.X You will use this IP address to replace 127.0.0.1 in AccountServer.cfg, GameServer.cfg, GateServer.cfg, GroupServer.cfg. Protip: Reveal hidden contents If you are using notepad++, you can open up your configuration files, CTRL + H, Replace All in All Opened Documents. Opening Ports: In development Reveal hidden contents Resources: Reveal hidden contents MEGA library: https://mega.nz/#F!xw4SFLoS!RmzYX7PdcbcNG2PplfK9jA Hello, i cant find the Accountserver.mdf & the gameserver.mdf when i need to attach it into my SQL server 2014, could someone help? Quote Share this post Link to post Share on other sites
jdams1 0 Report post Posted July 22, 2019 On 11/1/2016 at 7:43 PM, ChinO said: Im having same error, how i can fix them? Quote Share this post Link to post Share on other sites