this is happening and i don't know why!
this is happening and i don't know why!
db missing or deleted
chacina are you sure its db missing or deleted?..
coz i had that problem before then i went to restore the database again a few hours later suspect again -.-
suspect = maybe corrupted, most of the times it gets repair by it self but if it doesn't search in microsoft. i once did it on 2005 but i don't remember.
if the db is clean, just drop it and create a new one.
Turn Of your db, in mssql data folder rename Event.mdf to Event_Data.mdf (the files u copyed)
Originally Posted by xz3r0x
yes this is correct this is what i did.. and the suspect is gone
Its because mssql server stores database in *_Data.mdf file and db log in _Log.ldf, in fullServer there are Event_Log.ldf and just Evend.mdf, so server finds event database logs, and doesn't find actual data (infact it uses empty event database, wich u created) so imagine that server sees insert into character table in the log file, but doesn't see a character table in main database file, so its says it is suspected (corrupted) ;)
Its just a little explanation why it is happening
sir i still have a lot of errors in logs when i execute in in putty, sir can i ask you a favor? can you share your DB to us so that we can have a working DB now..
im using Mssql 2000, heres my config and logs
http://www.mediafire.com/?tnzyn112hgu
kindly check it sir where did i go wrong?
Well in your logs, i see main problem is that your server cant connect, with your database make sure u modified /etc/odbc.ini to your windows machine ips, and make sure u created a linked server GAMESERVER if not do EXACTLY like in video by MAHI, because i saw many ho says tu put PWD and UID blank in connection string int not right, and only MAHI assigns a default database to ACCOUNT when he is creating a database user, it is very important, so follow the VIDEO GUIDE by MAHI and, it should be everything alright. I dont see why u need, my db, because i use the same files as all of u ;) cheers.
And please dont call me sir :) i am just 21 years old, (young in heart :D )
i think mu ODBC.ini is correct i put the windows ip in my odbc.
and for the db, i just said that because some said that it is a db problem, and i think using db that is already tested is the way to solve my problem
well then i will upload it, but don't see the reason :) just wait few minutes
thanks, i used MAHI's video guide, this is my 4th time repeating the process, and again i still use Mahi's guide, but i cant get it right.. i making this server for more than a week,
In my db files u wont find right user configuration for server and linked gameserver, do u want my to write a short guide on these issues? and few questions:
1. What MSSQL version u use 2005/2000
2. Is your windows firewall on?
p.s. 6 more minutes left
i used all data in Mahis guide, before i used darkxl guides i have also all data that he is using but i cant follow his chinese video..
i used mssql 2000, and all firewalls are off linux and windows
yes i appreciate it very much can make a guide for me, i think im sick of video now, i think i need a new guide hope with pics>>>..:-)
EDIT:\
these are the clients that i used
chinese
brazilian
GP
TFN-deleted
Ocean cabal --1,24 Gig -->>downloading
and they say korean client are more stable
which is which?
here is my database working. http://www.mediafire.com/?mmyfjdxmlns just stop yours overwrite everything and start your db.
WARNING. make a copy of your original db files, just to be safe.
the guide about user and linked server creation with img will be in about 1-2h (i need to work in my work :) not just sit all day in forums :) )
thanks, you know what , i leave all my work for 3 days just to make this server, thats why im not stopping now.. hehe, im over 3 days always online in the forum just to find answers to my question.. btw, thank you, i will wait for your guide/... see yah
Assuming you have a fresh database installed, you copied all files from server file /date dir to your db data folder, renamed event.mdf to event_data.mdf, restored databases ACCOUNT, GAMEDB, cabal_cash.
Now u need to delete old cabal user from databases ACCOUNT, cabal_cash and GAMEDB (if there is one)
Open database ACCOUNT select users, click right mouse button on cabal user and select delete, press yes
Do the same in cabal_cash and GAMEDB. (if there is users cabal)
then collapse the databases folder and expand security folder right click on "Logins" and choose new login
for name enter: cabal
select option: "sql server authentication"
for password: cabal
IMPORTANT choose DATABASE ACCOUNT !!
select next tab "server roles"
and check the "system administrators"
select next tab "Database access"
check all cabal server databases (account, cabal_cash, cabal_stat, event, gamedb) AND ON GAMEDB check db_owner
click ok, retype the password: cabal click ok.
Right click on "linked servers" and select "new linked server"
check "other datasources"
from list select "Microsoft OLE Provider for ODBC drivers"
for linked server type: GAMESERVER
for Product name type: gameserver
for connection string type:
DRIVER={SQL Server};SERVER=localhost;UID=cabal;PWD=cabal;
select next tab "security"
select "Be made using the login's current security context"
select next tab "server options"
check all "birds" :)
click ok, and thats all, to test if u succeeded just select your newly created gameserver chose tables and u should see something like this with auth tables and so on:
Hope helps this :) cheers, tested and works on my server :)
P.S all credits goes to mahi, he/she first mentioned about default database in user creation ! respect
thanks for the guide, i will try it now, this is look like in the video, but unlike in video i can work faster because i dont have to wait... thanks, maybe i miss something in viewing the video, this time i will do it correctly, thanks again
No problem man, here to help, if u have a question u can private message me if u want.
thank you very much... ok i will PM you if i will encounter problem regarding this... kkkk time start again....
EDIT:
My DB still mess UP
http://i247.photobucket.com/albums/g...DBAgent_24.jpg
i send you a private message...
Huh!!! i follow all your guides but still DB cant connect.. alot of errors
Last edited by ramispo; 17-07-08 at 03:28 PM.
Hey, I'm having the same problem ramispo is having. Instead of it being name Event_DATA.mdf it was Event.mdf I renamed it and drag it over to the data folder. It wouldn't create any tables underneath the database. I tried restoring the database but an error popped up and said it could not be restored because there was an error (I'm grounded from the computer right now so i can't give you the exact error code i get when i try to restore the database). I decided to delete the Event database and then recreate it, but when ever i try to recreate it i get an error message that it already exists even though it is gone. So can you help me with these two problems?
W00T I got it never mind. I don't know what i did wrong the first time. I turned of the service manager then i dragged the files over (and renamed Event.MDF) the first time i did that it didn't work and just poped up with a bunch of errors.
Reply With Quote
