The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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?
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?
Posted
Great, glad you solved it :).
Posted
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.
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.
Posted
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.
Posted
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.
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.
Posted
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.