|
You last visited: Today at 16:37
Advertisement
[TUT] SQL Server 2008 Installation & Setup for Dekaron Servers
Discussion on [TUT] SQL Server 2008 Installation & Setup for Dekaron Servers within the Dekaron Private Server forum part of the Dekaron category.
04/02/2012, 01:38
|
#1
|
elite*gold: 0
Join Date: Sep 2008
Posts: 231
Received Thanks: 149
|
[TUT] SQL Server 2008 Installation & Setup for Dekaron Servers
1. Installing SQL Server 2008
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
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
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)
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
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.
|
|
|
04/02/2012, 04:00
|
#2
|
elite*gold: 0
Join Date: Sep 2010
Posts: 981
Received Thanks: 296
|
Is this the 2012 version of how to do it?
|
|
|
04/02/2012, 05:34
|
#3
|
elite*gold: 0
Join Date: Sep 2008
Posts: 231
Received Thanks: 149
|
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
|
#4
|
elite*gold: 0
Join Date: Sep 2010
Posts: 981
Received Thanks: 296
|
Nvm haha xD...
|
|
|
04/02/2012, 13:07
|
#5
|
elite*gold: 0
Join Date: Jan 2011
Posts: 171
Received Thanks: 58
|
nice work and a big thx
|
|
|
04/02/2012, 15:53
|
#6
|
elite*gold: 0
Join Date: Feb 2009
Posts: 815
Received Thanks: 431
|
Awesome tut Jb!
|
|
|
04/02/2012, 19:18
|
#7
|
elite*gold: 0
Join Date: Apr 2011
Posts: 305
Received Thanks: 45
|
WoW nice !
|
|
|
04/03/2012, 00:45
|
#8
|
elite*gold: 0
Join Date: Sep 2008
Posts: 59
Received Thanks: 4
|
I cant put the key in its unvabial what i can do now got (win7 enterprise 32 bit )
|
|
|
04/03/2012, 00:52
|
#9
|
elite*gold: 0
Join Date: Sep 2008
Posts: 231
Received Thanks: 149
|
What version of sql did you download? Also could you post up a screenshot of the problem?
|
|
|
04/03/2012, 01:45
|
#10
|
elite*gold: 0
Join Date: Sep 2008
Posts: 59
Received Thanks: 4
|
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
|
#11
|
elite*gold: 0
Join Date: Jun 2008
Posts: 65
Received Thanks: 12
|
should be stickied anyone else agree?
|
|
|
04/08/2012, 02:15
|
#12
|
elite*gold: 0
Join Date: Jun 2009
Posts: 309
Received Thanks: 6
|
should include download links if you want this to be actually a really good tut , otherwise well done
|
|
|
04/08/2012, 04:02
|
#13
|
elite*gold: 0
Join Date: Jun 2008
Posts: 472
Received Thanks: 275
|
Quote:
Originally Posted by freeskier4lif3
1. Installing SQL Server 2008
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
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
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)
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
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?
|
|
|
04/08/2012, 05:24
|
#14
|
elite*gold: 0
Join Date: Feb 2009
Posts: 815
Received Thanks: 431
|
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
|
#15
|
elite*gold: 0
Join Date: Sep 2008
Posts: 231
Received Thanks: 149
|
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
|
|
|
|
|
Similar Threads
|
[Guide] Setup for SQL Server 2008(32&64bit)
02/16/2018 - Shaiya PServer Guides & Releases - 6 Replies
I decided to make a quick little guide for setting up SQLExpress 2008 following my last guide, seeing as there is no support for this on the forums already. This will cover installation and configuration for MSSQL2008 for 32 and 64bit. Windows 7 64bit Windows XP 32bit were tested for this.
First you will need 2 things:
1) MS Server SQL Server 2008 Express (if you don't already have it installed)
2) MSSQL Server 2008 Management Studio Express
*If you want detailed instructions or visual...
|
i want SQL server 2008 r2 64bit full setup
09/30/2011 - Rappelz Private Server - 4 Replies
hi all
i have SQL server 2008 r2 64 bit
but
it not complite setup half setup
stop install
it's not give me error or anything
just stop install
That's why I want the entire program
i whit ok :mofo:
|
SRO Installation Setup freezes!
09/15/2010 - Silkroad Online - 1 Replies
Hello,
I downloaded the full isro client from joymax.com .. when i start it i neither can click on 'install' nor on 'cancel'.. its freezed. Like its a screenshot lol
Windows XP 32 Bit Version .. DirectX 9 exists.
Thanks for help.. u may also refer to the link of a topic with the same problem that has been discussed already.
|
All times are GMT +1. The time now is 16:37.
|
|