mssql 2005 restoring problems

[Zen]

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

 

[ronjambo]

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

 

[Spirit]

never needed to move that file be4 ... only with 2000

2005 is pretty cool /// u can go by the new guide in Guide Section

 

[Zen]

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!

 

[Jordan]

have you tryed to install obdc v5 ? i get problems with mssql 05 aswell have you tried the 08 beta version or 05 express?

 

[Zen]

im using 05 extended, and il google obdc v5, i cant install sql 2000 tho cause it tells me i need to reboot (and i hae many times)

 

[Zen]

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

 

[Zen]

im not logged in, i use microsoft authentication...

well i might try reinstalling mssql 05 and reinstalling using an id+pw, might solve the prob

 

[ronjambo]

dont uninstall to reinstall just install again = install a second instance


.

 

[Zen]

how do i do that?

 

[ronjambo]

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

 

[Zen]

oO tyvm ron

 

[ronjambo]

no problem man, happy to help

 

[Zen]

alright its working fine now, thanks a million ron =D