| Author |
 Topic  |
|
webby4x4
Starting Member
44 Posts |
 Posted - 19 May 2008 : 22:01:20
|
Thanks guys - I'll take a look a start over again. I'll keep you posted!
Rick< |
 |
|
|
Astralis
Senior Member
USA
1218 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2008 : 05:41:27
|
| I'd bet it's definitely not the same issue and please post in a single topic about any given issue you may have. Double posting will only make it more difficult to handle your request for help.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 12:29:01
|
OK... I didn't have any luck with that strategy either (excat same results).
On the old SQL 2000 server, I detached the db and did a full backup w/ logs. I then moved the backup file to the new SQL 2005 server. I restored the database from the .bak file and set the appropriate user permissions, etc. It still doesn't seem to see that there is data in the database, and it wants to run the full setup again, which I did. It seems to ignore all of the information in the tables (e.g. settings, posts, topics, etc.).
I also tried creating a new database first, setting it's compatability level to SQL 2000 (trying different things to get it to work), but I still get the same results.
The forums can see and talk to the database, but it thinks it's a brand-new set of tables and forces me to "create" them. Then it just doesn't see that there are already settings in there.
Podge - I tried following the instructions in the link you provided, but it doesn't speak to how you actually move the data from the old server to the new server, after it's detached. At this point, I assume you simply do a backup and restore, yes?
Thanks guys,
Rick< |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 12:55:08
|
disregard last post, I'm an idiot. :)
my old ISP is going to detach the db, then move the .mdf and log files manually to an FTP site, where I can grab them, then do the "attach" method which are in the instructions that Podge sent.
I'll report back and let everyone know if this works.
thanks team!
RW< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 13:03:56
|
OK... if the attach method doesn't work, should I create a new post, or just jump onto Astralis' post?
thanks Ruirib! You guys are fantastic!
Rick< |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 13:22:42
|
OK. I've followed the instructions that Pdge posted explicitly. I get the following error when I try and access the forums:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
Cannot open database "4x4review" requested by the login. The login failed.
So, here's what I did. I created a new user on SQL, set the schema to "dbo" and mapped it to that specific database. I also gave it every possible permission I could. I've also updated the config.asp file too - that error above still exists.
I've also tried referencing other UID/PW combinations in the config.asp file that were automatically associated with that db. When I do this, I'm told "You need to create all the tables in the database before you can start using the forum."
I feel I'm soooo close.
Rick< |
Edited by - webby4x4 on 24 May 2008 13:31:14 |
|
|
|
Podge
Support Moderator
Ireland
3775 Posts |
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 14:07:59
|
yes. I went into Security --> Users --> and then New User. I applied god-like permissions (just to be safe) and associated the schema to dbo.
Rick< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2008 : 14:10:23
|
| If you get the message that you need to create all tables, you're having a schema issue. Who was the owner of the tables in SQL Server 2000? If it was dbo, make sure you set db_owner as the default schema for the user you are now using to access the database.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 14:13:53
|
well... that's interesting! There is no schema associated with the same user on the old SQL 2000 db.
What do you think I should do at this point?< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 May 2008 : 14:15:48
|
Assign a default schema of dbo or db_owner to the user now, of course, if the owner in SQL 2000 was dbo.
The schema concept is new to SQL Server 2005. In SQL Server 2000, the user was the table's owner.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
webby4x4
Starting Member
44 Posts |
Posted - 24 May 2008 : 14:28:47
|
| OK... I did that and now I get "You need to create all the tables in the database before you can start using the forum."< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
