PSERVER - Start to finish! Is this right?

UselessSite · 04/13/2009, 01:07

Man, I am having some big problems. Had it working as a LAN server but remote clients couldn't connect! Silkbotter has helped me a great deal and I hate pestering him/her for help. I am gonna start a WHOLE NEW INSTALLATION/SETUP

Can someone tell me what I am doing wrong, please! I really want this up and running for me and my friends only! Not to make money or compete with other PServers! OK< here it goes...

My first step is gonna be to install

. (The SP4 is located inside, just look. After you extract it, go to C:\SQL2KSP4 and run setup.bat to install the SP4)

OK, now I am done installing and set my "sa" password so I can open SQL Server Service Manager.

Time to open Enterprise Manager. Create 4 databases... account, billing, cash and character.

With the new databases created, we are gonna restore them from the backup files that

supplied us in his most excellent

.

Download

.

Select restore "From Device", click Select Devices..., click Add, now click the button with the 3 dots on it and find the backup file from silkbotter that is the same as the database you are restoring. You will need to restore all 4 databases that you created earlier. After you select the backup click OK 3 times to bring you back to the Restore Database window.

Click the Options Tab at the top and put a check mark in the box for "Force Restore Over Existing Database"

Now change the "Move to physical file name" info to match your desired backup directory. Change ALL the file paths in the list for each database.

Now Open SQL Query Analyzer and make sure your server is populated in the Server field, enter your 'sa' password you created at installation/registration and login. Here we will use the SN.TXT info that

also supplied...

Quote:

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=;'

Paste it in the Query window and press control + F5 to Parse Query then press F5 to Execute Query. After this is done, clear the text in the top frame and paste in the following text from silkbotters SN.TXT...

Quote:

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'

Press Control + F5 to Parse and F5 to Execute. Close Query Analyzer, no need to save.

This part I am not sure about but I think I am doing it right. Nobody has supplied a tut for this but it has been mentioned. Click Start > Control Panel > Administrative Tools > Data Sources (ODBC)

At the top of Data Sources (ODBC), click the System DNS tab, click Add, select SQL Server at the bottom and finish filling in the rest of the info.

Right on! All is up and running. My errors that I was having were a result of my router configuration and not the game server. WOOT!

Now, there is SOOOO much that needs to be fixed. Cash Shop isn't working, etc. Gonna work on that now. ALL YOU NEED TO DO IS

! AND CONFIGURE YOUR ROUTERS, LOL

The only way I was able to figure all this out was because of silkbotter, thank you man, very much!

ADHDKiD · 04/13/2009, 02:07

You stopped, just for food? -1 off finishing product.

~~ex6tenCe~~ · 04/13/2009, 09:02

hmm he need long to eat xD

maybe he is a ruminant, puke it all back on his table and eat again

since 8 hours

LeQuebecoisqc · 04/13/2009, 09:37

Then he will give credit to himself for something that has alerdy been posted in different kind of form (pictures,text and video)and just copyed+pasted lol then call it a tutorial. It doenst take a college diplome to create and backup 4 databases.

LeQuebecoisqc · 04/14/2009, 03:10

Quote:

Originally Posted by UselessSite

I won't do that cause I am not a ******* like you are used to in Quebec. I live in Ontario

What the point?? your living place doenst matter on who you are...That a patetic arguement. I don't care about being an ******* or whatever in your mind it won't change the real fact also telling where do you lived won't make the tutorial better. Im just telling the truth, your tutorial is coming directly from the other one the only difference is that yours is complete at 10% only. Its completly useless since its has been posted alerdy...seriously if I were you I wouldnt give a credit to myself for doing quart of the job.