Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Moving forum from MSSQL 2000 to MSSQL 2008
 New Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kdefilip
Starting Member

USA
4 Posts

Posted - 18 September 2013 :  20:43:34  Show Profile  Reply with Quote
Hi
Attempting to move forum from MSSQL 2000 to MSSQL 2008. Restored forum database on new server. I of course do not want to loose the data in the forum. In any event, when I do try to connect to the forum, I get the error: You need to create all the tables in the database before you can start using the forum.
What am I missing about this move?

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 September 2013 :  05:50:12  Show Profile  Send ruirib a Yahoo! Message
Is your database username the same, or was it changed?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

kdefilip
Starting Member

USA
4 Posts

Posted - 19 September 2013 :  22:38:44  Show Profile
The database user name is the same and the user is not orphaned.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 September 2013 :  04:47:42  Show Profile  Send ruirib a Yahoo! Message
I would check that the user has the same default schema that he had before. Probably if you use SQL Server Management Studio to access the server, you will see the tables with a different "prefix". If you can do that, ask the host. They can change the default schema really quick and the problem will be solved.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

kdefilip
Starting Member

USA
4 Posts

Posted - 20 September 2013 :  07:21:32  Show Profile
Hi Again
Yes, I checked to insure the db user is also the schema owner, table prefix is schema owner/user, yet I still get the "you must create the tables ..." error.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 September 2013 :  07:36:26  Show Profile  Send ruirib a Yahoo! Message
Doesn't matter if he is the schema owner, the default schema for the user is what matters, as the new tables "would" be created under this default schema.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

kdefilip
Starting Member

USA
4 Posts

Posted - 20 September 2013 :  08:45:25  Show Profile
Thanks a bunch. Got it. Had to issue the following and all is well:

USE MyDatabase;
ALTER USER MyUser WITH DEFAULT_SCHEMA = MyUsersSchema;

where MyDatabase is the forum DB
where MyUser is the forum user
where MyUsersSchema is the schema associated with the forum/user

Thanks again.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 September 2013 :  17:18:21  Show Profile  Send ruirib a Yahoo! Message
Great, glad you solved it :).


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.26 seconds. Powered By: Snitz Forums 2000 Version 3.4.07