[TUT] SQL Server 2008 Installation & Setup for Dekaron Servers

freeskier4lif3 · 04/02/2012, 01:38

1. Installing SQL Server 2008

Spoiler

2. Setup Dekaron Databases

Spoiler

3. Run the "SN" query

Spoiler

Copy this code.

Code:

Use master;
Go
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

Use master;
Go
exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

Select "New Query" in the tool bar

Paste the code into the opened query field.
Select "Execute"

4. Setup new login (optional, but best for security)

Spoiler

5. Configure ODBC

Spoiler

And that's it for now on setting up SQL Server 2008 for Dekaron. Your database is now ready to be used by the game's server files.

BioNicX · 04/02/2012, 04:00

Is this the 2012 version of how to do it?

freeskier4lif3 · 04/02/2012, 05:34

I haven't tried 2012 yet, this is for 2008. I gotta dl 2012 sometime and check it out though.

BioNicX · 04/02/2012, 06:05

Nvm haha xD...

BlackLixt · 04/02/2012, 13:07

nice work and a big thx

[DEV]Harmony · 04/02/2012, 15:53

Awesome tut Jb!

ronaldfa · 04/02/2012, 19:18

WoW nice !

kakkeks · 04/03/2012, 00:45

I cant put the key in its unvabial what i can do now got (win7 enterprise 32 bit )

freeskier4lif3 · 04/03/2012, 00:52

What version of sql did you download? Also could you post up a screenshot of the problem?

kakkeks · 04/03/2012, 01:45

I have done all thinks like u and sry for dumb post by me but what i need to do after i did this.
I looked around but cant find a tut thats help me maybe can some1 send me a link pls? TY

gondudy · 04/04/2012, 06:07

should be stickied anyone else agree?

shockingcel1234 · 04/08/2012, 02:15

should include download links if you want this to be actually a really good tut , otherwise well done

*JayKay* · 04/08/2012, 04:02

Quote:
Originally Posted by freeskier4lif3
1. Installing SQL Server 2008

Spoiler

Select "New SQL Server stand-alone installation or add features to an existing installation"

Select Ok

Selection Install

Wait for Setup Support files to install...

Select Next

Select Next

Select which edition you have a serial number for and enter your serial number. Use SQL Standard or higher.

Check the box to accept the Microsoft Software License Terms and Select Next

Choose which features to install. (I have checked all that you need to run Dekaron in this image)
Then Select Next

Select "Default Instance" and leave the Instance ID as "MSSQLSERVER"
Then Select Next

Select Next if you have enough disk space to install SQL Server

Select "NT AUTHORITY\SYSTEM" in the Account Name column for both the SQL Server Agent and SQL Server Database Agent.
Then Select Next

Select "Mixed Mode"
Enter a password. (REMEMBER THIS!)
Click "Add Current User"
Then Select Next

Select Next

Select Next

Select Install

...and wait...

Select Next

Installation Complete!

2. Setup Dekaron Databases

Spoiler

Open SQL Server Management Studio

Select server "(local)" and Windows Authentication
Select Connect

Right Click on the "Databases" folder and Select "Restore Database..."

Enter the name of the database you will restore "account"
Select the box "From Device"
Click the box highlighted in Red

Select Add

Locate and select the .bak file for the database your are restoring. (this time "account.bak")
Select Ok

Select Ok

Check the box for the database backup to restore. (If there are more than one, each are just a different backup date/time. Pick one from a time that you would like)

Select Ok and wait a couple seconds

Restore Complete!

Repeat this process for "cash", "character".

For "billing" there is one more step:
After finding the .bak and selecting the database, click "options" on the left.
Change the "billing.mdf" in the 2nd and 3rd row in the middle box to "billing1.mdf" and "billing2.mdf"

Then Select OK.

You're Done restoring the Databases!

3. Run the "SN" query
Spoiler
Copy this code.
Code:
Use master;
Go
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

Use master;
Go
exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'
Select "New Query" in the tool bar

Paste the code into the opened query field.
Select "Execute"
4. Setup new login (optional, but best for security)

Spoiler

First Disable the "sa" login:

Open SQL Server Management Studio.
Click the + next to "Security" and then "Logins"
Right Click "sa" and select "Properties"

Click the "Status" tab on the left.
Check the radials to "Deny" and "Disabled"
Click OK

Creating the new login:

Right click the "Logins" folder and select "New Login..."

Enter a name and password for the new login.
Uncheck the box "Enforce Password Policy" (this prevents you having to change the password on your first login as well as every 6 months)

Click the "Server Roles" tab
Check the box "sysadmin"

Click the "User Mapping" tab
Check the box for all 4 Dekaron databases and in each check the box dbowner on the bottom.
This must be done for all 4 Dekaron databases. (account, billing, cash, character)

Click OK and you're done!
Remember this username and password as you will be using it on your server files config.ini.
You will also use this login in the next step for ODBC.

5. Configure ODBC

Spoiler

Open Control panel and double click on "Administrative Tools"

Double Click "Data Sources (ODBC)"

Click on the "System DSN" Tab and then "Add"

Click "SQL Server" and then "Finish"

Enter a name and description (doesn't matter)
Select the (local) database
Click Next

Click the radial for SQL Server Authentification
Enter the user name and pass for your SQL login
Click Next

Click Next

Click Finish

Click "Test Data Source" to ensure your set the ODBC up right

If you don't see this message, recheck your username and password

Click OK on all the boxes, you are done!

And that's it for now on setting up SQL Server 2008 for Dekaron. Your database is now ready to be used by the game's server files.

Which version and the sql that was used in the tutorial?

[DEV]Harmony · 04/08/2012, 05:24

Quote:

Originally Posted by shockingcel1234

should include download links if you want this to be actually a really good tut , otherwise well done

posting warez is forbidden, the violation of this rule usually leads to an infracton for the first time and a ban if you continue; requesting warez also is not allowed, if you do so you'll get an infraction.

freeskier4lif3 · 04/08/2012, 07:18

Quote:

Originally Posted by shockingcel1234

should include download links if you want this to be actually a really good tut , otherwise well done

As Harmony stated above, it's against epvp rules to post links to download sql server.

Quote:

Originally Posted by *JayKay*

Which version and the sql that was used in the tutorial?

Microsoft SQL Server 2008 Ultimate