These server files are 1507. (ebenezer and client is set to 1508)
Download sql server evaluation 2000.
Download 1508 database
Download 1508 server files without maps
Download 1508 client + data
NOTICE: USE YOUR OWN UIS.TBL OR MAKE SURE YOU USE 1098 UI_EN directory.
Download 1505-1508 ip editor
NOTICE: Password is in SNOXDKO Readme.
Credits: Stork, FG and I
Restoring Database
1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server ->
Enterprise Manager)
2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
3. Right click (local) (windows) -> Edit SQL server Registration properties
4. Click dot in Use SQL Server authentication -> Login name (that u gave at the install) -> leave pass empty -> click dot in Always prompt for login name and password *then add the login and pass that u gave at the install and go to Databases.
5. Create a new database, name it KN_online
6. After that, right click on KN_online database then click all tasks and
then "Restore Database".
7. Click on "From Device" and then click on "Select Devices".
8. Click Add and then choose the destination of the backups to Restore into
KN_online (this destination needs to lead to your "KN_online" database folder )
9. Press OK 2 times to continue, and then press the Options tab.
10. Click dot in "Force restore over existing database",
11. Make sure the path of the MDF and LDF files is the same of your server files
(KNonline_data and KN_online_log) (make sure they will be in your server folder)
12. Press OK to import the database.
13. Console Root -> Microsoft SQL Servers -> SQL server Group -> [local]
14. Go to Security -> Login -> Right click -> New Login
15. Put name knight -> Click dot in sql server authentication
16. Use knight as password -> Choose KN_online as database
17. Go to tab Database access -> click on database KN_online
18. In permit in database role click on db_owner -> ok
*if u get an error "user knight already existed" then go to KN_online -> users and delete the user "knight" that should be there. And then do 14-18 again
19. IMPORTANT.. Go to databases KN_online -> Right Click -> Properties -> Permission Click all of them on user knight (or it wont save items etc)
20. Disconnect from sql server and relog using the user knight in enterprise manager.
Credits 987655 (if you need a guide go to 987655's Combined Guide)
FROM:http://forum.ragezone.com/f107/everything-you-need-1508-server-272769/ |