After that, check "Change the default database to" and change it to the Tales Runner database.
Put in the login ID as "sa" and the password as whatever password you used when you installed the server. Put any name, description is optional, for most cases ODBC won't detect your server name so just go into SQL Server Management Studio and copy it into Server Name.Īfter that, it'll ask you about log in info select (dunno about the other) and for anyone using another language, it's the second option.
When you're done, there should be no errors.Ĭontinuing, search "Set up ODBC data sources" in Windows and add select SQL Server. Raiserror('cannot find proper server', 16, 1) ĭbtime = getdate() Change the word "database" to the name of your database. Select ROOmservernum = fdNum, farmCacheMax = fdFarmCacheMax, limitroomCount = fdLimitRoomCountįdServerPort = tblUserFarmList set fdRoomServerNum = 0, fdRoomHandle = 0, fdCacheRoomServerNum = 0 In dbo.tblServerListAgentSvr do not, I repeat, do not change the fdBillingServerIPs unless you know what are you doing. Take note there's a sneaky one that's 9153 In dbo.tblServerListRoomSvr the ports all must be 9152. Put your Hamachi IP address on all the tables that originally had IP addresses in them but
The tables to change are (adding dbo if you find that I don't make sense) And if you don't know how to change the tables, right click the table and click "Edit top 200 rows". It's quite easy to find because it's listed in alphabetical form. There will be a lot of tables showing up but don't fret. In the SQL Server Management Studio program, open up the "Databases" tab, open up the database you included, and then open up "Tables". If it didn't then you probably did the installation/db creation wrongĪfter that, you will now have to edit some tables. When it's done it should have a small window saying "Package executed successfully" or something close to that(I think it auto closes.
Follow the guide again and it will install the database for you. Execute it and it will open up the program. Somewhere in the server files there will be a file named db_install_korea_2012_02_02.exe. (In the 02 install db folder) Halfway during the mini guide, you'll notice another program is executed. Right click databases and click new database and follow the mini guide I gave you earlier. You can use Windows Authentication or SQL Server Authentication both is fine.Īfter connecting, it should show something like this in the left tab
And then continue to the next stepĬontinuing, after the installation, run SQL Server Management Studio and connect to it. It's just the management studio so you don't have to do any configurations. Now install SQLManagementStudio_x86_ENU.exe. Okay now just finish up the installation and you're done with the SQL Server. (Windows authentication is quite nice to use because you don't have to connect to your db while entering a password :'D
In the next page, check mixed mode and enter a passwordĪnd if you want to be sure, you can click "Add current user" too. Under "Customize" it should look like this.
Set the named instance to anything memorizable and click next.Īfter that, click on Collation and make the Database Engine say In the installation, you should see a page like this SQLEXPR_x86_ENU.exe and SQLManagementStudio_x86_ENU.exe. I want better questions to roam around, so I'm going to just put down HOW TO INSTALL SQL SERVER Okay there are no other questions other than anything related about installing the database and the programs not showing up. Btw it's in the attachment if you don't know. I've dug out a small part of the installation process.
Hamachi (Or if you've done this kind of thing before, you can use anything you like) Microsoft SQL Server 2008 R2 Express Edition with Management Studio