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

Page 1 of 5

Last »

04/02/2012 01:38 freeskier4lif3#1

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
[Only registered and activated users can see links. Click Here To Register...]

Paste the code into the opened query field.
Select "Execute"
[Only registered and activated users can see links. Click Here To Register...]

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.

04/02/2012 04:00 BioNicX#2

Is this the 2012 version of how to do it?

04/02/2012 05:34 freeskier4lif3#3

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

04/02/2012 06:05 BioNicX#4

Nvm haha xD...

04/02/2012 13:07 BlackLixt#5

nice work and a big thx

04/02/2012 15:53 [DEV]Harmony#6

Awesome tut Jb!

04/02/2012 19:18 ronaldfa#7

WoW nice ! :D

04/03/2012 00:45 kakkeks#8

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

04/03/2012 00:52 freeskier4lif3#9

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

04/03/2012 01:45 kakkeks#10

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

04/04/2012 06:07 gondudy#11

should be stickied anyone else agree?

04/08/2012 02:15 shockingcel1234#12

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

04/08/2012 04:02 *JayKay*#13

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"
[Only registered and activated users can see links. Click Here To Register...]

Select Ok
[Only registered and activated users can see links. Click Here To Register...]

Selection Install
[Only registered and activated users can see links. Click Here To Register...]

Wait for Setup Support files to install...

Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select which edition you have a serial number for and enter your serial number. Use SQL Standard or higher.
[Only registered and activated users can see links. Click Here To Register...]

Check the box to accept the Microsoft Software License Terms and Select Next
[Only registered and activated users can see links. Click Here To Register...]

Choose which features to install. (I have checked all that you need to run Dekaron in this image)
Then Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select "Default Instance" and leave the Instance ID as "MSSQLSERVER"
Then Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select Next if you have enough disk space to install SQL Server
[Only registered and activated users can see links. Click Here To Register...]

Select "NT AUTHORITY\SYSTEM" in the Account Name column for both the SQL Server Agent and SQL Server Database Agent.
Then Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select "Mixed Mode"
Enter a password. (REMEMBER THIS!)
Click "Add Current User"
Then Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select Next
[Only registered and activated users can see links. Click Here To Register...]

Select Install
[Only registered and activated users can see links. Click Here To Register...]

...and wait...
[Only registered and activated users can see links. Click Here To Register...]

Select Next
[Only registered and activated users can see links. Click Here To Register...]

Installation Complete!
[Only registered and activated users can see links. Click Here To Register...]

2. Setup Dekaron Databases

Spoiler

Open SQL Server Management Studio
[Only registered and activated users can see links. Click Here To Register...]

Select server "(local)" and Windows Authentication
Select Connect
[Only registered and activated users can see links. Click Here To Register...]

Right Click on the "Databases" folder and Select "Restore Database..."
[Only registered and activated users can see links. Click Here To Register...]

Enter the name of the database you will restore "account"
Select the box "From Device"
Click the box highlighted in Red
[Only registered and activated users can see links. Click Here To Register...]

Select Add
[Only registered and activated users can see links. Click Here To Register...]

Locate and select the .bak file for the database your are restoring. (this time "account.bak")
Select Ok
[Only registered and activated users can see links. Click Here To Register...]

Select Ok
[Only registered and activated users can see links. Click Here To Register...]

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)
[Only registered and activated users can see links. Click Here To Register...]

Select Ok and wait a couple seconds
[Only registered and activated users can see links. Click Here To Register...]

Restore Complete!
[Only registered and activated users can see links. Click Here To Register...]

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"
[Only registered and activated users can see links. Click Here To Register...]

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
[Only registered and activated users can see links. Click Here To Register...]

Paste the code into the opened query field.
Select "Execute"
[Only registered and activated users can see links. Click Here To Register...]
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"
[Only registered and activated users can see links. Click Here To Register...]

Click the "Status" tab on the left.
Check the radials to "Deny" and "Disabled"
Click OK
[Only registered and activated users can see links. Click Here To Register...]

Creating the new login:

Right click the "Logins" folder and select "New Login..."
[Only registered and activated users can see links. Click Here To Register...]

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)
[Only registered and activated users can see links. Click Here To Register...]

Click the "Server Roles" tab
Check the box "sysadmin"
[Only registered and activated users can see links. Click Here To Register...]

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)
[Only registered and activated users can see links. Click Here To Register...]

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"
[Only registered and activated users can see links. Click Here To Register...]

Double Click "Data Sources (ODBC)"
[Only registered and activated users can see links. Click Here To Register...]

Click on the "System DSN" Tab and then "Add"
[Only registered and activated users can see links. Click Here To Register...]

Click "SQL Server" and then "Finish"
[Only registered and activated users can see links. Click Here To Register...]

Enter a name and description (doesn't matter)
Select the (local) database
Click Next
[Only registered and activated users can see links. Click Here To Register...]

Click the radial for SQL Server Authentification
Enter the user name and pass for your SQL login
Click Next
[Only registered and activated users can see links. Click Here To Register...]

Click Next
[Only registered and activated users can see links. Click Here To Register...]

Click Finish
[Only registered and activated users can see links. Click Here To Register...]

Click "Test Data Source" to ensure your set the ODBC up right
[Only registered and activated users can see links. Click Here To Register...]

If you don't see this message, recheck your username and password
[Only registered and activated users can see links. Click Here To Register...]

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?

04/08/2012 05:24 [DEV]Harmony#14

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.

04/08/2012 07:18 freeskier4lif3#15

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

Page 1 of 5

Last »