Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

mssql 2005 restoring problems

Zen

Custom Title Activated
Loyal Member
Joined
Dec 2, 2006
Messages
1,619
Reaction score
152
hi, i took sql 2000 off and put sql 2005 on (for security reasons mainly) and i cant restore dbs =O

when i go to restore the db, it gives me

"RESTORE FAILED FOR ZENZ0RZ"

i am not sure what to change

c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\kal_auth.MDF

to... and what to change the log file to aswell

to C:\KalServer\DataBases\kal_auth ?

if so what about the log file




thanks in advance
 
the Insane
Joined
Aug 23, 2007
Messages
229
Reaction score
13
hit rename on the kal_auth and kal_db files
and rename them to
kal_auth.bak and
kal_db.bak
then it will work
 
Upvote 0
Junior Spellweaver
Joined
Oct 19, 2007
Messages
198
Reaction score
2
never needed to move that file be4 ... only with 2000 :(

2005 is pretty cool /// u can go by the new guide :p in Guide Section
 
Upvote 0

Zen

Custom Title Activated
Loyal Member
Joined
Dec 2, 2006
Messages
1,619
Reaction score
152
i renamed them to .bak, they restored ect... but now obdc problem =P nothing seems to be working for me

i tried just running the loginserver, dbserver, mainserver anyway, but i get the supid id and pw boxes every min or so (im pretty sure this means it cannot connect)


Microsoft SQL Server ODBC Driver Version 03.85.1117

Running connectivity tests...

Microsoft SQL Server ODBC Driver Version 03.85.1117

Data Source Name: KAL_DB
Data Source Description:
Server: (local)
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No

Attempting connection
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.

TESTS FAILED!
 
Upvote 0

Zen

Custom Title Activated
Loyal Member
Joined
Dec 2, 2006
Messages
1,619
Reaction score
152
yeah...... its kinda confusing and has bits missing

in my obdc there are 4 accounts

(local)
(local)
ZENZ0RZ-RWWV8LH
ZENZ0RZ-RWWV8LH

also should the default db be master?


Zenz0rZ is my account name, ZENZ0RZ-RWWV8LH is my computer name (im presuming these 2 things are the same)

il try what you said and il post wether it worked or not in a min
 
Upvote 0
the Insane
Joined
Aug 23, 2007
Messages
229
Reaction score
13
dont uninstall to reinstall just install again = install a second instance


.
 
Upvote 0
the Insane
Joined
Aug 23, 2007
Messages
229
Reaction score
13
the sql installer allows you to install more than 1 instance thats how, just run the installer again

not sure if you need to click a different option to install a number 2 im not on my pc (on craptop) and cant remember
 
Upvote 0
Back
Top