Newbie question
-
In a rush to get a DB running again. Doing a fresh install of SQL 2005. I have full backup of DB from SQL 2000. Easiest way to import the old version onto SQL 2005? Thanks.
-
Since you have a backup, just restore the database. When you do that, the database will be in 2000 compatibility mode. You will need to go into the properties and change it to 2005 compatibility mode if that is what you want.
-
Wow! Thanks for the quick reply. A follow-up, if you will: someone told me about having to get the "forms" from the old server to the new?
-
Okay... You will need to elaborate on that one. Not really sure what you are talking about regarding "forms".
-
Sorry, I didn't know exactly what they meant, either. Since I have a complete DB I think all should go well. Thank you again.
-
Sounds like an application was installed on the old server as well.
-
Well, I solved that problem only to encounter another. Now my user account coming from the ASP page is getting an "error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user..."
How should I set up the user account in SQL 2005?
-
When you restored the database, users become orphaned. They exist in the database, but not in the 'instance'. In Enterprise Manager, expand the database and look at the users. Compare them to the Logins in the main Security folder for the instance.
-SQLBill
-
Thanks SQLBill! That did the trick. I am a Newbie no more!
-
No offence but this title is a little bit harder than that to lose
. -
I don't doubt that at all.
-
But if you keep at it you might lose it in the first few months of answering questions here... like I did.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply