Jump to content
Snre3n

SQL 2014 Express setup

Recommended Posts

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  ?

Share this post


Link to post
Share on other sites

@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

  • Like 1

Share this post


Link to post
Share on other sites
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!

Share this post


Link to post
Share on other sites
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 xD

gg.png

zz.png

Edited by Aremis

Share this post


Link to post
Share on other sites

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 :S i want use other

Edited by nectrouler

FORO EN ESPAÑOL :)

 

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

M9CMV7K.png

 

 

Share this post


Link to post
Share on other sites

Hey, thanks for the guide! 

 

I am facing some issues attaching the Accountserver, gamedb files to SQL. 

any idea how to solve this?:sad:

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 by seemsq8

Share this post


Link to post
Share on other sites

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 by itsmfx
Working now

Share this post


Link to post
Share on other sites

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! 

GameServer Error.png

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

92fdb5e78a.png

 

f931df06f1.png

 

* 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 -

8bd5feb3fc.png

-> Next.

 

* Instance Configuration - Default Instance. -> Next.

 

3aedcf6a54.png

 

* Server Configuration - Next.

 

* Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth)

 

32247ae14e.png

 

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

 

f6e9a59620.png

 

* Databases -> Right Click -> Attach
 
f78f932e7f.png

 

* Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF.


6408a53179.png

 

* Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio.

34a351a6c2.png

 

 

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.

 

09cd8600eb.png

 

Restart SQL Server (MSSQLSERVER)

 

c2656f5e24.png

 

 

 

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.
4e15599fe5.png

 

 

 

Opening Ports: In development

  Hide contents

 


Resources:

 

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 by asking12

Share this post


Link to post
Share on other sites
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) 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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 by asking12

Share this post


Link to post
Share on other sites

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 by GOAT

Nissan-GT-R.gif

Share this post


Link to post
Share on other sites
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.

92fdb5e78a.png

 

f931df06f1.png

 

* 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 -

8bd5feb3fc.png

-> Next.

 

* Instance Configuration - Default Instance. -> Next.

 

3aedcf6a54.png

 

* Server Configuration - Next.

 

* Database Engine Configuration - Mixed Mode (SQL Server Auth and Win Auth)

 

32247ae14e.png

 

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

 

f6e9a59620.png

 

* Databases -> Right Click -> Attach
 
f78f932e7f.png

 

* Click Add -> Choose accountserver.MDF -> Click OK -> Repeat the same for gamedb.MDF.


6408a53179.png

 

* Edit Owner to "sa" on both databases. -> OK -> Close SQL Management Studio.

34a351a6c2.png

 

 

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.

 

09cd8600eb.png

 

Restart SQL Server (MSSQLSERVER)

 

c2656f5e24.png

 

 

 

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.
4e15599fe5.png

 

 

 

Opening Ports: In development

  Reveal hidden contents

 


Resources:

  Reveal hidden contents

 

Hello, i cant find the Accountserver.mdf & the gameserver.mdf when i need to attach it into my SQL server 2014, could someone help?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...