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?
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.
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.
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 - 18 September 2013 : 20:43:34
