Jump to content
Snre3n

SQL 2014 Express setup

Recommended Posts

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

Share this post


Link to post
Share on other sites

@Snre3n Comprehensive guide.

  • Like 1

logo-big.png   logo.png

                                   Sunny Go! Online                                                                    pko.host                                                 

Share this post


Link to post
Share on other sites
On 10/30/2016 at 8:58 AM, Snre3n said:

Have you checked what the log file says? ( The one mentioned at the end of your error. )

i already installed it correctly.. im having trouble in attach DB what DB is compatible with this SQL?

Edited by ChinO

Share this post


Link to post
Share on other sites
On 2016-10-31 at 3:54 AM, ChinO said:

i already installed it correctly.. im having trouble in attach DB what DB is compatible with this SQL?

Try the DB's from these server files, said to be working fine with SQL2014.

On 2016-07-19 at 2:26 PM, V3ct0r said:

@GummyBear check if table 'account' in GameDB is empty. It should have at least one record.

 

DBs from these files are working fine with MSSQL 2014

 

  • Like 1

Share this post


Link to post
Share on other sites

@ChinO

Try attach databases under administrator mode


Share this post


Link to post
Share on other sites
2 часа назад, ChinO сказал:

how? can u show me?

Right click on .exe or label -> Context menu -> Run as administrator


Share this post


Link to post
Share on other sites
On 11/2/2016 at 10:10 PM, V3ct0r said:

Right click on .exe or label -> Context menu -> Run as administrator

did u mean i should run as administrator the sql management studio?

Share this post


Link to post
Share on other sites
1 час назад, ChinO сказал:

did u mean i should run as administrator the sql management studio?

Yes, I mean MSSQL Management Studio


Share this post


Link to post
Share on other sites

@theone @ChinO I think this error can happen if the database files is "read only".
For those who don't know how to do this: Right click folder containing database  -> Properties -> Remove check on "Read Only" -> "Apply".

Tell me if it helped.

Edited by Snre3n
  • Like 2

Share this post


Link to post
Share on other sites

bump! xD

Edit: i have fixed database ataching issues by going to services.msc  dobble click on sql server->log on->and used Local System Account! thnaks everyone for replying!!

 

Edited by theone
  • Like 2

Share this post


Link to post
Share on other sites

Updated the guide with following:

* Included Server files ( DB's excluded )

* Included Database ( The old one was missing act_album table )

* Included fix for AccountServer Hang, it has been confirmed to work by @snowolf

 

@mkhzalehplease check 5. Enable TCP/IP . ( Fix for AccountServer Hang )

Edited by Snre3n
  • Like 1

Share this post


Link to post
Share on other sites
59 minutes ago, Snre3n said:

Updated the guide with following:

* Included Server files ( DB's excluded )

* Included Database ( The old one was missing act_album table )

* Included fix for AccountServer Hang, it has been confirmed to work by @snowolf

 

@mkhzalehplease check 5. Enable TCP/IP . ( Fix for AccountServer Hang )

thx i will try it hope it's work
if i'm going use my ip should i change the port in accc.cfg too?

Share this post


Link to post
Share on other sites
On 12.08.2016 at 11:05 AM, Snre3n said:

GUIDE UNDER CONSTRUCTION

PKO II Server Setup: In development

  Reveal hidden contents

 

PKO II Client Setup: In development

  Reveal hidden contents

 

SQL Server 2014 Setup:

  Reveal hidden 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

 

 

5. 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

 

 


Resources used in guide:

  Reveal hidden contents

 

Can u upload databases to another site?

Share this post


Link to post
Share on other sites
On 8/12/2016 at 0:05 PM, Snre3n said:

GUIDE UNDER CONSTRUCTION

PKO II Server Setup: In development

  Hide contents

 

PKO II Client Setup: In development

  Hide contents

 

SQL Server 2014 Setup:

  Reveal hidden 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

 

 

5. 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

 

 


Resources used in guide:

  Hide contents

 

 

does anyone have the RESOURCES USED GUIDE files? kindly reupload them pls?!....

 

thanks!!!!

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