Question
-
Topic
-
HELP!! Need to Restore SQL 2000 DB in SQL 2005
LockedHello, I need some help ASAP. Our server crashed a week ago and we need to get a database back up. Problem is we ran our old database on SQL 2000 and now our OS is SBS 2003 which they don’t recommend installing SQL 2000 back up so telling us to upgrade to SQL 2005. I get the DB to load through the restore, but I don’t get access from my front-end client due to the whole login error problem. But All answers I’ve seen are when you have a db up to get info from which I don’t have since it totally crashed. All I have is the .bak file. How can I get this to connect with my front end client? I’ve searched and found posts but they are a bit confusing, and when I try them it isn’t working, so I must be missing something.